process_csv

import os
import pandas as pd
files = os.listdir(".")
csv_files = [file for file in files if '.csv' in file]
for file in csv_files:
    table_name = file.lower().replace(".csv", "").replace(" ", "_")
    df = pd.read_csv(file)
    org_columns = df.columns.to_list()
    new_columns = [column.lower().replace(" ", "_") for column in org_columns]
    n = len(org_columns)
    new_columns_dict = {}
    for i in range(n):
        new_columns_dict[org_columns[i]] = new_columns[i]
    df.rename(columns=new_columns_dict, inplace=True)