Automate Excel Reporting with Python - Python Excel Tutorial

Published: 19 January 2022
on channel: Koolac

523

📌 Tutorial on how to Automate Excel Reporting with Python - Python Excel Tutorial. In this video we use Pandas package (module) in Python programming language in order to aggregate several excel files and also to create a pivot table (group by) for the example. And finally we plot a bar chart for out pivot table (group by).

📦 Download Excel files (data files) at:
https://t.me/Koolac_Data/22

⏱TIMESTAMPS⏱
0:00 - Introducing the data files (excel files)
0:54 - reading excel files in Python programming language
2:12 - concatenate (aggregate) excel files in Python
2:44 - save data frame as excel file in python
3:38 - how to create pivot table (group by) in python
5:12 - how to plot bar chart from pandas group by in python

✍🏻 Please leave a comment if the video was helpful.

Also Recommended
===============================
📌 How to install PyCharm :
   • How to install PyCharm 2021.3.1 on Windows...
📌 How to make Animated plot with Matplotlib and Python - Very Easy !!!:
   • How to make Animated plot with Matplotlib ...
📌 How to add value labels on a matplotlib bar chart (above each bar) in Python:
   • How to add value labels on a matplotlib ba...
📌 What is Google Colab and How to use it? (for Python):
   • Google Colab Tutorial | What is it and how...
📌 Jupyter Notebook Tutorial playlist:
   • Jupyter Notebook Tutorial

#Python_and_Excel #Excel_Automation #pivot_table

On this page of the site you can watch the video online Automate Excel Reporting with Python - Python Excel Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Koolac 19 January 2022, share the link with friends and acquaintances, this video has already been watched 523 times on youtube and it was liked by 10 viewers. Enjoy your viewing!

262