🚀 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]:
👉 https://github.com/Sven-Bo/combine-excel-files-with-python
Pandas Cheat Sheet:
👉 https://bit.ly/33K8DXp
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website: https://pythonandvba.com
📝 GitHub: https://github.com/Sven-Bo
⭐ Discord: https://pythonandvba.com/discord
▶️ Subscribe: https://youtube.com/c/CodingIsFun?sub_confirmation=1
🎉 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆
Get it here: https://pythonandvba.com/mytoolbelt
📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: https://pythonandvba.com/resources
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
https://pythonandvba.com/coffee-donation
source
Do you know Django? With your skills, you could definitely create some amazing softwares!
Hi. The .append is deprecated, how would we use .concat in this example?
Excellent
Thanks quite straightforward . I am a business analyst looking to expand on my excel knowledge
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
Thanks to your tutorial and codes 15 hour work done Automatically without human interference.
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 ?
Great job! Thank you!
Which editor you use for Python or what ide is good for it
Can you make video explaining all three activities like sending excel through whatsapp, saving it on cloud and sending through web app?
This is amazing! I love your channel. You're super helpful!!
Hey, that is a superb video. I am a newbie to python. When I try to execute, it is showing this error.
ValueError: Invalid file path or buffer object type: <class 'list'>
Hi, i get an error when tried to get aggregate % of 2 different variable-equation for Reject %.
# df['%'] = df['Reject / (Pcs)'].sum()/df['Dip Qty / (Prs)'].sum() ; this gives error.
Do you have any clue for this? Thanks 🙂
Great example!, this is exactly the kind of content I was looking for 😊☺
Any tutorial sending the file via WhatsApp?
Please make vdeo on progress bar, to show much file is uploaded after pd_read.excel
Which is the editor tool that you have used to write python code?
I want to know how we will run the automation task? Like we go to excel,, click on macro and run macro build by VBA but for python how and from where to run the automation.
Please help me. How can i append stock data of multiple stocks in excel file and sheetname as stock symbol name. I am using excelwriter but while appending the exusting data being deleted.
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
I was using string function to seperate the month,year data into a column . This is very useful sir !! Looking forward more informative videos🔥
The date,month segregation shown in the video is very useful for analysis. 💥💥💥
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?
Awesome, thank you, I subscribed. this is my first time visiting your page. Please, keep it up! <3
Pls need help. How can I explote data detail from a excel pivot table then save in a new file with Python? I need automate a excel report.