import numpy as np
import pandas as pd
df = pd.DataFrame({
'name':[1,2,3],
'age':[19,21,23]
})
type(df)
df
nameage011912212323
dataframe 转 list
df_to_list_all = df.values.tolist()
df_to_list_all
[[1, 19], [2, 21], [3, 23]]
df_to_list_row = df.loc[0].values.tolist()
df_to_list_row
[1, 19]
df_to_list_column_name = df['name'].values.tolist()
df_to_list_column_name
df_to_list_column_age = df['age'].values.tolist()
df_to_list_column_age
[19, 21, 23]
list 转 dataframe
df1 = pd.DataFrame({'xname':df_to_list_column_name,'xage':df_to_list_column_age})
df1
xnamexage011912212323
dataframe 转 series
series_column = df['age']
type(series_column)
series_row = df.loc[0]
series_row
type(series_row)
pandas.core.series.Series
series 转 dataframe
df2 = pd.DataFrame({'a':series_column,'b':series_column+1})
df2
ab019201212222324
dataframe转array
array_all = df.values
array_all
array([[ 1, 19],
[ 2, 21],
[ 3, 23]], dtype=int64)
array 转 dataframe
array1 = np.arange(0,10,3)
array1
df2 = pd.DataFrame({'a':array1})
df2
a00132639
dataframe 转 字典
通过to_dict()来转换
dic = df.to_dict()
dic['name']
{0: 1, 1: 2, 2: 3}
字典转dataframe
通过字典里面的key来访问对应的值,从而初始化dataframe
df3 = pd.DataFrame({'a':dic['name'],'b':dic['age']})
df3
ab011912212323
元组里面的元素都是2个
vegetables = [('celery', 1.58), ('brocoli', 1.29), ('lettuce', 2.19)]
dict3 = dict(vegetables)
print(dict3)
对于二维list,可以直接转化为字典
cars = [['BMW', 8.5], ['BENS', 8.3], ['AUDI', 7.9]]
dict4 = dict(cars)
print(dict4)
对于一维list,可以将两个一维list通过zip拼在一起
dict_zip = dict(zip(list1,list2))
Original: https://blog.csdn.net/weixin_42327752/article/details/118305029
Author: Weiyaner
Title: python dataframe与list,series,array,字典类型的相互转换
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/750632/
转载文章受原作者版权保护。转载请注明原作者出处!