Are You Still Using Excel? AUTOMATE it with PYTHON

If you do the same thing over and over in excel at work you should seriously consider automating it with Python and Pandas! I'll show you how to easily import several csv files into a dataframe, and create some summary pivote tables of the data to share.

Support Me:

[tomaszbara]

Using python in daily corporate tasks would be a great idea for a series. Thanks for this vid, I will use it in my project later :)

[thecodfather]

Thank you John! More pandas and Excel/Google Sheets related content please ☺ love your videos and long term subscriber ♥

[silkogelman]

Thanks for this video John!
I've been enjoying your data scraping videos A LOT.
And this new video about local data automation is very interesting too!

Being able to grab data from all kinds of sources and then produce something valuable with that is just amazing.
The CTRL+D / CMD+D PyCharm duplicate shortcut was the cherry on top.

[Kyosika]

You always create a video about a subject I'm working on. Perfect timing. Keep them coming!

[lamhintai]

I noticed that your previous videos were mostly done on VS code. Did you move away from VS Code to PyCharm?
By the way, your videos are very nicely done! All are straight to the point and without the fluff that are often found in other channels. :)

[dannytan]

Excel covers full stack i.e. UI, automation and Database. What you demonstrated is only for python to cover automation - you will need additional learning curve on Python UI and Database read write to replace excel use cases with python.

[multigladiator]

Always happy to be a subscriber. This is quality

[quzeem]

Hey John, first time coming across your video and I'm really impressed on how flexible you are with pandas on data..and just discovering the glob method also ..hopefully I get to learn more from your videos ....Thank you and have a wonderful day

[ahmedsayed]

Brilliant as usual 😉 i have scrapped a property website and it was containing many prop types( apartment, villa..etc every type in a single csv) and I wanted to concatenate them.

[prskis]

A super useful follow up vid would be xlwings. After all the data manipulation and calculations, to output it in a way properly formatted and looking nice, xlwings is a pretty good choice to add on to the automation.

[jeanchindeko]

I do like Python a lot and a few year ago that might have been the more effective way to do it. But since Excel include PowerQuery doing the same thing inside PowerQuery might be more easy for most people to reach the same result all without Excel and with a saved recipe that can be scheduled to have automated refreshed report.

[davestark]

I thought I knew Pandas well, and I thought I knew PyCharm well. 

CTRL+D, and pd.pivot_table were knew to me.... 

Good job. 

PS. SHIFT+F10, or CMD+R in Mac is the run shortcut in PyCharm.

[bisratgetachew]

Nice video, really like pandas. Hope we will see more pandas videos from you.

[leoblack]

I was thinking about this yesterday, thank you !

[mandarraut]

Hi John, Thankyou

Can you make more videos on excel automation using python

[divyasukumar]

Brilliant Video!! Please make moree videos on excel automation please

[engineerbaaniya]

Thanks for this type of Content please keep updating us

[AnonymousHunYaar]

Thank you John.. Please add visualization of the data as well

[fv]

Title is misleading . The excel files I see are monsters in terms of complexity . Your example is seriously simplistic . 😊

[keagankemp]

Randomly came across your vids and think it was the best thing ever, one thing I would like to ask though I have to match point of sale receipts (banked) to a the transactions(sales) the references are in some cases the same and some not( human intervention), could I create this matching using python? It kills me everyday I have to do it manually.