Rename csv columns in a folder of multiple csv

Question

I have about 200 CSV files in a folder and some of the columns are not named the same for instance there is 'App name' ,'App Name' and 'app name' so I want to rename the this kind of columns to a standard name like 'App Name' and concatenate all the CSV's to one CSV file,

loop over files. use pandas to read. concat dataframes. set column names — luigigi, Feb 14 '20 at 08:54
The amount of columns is the same, I just do not know how to loop through it — Khutso Mphelo, Feb 14 '20 at 08:57
check out [this](https://stackoverflow.com/questions/20906474/import-multiple-csv-files-into-pandas-and-concatenate-into-one-dataframe) — luigigi, Feb 14 '20 at 09:27

score 1 · Answer 1 · answered Feb 14 '20 at 09:30

That would work:

import glob
import os

import pandas as pd

folder = 'the folder path'
filenames = [i for i in glob.glob(folder + os.path.sep + '*.csv')]
combined_csv = pd.concat([pd.read_csv(f, skiprows=1) for f in filenames])
combined_csv.columns = ["all the header labels"]

Jiajia Zheng · Accepted Answer · 2020-12-12T02:54:51.380

import glob
import pandas as pd

csv_folder = '/Users/yourname/folder_containing_csv/*.csv'

csv_file_list = []
for csv_path in glob.glob(csv_folder):
    csv_file_list.append(csv_path)

for i in range(len(csv_file_list)):
    df = pd.read_csv(csv_file_list[i], index_col=0)
    df = df.rename(columns={"old_name": "new_name"})
    file_name = str(csv_file_list[i]).split('.csv')[0].split('/')[-1:][0]  # get file name by subsetting the path
    df.to_csv('/Users/yourname/%(file_name)s.csv'%{'file_name': file_name}) # save to .csv using the same file name

Rename csv columns in a folder of multiple csv

2 Answers2