原本 csv
Temp,Flow,site_no,datetime,Conductance,Precipitation,GageHeight
11.0,16200,09380000,2018-06-27 00:00,669,0.00,9.97
10.9,16000,09380000,2018-06-27 00:15,668,0.00,9.93
10.9,15700,09380000,2018-06-27 00:30,668,0.00,9.88
10.8,15400,09380000,2018-06-27 00:45,672,0.00,9.82
10.8,15100,09380000,2018-06-27 01:00,672,0.00,9.77
10.8,14700,09380000,2018-06-27 01:15,672,0.00,9.68
excel 打開 : https://imgur.com/a/bkU8klH
存了就被這樣了 :https://imgur.com/a/3GAicua
我要保持它是csv 別叫我存成excel
使用'
符號
Temp,Flow,site_no,datetime,Conductance,Precipitation,GageHeight
11.0,16200,'09380000,2018-06-27 00:00,669,0.00,9.97
10.9,16000,'09380000,2018-06-27 00:15,668,0.00,9.93
10.9,15700,'09380000,2018-06-27 00:30,668,0.00,9.88
10.8,15400,'09380000,2018-06-27 00:45,672,0.00,9.82
10.8,15100,'09380000,2018-06-27 01:00,672,0.00,9.77
10.8,14700,'09380000,2018-06-27 01:15,672,0.00,9.68
建議你CSV請不要直接雙左鍵打開,你現在的格式還不會出問題,以後你裡面有中文你就知道多慘....
EXCEL會使用ascii打開,UTF-8格式的中文保證亂馬給你看
請直接打開EXCEL,上面選單[資料]->左邊[從文字檔]->選你的CSV檔
打開以後[下一步]->勾選[逗點]->壓SHIFT把所有欄位選起來,上面單選勾[文字]->完成
這樣打開保證美美的