How To Automate Excel Using Python | Combine Files & Create Charts 🤓

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I will show you how you can automate your excel tasks using python.
In particular, I am going to show you how you can combine excel files & create charts out of them.

✅ Chapters:
0:00 Intro & Overview
2:27 Python Code
10:20 Outro

Python Code and files used in the tutorial [GitHub]:

Pandas Cheat Sheet:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[calmlife]

I was using string function to seperate the month, year data into a column . This is very useful sir !! Looking forward more informative videos🔥

[mohammadjavadderakhshan]

Thanks to your tutorial and codes 15 hour work done Automatically without human interference.

[dominospizzach]

This is amazing! I love your channel. You're super helpful!!

[niueankid]

Thanks quite straightforward . I am a business analyst looking to expand on my excel knowledge

[anasalhariri]

Awesome, thank you, I subscribed. this is my first time visiting your page. Please, keep it up! <3

[SaulEduardoo]

Great example!, this is exactly the kind of content I was looking for 😊☺

[vitus]

Good tutorial. Thank you for this, just awesome

[joiepatsy]

Thankyou sir, very good explanation. Sir you told that we can import to power point? how can we make it? can we import the table as well to ppt? thankyou so much, i subscribed

[AjinkyaBayani]

this was most unique video and helpfull plz guide us more

[usamajunaid]

Great!
If you are also the user of R Language then please make videos like this in RStudio to automate excel like data manipulation and conditional formulation for excel in RStudio

[ahmadmojeed]

Thanks for the amazing work.
Haven't gotten a reply yet though, what if there's a different folder directory, the both have same column name but different content, how do we merge?

For example, there's folder A that contains January to March sales and folder B has January to March sales also but different sales input. How do we merge per column, merge folder then have the January in one xlsx file, February in one and the whole of march in one xlsx also

[lorenzoladejobi]

Very informative !!. Thank you for this.

[maramsrinureddy]

Great content in the video, how to create multiple sheets in the excel doc using pandas, is there a way ?(example: - create 3 sheets for 3 months data), is it possible ?

[sagarmhta]

Your videos are really helpful;
How we can learn python from scratch?

[anasofia]

Hello there, I have a problem ! I want to get information from excel per client. Meaning, I'd like to input the client's name and then extract some of the data from THAT client (I have an excel report with different data from different clients) - not sure what library / module / functions to use. Any ideas? Many thanks. Excellent videos !

[rryirup]

Hello! Tell me how to automatically select a function for data in Excel, for example, for the R^2 criterion: polynomial, linear or cubic? Or automatically compose a step function. Are there any built-in functions for this in Excel? Or maybe in Python? Sincerely!

[rohithd]

Which is the editor tool that you have used to write python code?

[anasalhariri]

I have a question if you don't mind. I would like to reformat the date to MM /DD/YYY how can I do that, please?

[RajneeshKumar-vrqj]

Nice tutorial btw same work could be done by power query or vba much faster

[asensiodias]

Which editor you use for Python or what ide is good for it