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 convert datetime to timestamp
- What is opposite of melt() in Pandas
- How to convert yyyymmdd string to datetime
- How to left join dataframes
- How to convert column values to Int
- How to replace values in dataframe
- How to use melt() with dataframe - example
- How to set data frame index
- How to load dataframe from Excel (XSL)
- How to calculate 10th percentile for dataframe
See more codes...