Learn how to use Pandas to create Excel sheets with charts – all from Python.
In this lesson we will get a short introduction to Pandas data structure DataFrames, which are very similar to Excel sheet. Among the things we will master with Pandas, is filtering and GroupBy operations. We will learn how to read data properly from an CSV file into Pandas DataFrame. From the DataFrame we will export it to an Excel sheet and insert charts of the data.
In the project we will read a sales dataset and make some nice Excel sheets with charts representing the sales reps.
Pandas Cheat Sheet:
T I M E S T A M P S
01:07 Introduction to Pandas
02:35 importing pandas
03:08 A simple example of a DataFrame (Pandas) from a dictionary
05:40 The mean function of a DataFrame
06:18 If condition with DataFrames
07:19 Using GroupBy with DataFrame
08:56 The dataset to use
09:45 Read CSV files with Pandas into a DataFrame
10:55 Adding a delimiter to the CSV reader in Pandas
12:40 Reading dates as dates with CSV reader in Pandas
14:35 Group data by Month in Pandas DataFrames
15:55 Changing the index to have month names
16:58 Exporting a DataFrame to an Excel sheet
18:32 Using ExcelWriter to make multiple sheets in Excel from a Pandas DataFrame
21:13 Adding a chart in Excel from Python
25:02 Project Description
29:11 Project Solution
C O U R S E R E S O U R C E S
▸ Lesson Post: https://www.learnpythonwithrune.org/csv-groupby-processing-to-excel-with-charts-using-pandas-python/
▸ Course Page: https://www.learnpythonwithrune.org/learn-python/
▸ GitHub (Notebooks): https://github.com/LearnPythonWithRune/LearnPython/
▸ FREE Python eBook: https://www.learnpythonwithrune.org/learn-python/
D E S C R I P T I O N
• Learn Python for Beginners.
• A 8 hour full Python Course.
• Including FREE eBook and Jupyter Notebooks.
C O U R S E L E A R N I N G O B J E C T I V E S
• Create 17 projects including Machine Learning.
• Understand and use variables.
• Use lists and dictionaries.
• Program flow with if-statements and loops.
• How to create functions.
• Using randomness in a program.
• Created simple games.
• Read and process CSV files.
• Object-Oriented Programming (OOP).
• Visualization of data.
• Created projects with NumPy and Pandas.
• Created a Machine Learning model from scratch.
• Recursive functions.
• List comprehension
S T A Y C O N N E C T E D
▸ Facebook: https://www.facebook.com/learnpythonwithrune
▸ Twitter: https://twitter.com/PythonWithRune
▸ Blog: http://learnpythonwithrune.org
▸ Online courses: https://www.learnpythonwithrune.org/my-online-courses/