Pandas & Excel Automation | Learn Python | 8h Full Python Course | Lesson 15 (0-16)



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:
https://pandas.pydata.org/Pandas_Cheat_Sheet.pdf

T I M E S T A M P S
00:00 Introduction
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/

source

9 thoughts on “Pandas & Excel Automation | Learn Python | 8h Full Python Course | Lesson 15 (0-16)”
  1. getting an error – "'Workbook' object has no attribute 'add_chart'". What i am missing here?

  2. Hello Rune. Please help me with a small doubt. I generally get confused in the difference between the usage of single and double inverted commas.
    which which cases exactly do we use them?
    also let me make a guess: double inverted if we want to assign a string?
    and single inverted when assigning an element?
    Please assist!

  3. I tried today to follow this lesson and just FYI it doesn't work in Mac without a normal excel installed. 🙂 I tried with numbers and was not working. I will pass this lesson for now as im not willing to pay for Microsoft Office.. 😛 thanks anyway great lesson!

Leave a Reply

Your email address will not be published.

Captcha loading...