30 Days Of Python

Hi ,I have file 1, file 2,file 3 ,file 4 I want to load all file into single worksheet dynamic, please help me

What do you mean? What type of files, what worksheet?

You can use pandas to read the files individually and concat them together if they have the same columns

Okay

You can use the os module to file all CSV files in the directory, loop through the names. Pass the names into pandas read_csv method and then concatenate it to an existing data frame. When you're done you can save the dataframe as a new CSV file containing all the data from the files

Okay thank you