read_csv python column name code example

Example 1: Column names reading csv file python

df = pd.read_csv('file.csv', names=['a', 'b', 'c'], header=None)
df.rename(columns = {'a':'A', 'b':'B', 'c':'C'}, inplace = True) 
df.to_csv('file.csv')

Example 2: read_csv separator

import pandas as pd

df = pd.read_csv('data.csv',sep=';')

# also working
df = pd.read_csv('data.csv',delimiter=';')