import pandas as pd
from io import StringIO
csv_file = StringIO("""Name Age Gender
Bob 23 Male
Ahmed 45 Male
Alice 37 Female
Ahmed 34 Male
Mariyya 10 Female
Bilal 23 Male""")
df = pd.read_csv(csv_file, sep="\s+",index_col=None)
df['Name'].value_counts()
输出:
Ahmed 2
Mariyya 1
Bilal 1
Bob 1
Alice 1
Name: Name, dtype: int64
df['Gender'].value_counts()
输出:
Male 4
Female 2
Name: Gender, dtype: int64
df.sort_values(by='Name')
输出:
Name Age Gender
1 Ahmed 45 Male
3 Ahmed 34 Male
2 Alice 37 Female
5 Bilal 23 Male
0 Bob 23 Male
4 Mariyya 10 Female
您可以使用熊猫:
输出:
输出:
输出:
相关问题 更多 >
编程相关推荐