In [1]:
from google.colab import files
# 上傳csv檔案
uploaded = files.upload()
In [2]:
import io
import pandas as pd
df1 = pd.read_csv(io.BytesIO(uploaded['1091015_108年各職類別初任人員每人每月經常性薪資-按行業別分.csv']))
print(len(df1))
df1.head()
Out[2]:
In [3]:
# 上傳excel檔案
uploaded = files.upload()
In [4]:
df2 = pd.read_excel(io.BytesIO(uploaded['1091015_108年各職類別初任人員每人每月經常性薪資-按行業別分.xlsx']))
print(len(df2))
df2.head()
Out[4]: