Cnsolidating/Combining multiple excel files together with the help of Python & Pandas

Cnsolidating multiple excel files together with the help of python & pandas | Combine Excel Files with Python

If you are wroking in Data Industry then certainly your day to day job involves dealing with many csv/excel files consolidation which makes the task really tedeous and make your work boaring, that's where we bring you this video which will help you do this task automatically.

This video covers:
00:00 - Introduction
02:24 - Import libraries
02:52 - Input and Output loaction assignment to python variables
03:56 - Creating list of input files
05:10 - Reading all the excel files one by one, consolidating them altogether and exporting it to excel automatically with the help of FOR LOOP

[ajaykushwaha]

The topic/problem description you choose are best.

[arunm]

Hi,

This is very helpful but i have a question what if my business need is to see only one file with all these excel but i dont want to append it rather i want electronics in separate sheet, Fashion in separate sheet of single workbook what logic can be use in that case

Thanks

[musavirhussainburiro]

Iam finding dificulty in excuting the code please help me with this. error in the part below
finalDF = pd.DataFrame()
for files in filelist:
if files.endswith(".xlsx"):
df =
finalDf = finalDf.append(Df)


"NameError: name 'finalDf' is not defined" please help

[SameerAli-nmxn]

Sir I am doing everything as shown in video but the values is not showing any n my newdf. How to resolve it please help

[kritikasomani_iift]

Hi how do I make a column in the consolidated file that states the original file name of the data

[yogeetagoyal]

Sir I m beginner for python, how to work with this Jupyter. I need to install or something else..plz let me know

[V.MITHUNCHANNEL]

super, can please do some videos on merging multiple excel files with multiple sheets to one master excel files with sheets

[sulaimanshah]

Hi sir great video. But what if I want to add new data into the final output? How would I do that then?

[dhanuandey]

what if each file has multiple sheets in it and we have to combine each sheet respectively.i.e, sheet1 in file 1 combined with sheet 1 in files and sheet 2 file1 with sheet2 in file2...

[howard_roark]

hello thanks for explaining! This is throwing me the following error : "OptionError: "No such keys(s): 'io.excel.zip.reader'"
could you please help me

[ajaykushwaha-jemw]

Excellent Sir, this is destination where I find answer of all my question.

[choomeiz]

Hi, is this the same method to combine if the files each have different headers?

[anhnhatnguyet]

How to access Localhost like this video?

[estebanrojas]

nice video !, i am working on a script for some bank excel files. Is there any of your videos talking about appending an existing sheet?

[erniehsieh]

Great video, when I used the code it gave me an error of list index out of range, any idea why that might happen ?

[ivan]

Hi, i try to run ur code and it said "DataFrame' object has no attribute 'append'", i read some article and try to change it with concat and it still doesnt work. Is there any idea on this? Thanks in advance.

[maracuyapassionfruit]

Mate, thank you very much. However, this will only work if the Excel files have only one sheet, right? What about if those Excel files have many sheets and I only want to append the sheets with a specific name?

[pambharronak]

For a specific sheet
df = pd.read_excel(input_loc + files, sheet_name = ' your sheet name')

[SandeshMahankal]

Hi, Well Explained... Really really Appreciated. Thanks a lot. Good going.

[alikhanak]

How can i add file name from which the data is fetched in the concat file.