我有个问题.一方面,我想过滤或 Select 我的数据帧,另一方面,我想只直接输出某些列.我什么也找不到(也许我遗漏了条款).是否有一个选项可以直接在一行中过滤Pandas ,同时只输出某些列?
import pandas as pd
d = {'id': [1, 2, 3, 4, 5, 1],
'name': ['Max Power', 'Jessica', 'Xi', 'Jackson', 'Frank', 'Miller'],
'secondName': ['Full', 'Miller', 'Hu', 'Johnny', 'High', 'Joachim'],
}
df = pd.DataFrame(data=d)
display(df)
df_new = df[df['id'] == 1]
display(df_new[['id', 'name']])
# df_new = df[['id', 'name'], df['id'] == 1] # TypeError Name: id, dtype: bool)' is an invalid key
[OUT]
id name secondName
0 1 Max Power Full
1 2 Jessica Miller
2 3 Xi Hu
3 4 Jackson Johnny
4 5 Frank High
5 1 Miller Joachim
id name
0 1 Max Power
5 1 Miller
我想要什么
df[df['id'] == 1, ['id','name']]
id name
0 1 Max Power
5 1 Miller