python-pandasHow to convert dataframe to list of lists
As opposed to converting single column values to list we can also convert full dataframe to list:
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Phone Price': [204, 304, None, 405, None]
})
list = data.valuesctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
.valuesreturns dataframe values as an multidimensional array | listwill contain final list of lists |
Usage example
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Phone Price': [204, 304, None, 405, None]
})
list = data.values
print(list)output
[['US' 'ip5' 204.0]
['US' 'ip6' 304.0]
['US' 'ip8' nan]
['KR' 'sms' 405.0]
['KR' 'xi' nan]]
More of Python Pandas
- How to convert column values to Int
- How to replace values in dataframe
- What is opposite of melt() in Pandas
- How to load dataframe from Excel (XSL)
- How to drop duplicates from dataframe
- How to join dataframes
- How to query dataframe using multiple conditions
- How to convert column object values to String
- How to load dataframe data from SQL query
- How to find dataframe max
See more codes...