Python pandas strip header space

import pandas as pd

data = pd.read_csv('Data/JP225_H1.csv')
data.columns = [c.strip().lower().replace(' ','_') for c in data.columns]
data = data.set_index(data.local_time)

data = data[['open','high','low','close','volume']]

data = data.drop_duplicates(keep=False)

price = data.close.iloc[:9000]

Recommended Posts