Combine Excel Files with Python | Beginner Friendly | Excel Python Automate with Pandas

In this video we create two scripts with python to combine excel files!
We're using fitbit sleep data to illustrate this. If you have your own fitbit, it would be cool if you used your own, but if not you can go to my github and download the files I used:

Timestamps:

2:15 : Concatenate all excel files into one excel workbook in the same sheet
8:50 : The first script fully written out

11:06 : Multiple excel files into one excel workbook but into different sheets
15:17 : The second script fully written out

10:12 : Make sure to close the excel file you created before running or you'll get an error

15:14 : Like, Comment, Subscribe

#pandas #exceltopython #automatewithpython

[walkantalk]

Thank You, Laura, for this great tutorial ! No fluff and to the point - keep it up

[cdisla]

Really needed to see this tutorial!! thank you so much for this!!

[MrJohnbrown]

Amazing, this saves me a ton of repetitive copy pasting every Monday. Cant wait for more vids. Many thanks

[bleharris]

You're a star, very simple and to the point tutorial. Thank you.

[johnobiomah]

Thank you. This worked perfectly for what I needed it for

[michaelcrain]

I am just now learning python and this is just what I needed to start with. Thank you for making this.

[akanobody]

Perfect, thanx I have to do many repetitive excel sheet cleaning and this tutorial is very helpful for me, I just hope this can handle the amounth of data I work with.

[binarystar]

Welcome to you tube :) and wanted to see more of the videos related to pandas tips and tricks

[Oostenwald-sq]

You made this look very easy.

Please, please, please make more of these Python videos. I extract information from 18 different Excel files and consolidate the relevant data from each file to create a report on a single Excel sheet. There must be an easier way to accomplish this, as my laptop struggles to execute all the commands and formulas I use.

[jenniferdios]

pandas is so awesome. Need to get more familiar with it. Thanks for this tutorial!!

[SalehGoodarzian]

I appreciate your helpful, concise, and very friendly video. It helped me a lot. I had spent hours to find a very short way to import all excel/csv files. Your video showed me the way. I really appreciate and I wish you all the best...I share what I did in only 5 lines, I can't thank you more (please note my code is saved in the folder with csv files...).

files = glob.glob('*.csv')

data = pd.DataFrame()
for file in files:
current = pd.read_csv(file)
data = pd.concat([data, current], axis=0)

[lpiueos]

Explained it very clearly.... Thank u 😊

[SuperNunera]

Gonna use that today ! Ty for sharing !

[sirajmultani]

Thank You Laura, it really helped me and saved hours of work. I really appreciate! please keep up the good work !!!

[MuhammadAdeelAhmed]

Thank you Laura, something I learnt today, very well explained, excellent work

[rikardoledal]

Thank you!! I love excel and are now learning to code Python. It was a great video. I'm subscribing :)

[shubhamgade]

Thanks for the content!!
If possible can you make a tutorial on joining 2 excel sheets on basis of one common column between the two files? So as the values in second excel with join the values in first excel.

[ngrunoz]

Thank You Laura for the great tutorial.

I have a scenario were I would like to combine only sheet with same name from various workbooks and either write each sheet for similar sheet names or a concatenated csv file for similar sheet names.

[patrickwheeler]

Thanks for putting this together! Would love to see you add some logic to look for last row of an empty data set and omit the rest of the rows, like foot notes from some reporting systems. EIther way this was very helpful!

[miladghalehnoei]

it was very helpfull for me. thank you so mach