Introduction

Ever wonder how to use data analysis in your document, blog post, or report? There are many ways, but oftentimes the most popular is using the Python pandas package. With its high level of abstraction and easy-to-use functions for importing and manipulating data sets, the panda is an excellent choice for beginners wanting to learn about data science in a doable way. In this post, we’ll examine what makes pandas so great.

We’ll look into how you can import your dataset from CSV files into a DataFrame object, manipulate that dataframe with methods such as groupby() and pivot_table() , visualize it with plot() , and make predictions on new variables using machine learning models. Data analysis skills can only be acquired through practice. Here are some questions to help you train and improve your skills. You can use any dataset you want. If you are new to data analysis, you may want to check out the best data science training in Kochi.

Questions

1. Find the number of observations in the dataset?

2. Find the number of columns in the dataset?

3. Print the name of all the columns.

4. Find the type of observation?

5. Get the first 25 observations from the dataset?

6. Get the last 25 observations from the dataset?

7. Print index of the dataset.

8. Find unique features from the dataset?

9. Summarize the given dataset using the built-in method.

10. Select every row after the fourth row and all columns.

11. Select every row up to the 4th row and all columns.

12. Select the 2nd column up to the 4th column.

13. Capitalize all observations using apply.

14. Multiply every number of the dataset by 10.

15. Create a DataFrame by joining the Series by column.

16. Create a one-column DataFrame with the values of the 3 Series and assign it to ‘bigcolumn’.

17. Reindex a DataFrame.

18. Create the following plots – scatter,bar,barh,hist

19. Create DataFrame and Series.

20. Import data from external source(csv,excel,dat).

Conclusion

Here we have practiced some of the challenges that are commonly encountered in data analysis. You can do more assignments, we will continue to update you with new questions in the coming posts, stay in touch. If you want to know more about Data Science and Data Analysis, check out the data science training institute in Kochi.