Could pandas use column as index

Question

I have a spreadsheet like this   Locality    2005    2006    2007    2008    2009  ABBOTSFORD  427000  448000  602500  600000  638500 ABERFELDIE  534000  600000  735000  710000  775000 AIREYS INLET459000  440000  430000  517500  512500   I don t want to manually swap the column with the row  Could it be possible        to use pandas reading data to a list as this   data  ABBOTSFORD    427000 448000 602500 600000 638500  data  ABERFELDIE    534000 600000 735000 710000 775000  data  AIREYS INLET    459000 440000 430000 517500 512500

User · Answer

You can change the index as explained already using set_index. You don't need to manually swap rows with columns, there is a transpose (data.T) method in pandas that does it for you:

> df = pd.DataFrame([['ABBOTSFORD', 427000, 448000],
                    ['ABERFELDIE', 534000, 600000]],
                    columns=['Locality', 2005, 2006])

> newdf = df.set_index('Locality').T
> newdf

Locality    ABBOTSFORD  ABERFELDIE
2005        427000      534000
2006        448000      600000

then you can fetch the dataframe column values and transform them to a list:

> newdf['ABBOTSFORD'].values.tolist()

[427000, 448000]

User · Answer

You can set the column index using index col parameter available while reading from spreadsheet in Pandas   Here is my solution    Firstly  import pandas as pd   import pandas as pd Read in filename using pd read excel    if you have your data in a spreadsheet  and set the index to  Locality  by specifying the index col parameter   df   pd read excel  testexcel xlsx    index col 0   At this stage if you get a  no module named xlrd  error  install it using pip install xlrd  For visual inspection  read the dataframe using df head   which will print the following output  Now you can fetch the values of the desired columns of the dataframe and print it

User · Answer

Yes  with set index you can make Locality your row index   data set index  Locality   inplace True    If inplace True is not provided  set index returns the modified dataframe as a result   Example    gt  import pandas as pd  gt  df   pd DataFrame    ABBOTSFORD   427000  448000                          ABERFELDIE   534000  600000                        columns   Locality   2005  2006     gt  df      Locality    2005    2006 0  ABBOTSFORD  427000  448000 1  ABERFELDIE  534000  600000   gt  df set index  Locality   inplace True   gt  df               2005    2006 Locality                   ABBOTSFORD  427000  448000 ABERFELDIE  534000  600000   gt  df loc  ABBOTSFORD   2005    427000 2006    448000 Name  ABBOTSFORD  dtype  int64   gt  df loc  ABBOTSFORD   2005  427000   gt  df loc  ABBOTSFORD   values array  427000  448000     gt  df loc  ABBOTSFORD   tolist    427000  448000

[python] Could pandas use column as index?

Examples related to python

Examples related to excel

Examples related to pandas