python-pandasHow to get rows from dataframe by column value
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]
})
rows = data[data['Phone'] == 'ip8']ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
'Phone'column name to filter by | ip8column value to find rows by |
rowswill contain found rows | |
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]
})
rows = data[data['Phone'] == 'ip8']
print(rows)output
Vendor Phone Price Used
2 US ip8 102 80
More of Python Pandas
- How to load dataframe from Excel (XSL)
- How to convert column values to Int
- How to convert yyyymmdd string to datetime
- How to use melt() with dataframe - example
- How to set data frame index
- How to convert column values to Float
- How to convert column object values to String
- What is opposite of melt() in Pandas
- How to melt() multiple columns
- How to disable Pandas warnings
See more codes...