python dataframe与list,series,array,字典类型的相互转换

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/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球