PANDAS PRACTICE

DATA WRANGLING EXERCISES

DESCRIPTION

Designed specifically for aspiring data analysts and data scientists, this Pandas practice will equip you with the skills needed to tackle real-world data management tasks.
With more than 40 data wrangling exercises, you will acquire the basic knowledge about Pandas and other libraries required to work with data in the real world. There are also visualization and python data analysis exercises as well as some python coding.
Each exercise simulates the challenges faced by professionals in the field, allowing you to gain hands-on experience and develop the confidence to handle complex data sets. After finishing, you will have honed your data wrangling skills and be well-prepared to excel in a data-driven environment.

Why is so important to work on real-life pandas exercises?

1. Real tasks: Practice on exercises that mimic the tasks faced by data analysts and data scientists on a day-to-day basis.
2. Comprehensive coverage: Cover all the important aspects of data management, from importing and exporting data to advanced techniques like merging and joining datasets.
3. Hands-on experience: Gain practical experience by working on diverse datasets and solving challenging problems.
4. Step-by-step guidance: Clear instructions and explanations guide you through each exercise, ensuring you understand the concepts behind the tasks.
5. Self-paced learning: Access the exercises on the pdf and complete them at your own convenience, fitting them into your busy schedule.

INSTRUCTOR

Anastasia Migunova is a data scientist with wide experience in  big consulting firms among others. Currently based in Germany, she holds a Ph.D. in Applied  Maths and M.A. in Computer  Science.

WHAT YOU WILL PRACTICE

– Python Libraries: Pandas, numpy, datetime, matplotlib and  seaborn. The Python data wrangling exercises are focused  on:
– Import/export  gzip, csv and Excels
– Remove, select, rename, filter columns and rows
– Nulls
– Data types
– Groupby
– Filters
– Outliers and duplicates
– Convert long to wide format
– Basic Regex.
– Date formats.
– Data engineering
– Numpy
– One hot encoding
– Merge and joins
– Loops (for)
– Visualization: boxplot, bars, countplot, scatterplot, heatmaps, pairwise, etc.

DOWNLOAD / CONTENT

After purchase, you will receive an email with a ZIP file. The download is always available on your Practity account.
The ZIP includes:
1) One PDF with the exercises description.
2) A link to the datasets of the exercises. The datasets are public data.
3) A Jupyter Notebook file with the solutions. It contains not only the source code but also detailed explanations and comments about how the code works.
IMPORTANT: to see the solutions (Notebook) you need to have jupyter or ANACONDA package installed on your machine. If you do not have it,  you may download it here. It is free.

VERSION
Python 3.7

CONTACT
If you need additional information, do not hesitate to contact us.