Automate Excel Reporting with Python! Combine Workbooks and Add Charts with Pandas and Openpyxl

Подписаться 5 тыс.

Просмотров 4,3 тыс.

50% 1

Learn how to automate boring Excel reporting with Python, by combining workbooks, adding styles, and adding a chart! Learn how to use the Pandas and Openpyxl libraries in this hands-on tutorial.
Download the files here: github.com/datagy/mediumdata/...
0:00 Introduction
0:19 Overview
0:59 Installing and Importing Libraries
2:20 Combine Multiple Excel Workbooks with Python
6:45 Summarize Excel Data with Pivot Tables in Python
9:17 Adding Header Rows to Excel with Python
14:09 Adding Charts to Excel with Python
19:30 Adding Formatting to Excel with Python
----------------------------------------------------------
✅ Follow me on other platforms:
Website: datagy.io
Twitter: / datagyio
Mailing List: mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@sandervalentijn6471 2 года назад

Dude, another great video. This is going into my reference playlist as it will be very usefull. Love the ‘os’ use here, which looks more versatile than glob, which I used before.

@datagy 2 года назад

Thanks so much, Sander!

@karolyna6028 3 месяца назад

nice!

@user-rz7ko4rc5q Год назад

Thanks you, but how can I edit lebel on the charts, and hide grid ?

@ningliu3648 2 года назад

Thank you for the great video. by any chance do you know how to customize the chart style? I have tried to use chart.style = 23 to change it. However, even though I loop out all the available styles, there is no one same as the one I manually created from my excel.

@datagy 2 года назад

Hi Ning! Thanks for your comment :) That should technically work. You can add additional customization by using the additional styling options covered here: openpyxl.readthedocs.io/en/stable/charts/pattern.html Let me know if you have any questions!

@tridibbiswas3361 2 года назад

Thank you for another excellent video. I was wondering if the same can be done with shutil, learning from your other video of renaming files. Are there any pros and cons or can we use both the use os module say for listdir and the shutil for finding out the name of the file. Are there any best practices for the which module to use or the number of modules to use. BTW what's the colorscheme you are using in VSCODE

@datagy 2 года назад

Hi Tridib! Thanks for your comment :)! That's a great question. The shutil library, as far as I know, doesn't support listing out the files in the same way (it's more meant for moving and copying files). I think it's a great point though - there are a good number of libraries to do similar things. For example, the Pathlib library provides a more object-oriented approach. I'd say, choose one that you like the format of and use that one :) The theme is Github Dark Dimmed: Name: marketplace.visualstudio.com/items?itemName=GitHub.github-vscode-theme which is probably my fav theme!

@tridibbiswas3361 2 года назад

@@datagy You are right I got mixed up between shutil and Pathlib. Thank you for your briiliant practical videos and sharing your knowledge with noobs like me

@yannhk Год назад

Hello, is there a way to summarize the Excel data using Excel's pivot table by Python?

@datagy Год назад

Hey there! Yep but you’d need to use different libraries such as pywin32 :)

@Windiddy Год назад

Hi when I did "ws.insert_rows(0, 3)", I got "AttributeError: 'Worksheet' object has no attribute 'insert_rows'

@Windiddy Год назад

NVM - I figured it out. I had to update my pyxl module

@felipelandim2881 2 года назад

For me, the most annoying thing when automating Excel with Python is to AutoFit the columns. Every now and then the code just crashes. If there's a simple option for that in future videos, I'll apreciate it.

@datagy 2 года назад

Interesting! I’ll take a look at it :)