Could pandas use column as index?

by

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:

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

> df
     Locality    2005    2006
0  ABBOTSFORD  427000  448000
1  ABERFELDIE  534000  600000

> df.set_index('Locality', inplace=True)
> df
              2005    2006
Locality                  
ABBOTSFORD  427000  448000
ABERFELDIE  534000  600000

> df.loc['ABBOTSFORD']
2005    427000
2006    448000
Name: ABBOTSFORD, dtype: int64

> df.loc['ABBOTSFORD'][2005]
427000

> df.loc['ABBOTSFORD'].values
array([427000, 448000])

> df.loc['ABBOTSFORD'].tolist()
[427000, 448000]

More Related Contents:

  1. How to write to an existing excel file without overwriting data (using pandas)?
  2. Append existing excel sheet with new dataframe using python pandas
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. Convert Excel style date with pandas
  5. Pandas cannot open an Excel (.xlsx) file
  6. Import multiple excel files into python pandas and concatenate them into one dataframe
  7. Pandas: Looking up the list of sheets in an excel file
  8. append dataframe to excel with pandas
  9. pandas xlsxwriter, format table header – not sheet header
  10. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  11. Refresh Excel External Data with Python
  12. drop_duplicates not working in pandas?
  13. How can I see the formulas of an excel spreadsheet in pandas / python?
  14. How to obtain sheet names from XLS files without loading the whole file?
  15. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  16. Merge rows based on value (pandas to excel – xlsxwriter)
  17. From password-protected Excel file to pandas DataFrame
  18. Write to StringIO object using Pandas Excelwriter?
  19. Leave dates as strings using read_excel function from pandas in python
  20. Putting many python pandas dataframes to one excel worksheet
  21. Pandas: Reading Excel with merged cells
  22. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  23. Pandas: parse merged header columns from Excel
  24. Python Pandas – Read csv file containing multiple tables
  25. How to write to an existing excel file without breaking formulas with openpyxl?
  26. Appending Pandas DataFrame to existing Excel document
  27. Add Leading Zeros to Strings in Pandas Dataframe
  28. Vectorizing Haversine distance calculation in Python
  29. Updating value in iterrow for pandas
  30. Resample time series in pandas to a weekly interval

Leave a Comment