时间戳

首页 > 解决方案 > 如何更具体地分隔行？

python - 如何更具体地分隔行？

问题描述

df = pd.read_csv("C:/Users/16316/Desktop/PsychologyData/1.csv")
df_Male = df[df['Subgroup'] == 'Male']
df_Male
df_Male.index
df_Male.set_index("Week Label")

Indicator   Group   State   Subgroup    Week    Value   Low CI  High CI Confidence Interval Quartile range
Week Label                                      
Apr 23 - May 5  Symptoms of Depressive Disorder By Gender   United States   Male    1   20.8    19.6    22.0    19.6 - 22.0 NaN
Apr 23 - May 5  Symptoms of Anxiety Disorder    By Gender   United States   Male    1   26.1    24.7    27.5    24.7 - 27.5 NaN
Apr 23 - May 5  Symptoms of Anxiety Disorder or Depressive Dis...   By Gender   United States   Male    1   31.0    29.6    32.3    29.6 - 32.3 NaN
May 7 - May 12  Symptoms of Depressive Disorder By Gender   United States   Male    2   22.3    20.6    24.0    20.6 - 24.0 NaN
May 7 - May 12  Symptoms of Anxiety Disorder    By Gender   United States   Male    2   26.7    24.9    28.5    24.9 - 28.5 NaN
May 7 - May 12  Symptoms of Anxiety Disorder or Depressive Dis...   By Gender   United States   Male    2   31.4    29.5    33.3    29.5 - 33.3 NaN
May 14 - May 19 Symptoms of Depressive Disorder By Gender   United States   Male    3   22.1    21.0    23.3    21.0 - 23.3 NaN

如何分离这些数据，使其仅显示按“男性”和“抑郁症症状”排序的数据。我只想到男性症状的行。出现抑郁症

我不确定它是否显示正确，但我想要的列是男性亚组和抑郁症的指标症状

其余数据中还有 1000 行

标签： python

解决方案

df = df[(df.Subgroup=='Male') & (df.Indicator=='Symptoms of Depressive Disorder')]

'&' 可以帮助组合多个条件来过滤数据。为了将来参考，您可以查看此处给出的各种示例。

推荐阅读