python-pandasHow to convert dataframe to list
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]
})
values = data.values
list = values.flatten()ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
.valuesreturns dataframe values as an multidimensional array | .flatten()flatten given multidimensional array to single dimension |
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]
})
values = data.values
list = values.flatten()
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 Float
- How to join dataframes on multiple columns
- What is opposite of melt() in Pandas
- How to left join dataframes
- How to convert column values to Int
- How to count dataframe NaN rows
- How to use multiple conditions in mask()
- How to convert column object values to String
- How to save dataframe to XML file
- Get current year
See more codes...