Python練習#18-Pandas基本功能

本周目標

學習Pandas資料分析

任務

• 認識單維度的資料 Series
• 認識雙維度的資料 DataFrame。 (類似表格、table)

專案練習

使用Series找出最大值、中位數與放大2倍

import pandas as pd
data=pd.Series([20,25,10,15,20,15,12])
print(data)
print("Max:",data.max())
print("Median:",data.median())
print("--------------------")
data=data*2
print(data)
print("Max:",data.max())
print("Median:",data.median())

Output

0    20
1    25
2    15
3    20
4    12
dtype: int64
Max: 25
Median: 20.0
--------------------
0    40
1    50
2    30
3    40
4    24
dtype: int64
Max: 50
Median: 40.0

比較運算

import pandas as pd
data=pd.Series([20,25,15,20,12])
data=data==20
print(data)

Output

0     True 
1    False 
2    False 
3     True 
4    False 
dtype: bool

Dataframe基本操作，取得特定欄位

import pandas as pd
data=pd.DataFrame({
    "Name":["Amy","Leo","Joy","Candy"],
    "Age":[20,25,28,"NA"]
})
print(data)
# print(data["Name"])
print("--------------------")
print(data.iloc[0])
print(data.iloc[0,1])

Output

    Name Age
0    Amy  20
1    Leo  25
2    Joy  28
3  Candy  NA
--------------------  
Name    Amy
Age      20
Name: 0, dtype: object
20