在用pandas进行数据处理过程中,经常会遇到dict、list、series、dataframe之间相互转换的场景,今天特意整理了一下,以备自己后面再次遇到可以快速解决,
分享出来也方便大家
# dict、list、series、ataframe之间的相互转换
import pandas as pd
dict1 = {'id': [1,2] ,'name':['xiaoming', 'dandan']}
list1 = [{'id': 1, 'name':'xiaoming'}, {'id': 2, 'name':'dandan'}]
# dict===>dataframe
df = pd.DataFrame(dict1)
print(df)
# dataframe===>dict
dict2 = df.to_dict()
print(dict2)
# list===>dataframe
list1 = [{'id': 1, 'name':'xiaoming'}, {'id': 2, 'name':'dandan'}]
df1 = pd.DataFrame.from_records(list1)
print(df1)
list11 = [[1, 'xiaoming'], [2, 'dandan']]
df11 = pd.DataFrame(list11,columns=['id', 'name'])
print(df11)
# dataframe===>list
list2 = df2.values.tolist()
print(list2)
# dataframe===>series
series1 = df11['id']
print(series1)
# series===>dataframe
df4 = series1.to_frame()