How to automate Data Analysis with Python? | Automate Excel | Automate Data Analysis | Python

In this video we will cover how to produce data analysis reports in Excel using Python. Previously we created well formatted excel reports. We filtered out the required data format and sent it to our end users.

We will build on this during this session. Rather than providing the data we can automate the actual data analysis that is consumed by the users. The final report will have header and sub header followed by a pivot table that summarizes the Sales by Product Category and Country. We present this data in a bar chart to give the users a visual representation of this data. Rather than creating this report manually we automate it on a weekly basis for our users.

#excel #python #dataanalysis

💥Subscribe to our channel:

📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣

-----------------------------------------

Topics covered in this video:
0:00 - Introduction to Data Analysis with Python
0:52 - Final Data Analysis Report
1:33 - Code Solution in Jupyter Notebook
1:54 - Import data into a DataFrame
2:14 - Pivot Table in Python
3:16- Column Chart Example
4:19 - Build Column Chart with our Data
6:49 - Save and Review the Final Report