将字典转为dataframe问题及实例

#如果字典value只有一个元素
df = pd.DataFrame({'A':0}) # 直接将字典放进去会报错
'''ValueError: If using all scalar values, you must pass an index'''

#解决方法1: value改为列表
df1 = pd.DataFrame({'A':[0]}) 
#解决方法2:制定index
df2 = pd.DataFrame({'A':0},index = [0])
#解决方法3:将字典放入列表, 易发生混淆,慎用
df3 = pd.DataFrame([{'A':0},{'A':1}])
df4 = pd.DataFrame([{'A':0},{'B':1}])

#常规用法:
dic = {'A':[x for x in range(10)],'B':[random.randint(1,100) for _ in range(10)],
    'C': [random.choice('早上好') for _ in range(10)]}

df5 = pd.DataFrame(dic) #直接转
df6 = pd.DataFrame.from_dict(dic,orient='index') 
df7 = pd.DataFrame.from_dict(dic,orient='columns') 

#常规用法:
dic = {‘A’:[x for x in range(10)],‘B’:[random.randint(1,100) for _ in range(10)],
‘C’: [random.choice(‘早上好’) for _ in range(10)]}

df = pd.DataFrame(dic) #直接转
df2 = pd.DataFrame.from_dict(dic,orient=‘index’)
df3 = pd.DataFrame.from_dict(dic,orient=‘columns’)