No index in creating dataframe

Question

I create a small dataframe by these lines:

import pandas as pd
 
my_funds = [1, 2, 5, 7, 9, 11]
my_time = ['2020-01', '2019-12', '2019-11', '2019-10', '2019-09', '2019-08']
df = pd.DataFrame({'TIME': my_time, 'FUNDS':my_funds})

df

The output is then:

    TIME    FUNDS
0   2020-01     1
1   2019-12     2
2   2019-11     5
3   2019-10     7
4   2019-09     9
5   2019-08     11

Would it be possible to modify the code in order to create the dataframe without an index ? I was even not able... So, thanks for any hint.

Josie · Accepted Answer · 2021-04-20 19:39:04Z

5

A Pandas DataFrame needs an index, but you can set it to an existing column. If all your TIME entries are unique, you can do

import pandas as pd
 
my_funds = [1, 2, 5, 7, 9, 11]
my_time = ['2020-01', '2019-12', '2019-11', '2019-10', '2019-09', '2019-08']
df = pd.DataFrame({'FUNDS': my_funds}, index=my_time)

df

gives you

         FUNDS
2020-01      1
2019-12      2
2019-11      5
2019-10      7
2019-09      9
2019-08     11

answered Apr 20, 2021 at 19:39

Josie

1752 silver badges11 bronze badges

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

1 Comment

Andrew Over a year ago

OK. That's why I couldn't... Thanks

Collectives™ on Stack Overflow

No index in creating dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related