merge_csv_files.py

import os
import pandas as pd

all_files = os.listdir()
csv_files = [i for i in all_files if i.endswith(".csv")]
print(f'Found {len(csv_files)} files.')


def merge_csv_files(csv_files):
    df = pd.DataFrame()
    for count, csv in enumerate(csv_files):
        file = pd.read_csv(csv)
        file["index"] = count
        df = df.append(file, ignore_index=True)
        print(
            f"{count} / {len(csv_files)}",
            "completed!",
            round(count / len(csv_files), 2) * 100,
            "%",
        )
    print("Done!", df.shape)
    return df


def save_csv_files(csv_files):
    df = merge_csv_files(csv_files)
    print("Saving CSV files...")
    df.to_csv("merged_csv_files.csv", index=False)


def main():
    save_csv_files(csv_files)


if __name__ == "__main__":
    main()