i have multiple csv files saved in one folder with the same column layout and want to load it into python as a dataframe in pandas.
The question is really simliar to this thread.
I am using the following code:
import pandas as pd
salesdata = pd.DataFrame()
for f in glob.glob("TransactionData\Promorelevant\*.csv"):
appenddata = pd.read_csv(f, header=None, sep=";")
salesdata = salesdata.append(appenddata,ignore_index=True)
Is there a better solution for it with another package?
This is taking to much time.