python指定列索引筛选数据

panda-生物

于 2020-11-25 10:22:53 发布

阅读量2.1k

点赞数

文章标签： python

本文链接：https://blog.youkuaiyun.com/qq_45862222/article/details/110118137

版权

由于未提供博客具体内容，无法给出包含关键信息的摘要。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#导入包
import pandas  as pd
import numpy as np
from pandas  import Series,DataFrame
# from numpy import mean, ptp, var, std
#读取数据
df_season = pd.read_excel('e://xionghuan//20201123/pathway_1_2.xlsx',sheet_name='Pathway_2')
df_site = pd.read_excel('e://xionghuan//20201123/pathway_1_2.xlsx',sheet_name='Pathway_2')
#赛选数据按指定的赛选
withering = df_season.query('season==1')
#数据切片 loc[行，列] 按标签筛选
withering = withering.loc[:,'Aging'::]
#描述统计
withering = withering.describe().round(2).loc[['mean','std']].T
# withering['mean±std'] = withering['mean'].map(str)+'+'+withering['std'].map(str)
# withering['mean±std'] = withering['mean']+withering['std']
#pandas 新增一列
withering['mean±std'] = withering['mean'].astype(str)+'+'+withering['std'].astype(str)
withering