In this course, you will learn how to start using pandas from end-to-end: from getting your data into pandas; using pandas to manipulate, transform, analyze, and visualize data; to ultimately taking your transformed data out of pandas into any number of formats.
This course will get you (or anyone who has never used pandas) started on using it as a complete end-to-end data analysis workflow. You will start by setting up Python, pandas, and Jupyter notebooks. You will learn how to use Jupyter notebooks to run Python code. We will then show how to get data into pandas and do some exploratory analysis. You will learn how to manipulate and reshape data using pandas methods. You will also learn how to deal with missing data from your datasets, how to draw charts and plots using pandas and Matplotlib, and how to create some cool visualizations for your audience. Finally, you will wrap-up your newly gained pandas knowledge by learning how to get data out of pandas into some popular file formats.
About the Author
Harish Garg is a Data Analyst, author, and Software Developer who is really passionate about Data Science and the Python programming language. He is a graduate from Udacity's Data Analyst Nanodegree program. He has 17 years of industry experience, which includes data analysis using Python, developing and testing enterprise and consumer software, managing projects and software teams, and creating training material and tutorials. Harish also worked for 11 years for Intel Security (previously McAfee, Inc.).
He regularly contributes articles and tutorials on data analysis and Python. He is also active in the open data community and is a contributing member of the Data4Democracy open data initiative. He has written data analysis pieces for think tan takshashila.
Exploring pandas read CSV method to work with CSV-based datasets.
Exploring ways to work with an Excel dataset in pandas.
Explore working with different kinds of datasets in pandas apart from CSV and Excel.
Learn techniques on how to select a subset of data in pandas as Series.
Explore methods to select multiple rows and columns from a dataset in pandas.
Explore sorting techniques on a pandas DataFrame or a series.
Learn various methods of filtering data in pandas.
Learn how to apply multiple filters to a pandas DataFrame.
Learn how to use the "axis" parameter in pandas.
Learn how to use string methods on series data in Pandas.
Learn about how to change the datatype of a pandas series.
Learn about modifying a Pandas DataFrame original object.
Learn how to split and aggregate data in groups using the “groupby” method.
Explore how we can use various Pandas techniques to handle the missing data from our datasets.
Explore how to set index and use it for data analysis in pandas.
Learn various methods for renaming column labels in pandas.
Learn how to remove columns or rows from a dataset in pandas.
Learn how to work with date and time series data in pandas.
Learn what is “SettingWithCopyWarning” and how to get around it.
Learn how to apply prebuilt and your own functions to Pandas Data objects.
Learn how to combine two or more DataFrames using Pandas merge and concat methods.
Learn how to get started with plotting and control plot aesthetics.
Learn how to change the colors of a plot and work with plot color palettes.
Learn how to plot categorical data with seaborn.
Learn to plot with data aware with grids using seaborn.
Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.
With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.
From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.
Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.