import all csv as individual dataframes python
# Needed packages import glob import pandas as pd # Import all csv files files = glob.glob("Path/*.csv") # Import them as individual Dataframe count = 0 for f in files: count += 1 exec(f'df_{count} =pd.read_csv(f)') print(f'DataFrame: df_{count}')
Source: stackoverflow.com
# Needed packages import glob import pandas as pd # Import all csv files files = glob.glob("Path/*.csv") # Concatenate them into one Dataframe df = pd.DataFrame() for f in files: csv = pd.read_csv(f) df = df.append(csv) print(df)
Source: stackoverflow.com