[问题] pandas合并问题

楼主: allen511081 (蓝)   2015-05-04 11:38:03
小弟我在取得经纬之后想要把所有被我分割的CSV档合并回去,
但是却发生了所有资料格式都跑掉的状态,如图:
https://drive.google.com/open?id=0B6SUWnrBmDwSdXdmTHpYNS1NSjg&authuser=0
原本正常的字段是日期,时间,地点,经纬,最后才是鸟类资料,但合并完后,
格式整个走样,还请强者指导我一下
附上我做测试的两个CSV及code:
https://drive.google.com/open?id=0B6SUWnrBmDwScUpNaTFaM1ZnODg&authuser=0
https://drive.google.com/open?id=0B6SUWnrBmDwSRVc4NlhzM3VnbEE&authuser=0
Code(还请见谅,我github的帐号被当成机器人帐号封锁,所以把code直接贴上来)
# -*- coding: utf-8 -*-
import pandas as pd
df=pd.read_csv('./bird0-1.csv',low_memory=False)
df1=pd.read_csv('./bird1-1.csv',low_memory=False)
pieces = [df, df1]
df_fin=pd.concat(pieces)
df_fin.to_csv('./birdsfinall.csv',index=False)
请各位帮帮我

Links booklink

Contact Us: admin [ a t ] ucptt.com