#?-*-?coding:?utf-8?-*-
import?pandas?as?pd
from?math?import?isnan
namelist=[“StartTime““Male““Female““Wear““NotWear““Passenger““NoPassenger““Sidewalk““NotSidewalk“]
df=pd.read_csv（‘bikes.csv‘skiprows=8header=None?names=namelist）
timenow=““
result=[]
for?index?row?in?df.iterrows（）:
????temp={}
????if?type（row[“StartTime“]）?==?str:
????????timetemp?=?row[“StartTime“].split（“:“）
????????if?int（timetemp[0]）<10:
????????????datetime?=?“2010-09-24?0“+?row[“StartTime“]+“:00“
????????else:
????????????datetime?=?“2010-09-24?“+?row[“StartTime“]+“:00“
????????temp[“datetime“]=datetime
????else:
????????temp[“datetime“]=datetime
????????
????if?type（row[“Male“]）==?str:
????????temp[“gender“]=“Male“
????else:
????????temp[“gender“]=“Female“
????if?type（row[“Wear“]）==?str:
????????temp[“had_helmet“]=“Yes“
????else:
????????temp[“had_helmet“]=“No“
????if?type（row[“Passenger“]）==?str:
????????temp[“had_passenger“]=“Yes“
????else:
????????temp[“had_passenger“]=“No“
????if?type（row[“Sidewalk“]）?==?str:
????????temp[“on_sidewalk“]=“Yes“
????else:
????????temp[“on_sidewalk“]=“No“
????result.append（temp）
result_df?=?pd.Dataframe（result）
result_df.to_csv（‘transform.csv‘index=False）

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-13?14:38??result-new?-?副本\
?????文件????????1230??2018-12-11?15:42??result-new?-?副本\No1.py
?????文件????????1956??2018-12-11?15:42??result-new?-?副本\No2.py
?????文件????????1304??2018-12-11?15:42??result-new?-?副本\No3.py
?????文件????????2716??2018-12-13?14:35??result-new?-?副本\No4.py
?????文件???????25991??2018-12-10?23:17??result-new?-?副本\bikes.csv
?????文件?????????173??2018-12-11?11:38??result-new?-?副本\data.json
?????文件?????????305??2018-12-12?12:38??result-new?-?副本\statistic.csv
?????文件???????71335??2018-12-12?12:38??result-new?-?副本\transform.csv