Indexing of DataFrame

Question

I've extracted data from a webpage by using pandas read_csv command. After extracting data I removed the first to row and converted column indexing. But when I try to convert index to date column I get an error every time. Following is the code.

    df=df.ix[2: , ]
    df.columns=['Date','Open','High','Low','Close','Volume']
    #df=pd.DataFrame(df,index=df.ix[:,0])
    #df=pd.DataFrame(df,index='Date')
    #df=pd.DataFrame(df,index=df.ix[:,0], usecols=['Date','Open','High','Low','Close','Volume']

I need a way out to make Date column as an index of DataFrame.

jagdish · Accepted Answer · 2017-02-20 20:34:03Z

2

df.set_index('Date', inplace=True)

answered Feb 20, 2017 at 20:34

jagdish

2591 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Furqan Hashim Over a year ago

Thanks a lot. Solved!

D_Lue · Accepted Answer · 2019-02-21 21:14:51Z

1

In case someone else finds this seeking for a solution for a similar problem: When using pandas read_csv command you can specify the column that will be used as index using the index_col method.

In the example below, the first column will be used as index:

df = pd.read_csv(filepath, index_col = 0)

answered Feb 21, 2019 at 21:14

D_Lue

132 bronze badges

Collectives™ on Stack Overflow

Indexing of DataFrame

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related