list、numpy、pandas数据格式转换
1.list转numpy
import numpy as np
temp = np.array(list)
2.numpy转list
arr = temp.tolist()
3.list转Dataframe
import xlwings as xw
import pandas as pd
name = ['王家卫','周星驰','徐克']
id = ['001','002','003']
wb = xw.Book('upload.xlsx')
c={"name": name,"id": id}
df = pd.DataFrame(c,columns=['name', 'id']) #指定列名为name和id,顺序name先,id后
---------------------
作者:云胡123
来源:优快云
原文:https://blog.youkuaiyun.com/qq_32046111/article/details/80905277
版权声明:本文为博主原创文章,转载请附上博文链接!
结果
4.Dataframe转numpy
data = pd.read_csv("data.csv")
data = np.array(data)
5.Dataframe转list
首先使用np.array()函数把DataFrame转化为np.ndarray(),再利用tolist()函数把np.ndarray()转为list
data = pd.read_csv("data.csv")
data = np.array(data).tolist()
或者df.as_matrix指定取某些列
data=df.as_matrix(['title','count'])
或
data=df.values
6.numpy转Dataframe
numpy转Dataframe可以指定列名和行索引
data = pd.read_csv("data.csv")
data = np.array(data)
df = pd.DataFrame(data,index=list(range(data.shape[0])),columns=['title','content','pub_date','count'])