python-pandasHow to get dataframe row by index
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Price': [204, 304, 102, 405, 350],
'Used': [150, 250, 80, 320, 280]
})
row = data.loc[3]ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
.loc[returns row by given index | [3]will select 4th row (indexes start with |
rowwill contain selected row | |
Usage example
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Price': [204, 304, 102, 405, 350],
'Used': [150, 250, 80, 320, 280]
})
row = data.loc[3]
print(row)output
Vendor KR
Phone sms
Price 405
Used 320
Name: 3, dtype: object
Related
More of Python Pandas
- How to inner join dataframes
- How to use melt() with dataframe - example
- How to set data frame index
- How to convert dataframe to list of lists
- How to left join dataframes
- How to convert column values to Float
- How to convert column object values to String
- How to melt() multiple columns
- How to replace strings in dataframe column
- How to convert Pandas Series to list
See more codes...