时间戳

首页 > 解决方案 > 切片熊猫系列

python-3.x - 切片熊猫系列

问题描述

我有以下代码：

total_csv = pd.read_csv('total.csv',header=0).iloc[:,:]
column28=total_csv ['28']
column27=total_csv ['27']
column26=total_csv ['26']
column25=total_csv ['25']
column24=total_csv ['24']
column23=total_csv ['23']

master_values=(column23,column24,column25,column26,column27,column28)

In [68]:master_values
Out[68]: 
(0    6867.488928
 Name: 23, dtype: float64, 0    6960.779317
 Name: 24, dtype: float64, 0    7007.540137
 Name: 25, dtype: float64, 0    7031.11444
 Name: 26, dtype: float64, 0    7127.469389
 Name: 27, dtype: float64, 0    7408.207806
 Name: 28, dtype: float64)

但我想master_values成为(6867.488928,6960.779317,7007.540137,7031.11444,7127.469389,7408.207806)。

目前，我阅读的方式total_csv如下：

In [69]: total_csv
Out[69]: 
     z           23           24          25  ...     
0  CCS  6867.488928  6960.779317  7031.11444  ...

我怎么能读书master_values呢(6867.488928,6960.779317,7007.540137,7031.11444,7127.469389,7408.207806)？

标签： python-3.xpandasslice

解决方案

你可以试试这个：

total_csv.to_numpy()[0][0].split('  ')[1:]

推荐阅读