国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > Python > 正文

使用pandas read_table讀取csv文件的方法

2020-02-15 22:11:42
字體:
來源:轉載
供稿:網友

read_csv是pandas中專門用于csv文件讀取的功能,不過這并不是唯一的處理方式。pandas中還有讀取表格的通用函數read_table。

接下來使用read_table功能作一下csv文件的讀取嘗試,使用此功能的時候需要指定文件中的內容分隔符。

查看csv文件的內容如下;

In [10]: cat data.csvindex,name,comment,,,,1,name_01,coment_01,,,,2,name_02,coment_02,,,,3,name_03,coment_03,,,,4,name_04,coment_04,,,,5,name_05,coment_05,,,,6,name_06,coment_06,,,,7,name_07,coment_07,,,,8,name_08,coment_08,,,,9,name_09,coment_09,,,,10,name_10,coment_10,,,,11,name_11,coment_11,,,,12,name_12,coment_12,,,,13,name_13,coment_13,,,,14,name_14,coment_14,,,,15,name_15,coment_15,,,,16,name_16,coment_16,,,,17,name_17,coment_17,,,,18,name_18,coment_18,,,,19,name_19,coment_19,,,,20,name_20,coment_20,,,,21,name_21,coment_21,,,,

使用pandas讀取文件內容如下:In [11]: data1 = pd.read_table('data.csv',sep=',')

In [12]: type(data1)Out[12]: pandas.core.frame.DataFrame
In [13]: data1Out[13]:  index  name comment Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 60  1 name_01 coment_01   NaN   NaN   NaN   NaN1  2 name_02 coment_02   NaN   NaN   NaN   NaN2  3 name_03 coment_03   NaN   NaN   NaN   NaN3  4 name_04 coment_04   NaN   NaN   NaN   NaN4  5 name_05 coment_05   NaN   NaN   NaN   NaN5  6 name_06 coment_06   NaN   NaN   NaN   NaN6  7 name_07 coment_07   NaN   NaN   NaN   NaN7  8 name_08 coment_08   NaN   NaN   NaN   NaN8  9 name_09 coment_09   NaN   NaN   NaN   NaN9  10 name_10 coment_10   NaN   NaN   NaN   NaN10  11 name_11 coment_11   NaN   NaN   NaN   NaN11  12 name_12 coment_12   NaN   NaN   NaN   NaN12  13 name_13 coment_13   NaN   NaN   NaN   NaN13  14 name_14 coment_14   NaN   NaN   NaN   NaN14  15 name_15 coment_15   NaN   NaN   NaN   NaN15  16 name_16 coment_16   NaN   NaN   NaN   NaN16  17 name_17 coment_17   NaN   NaN   NaN   NaN17  18 name_18 coment_18   NaN   NaN   NaN   NaN18  19 name_19 coment_19   NaN   NaN   NaN   NaN19  20 name_20 coment_20   NaN   NaN   NaN   NaN20  21 name_21 coment_21   NaN   NaN   NaN   NaN

不過在幾番嘗試下來,發現這個分隔符缺省的時候倒是也能夠讀出數據。

In [16]: data2 = pd.read_table('data.csv')
In [17]: data2Out[17]:   index,name,comment,,,,0 1,name_01,coment_01,,,,1 2,name_02,coment_02,,,,2 3,name_03,coment_03,,,,3 4,name_04,coment_04,,,,4 5,name_05,coment_05,,,,5 6,name_06,coment_06,,,,6 7,name_07,coment_07,,,,7 8,name_08,coment_08,,,,8 9,name_09,coment_09,,,,9 10,name_10,coment_10,,,,10 11,name_11,coment_11,,,,11 12,name_12,coment_12,,,,12 13,name_13,coment_13,,,,13 14,name_14,coment_14,,,,14 15,name_15,coment_15,,,,15 16,name_16,coment_16,,,,16 17,name_17,coment_17,,,,17 18,name_18,coment_18,,,,18 19,name_19,coment_19,,,,19 20,name_20,coment_20,,,,20 21,name_21,coment_21,,,,            
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 乌拉特中旗| 西华县| 扶风县| 大渡口区| 武定县| 柳河县| 安远县| 武宁县| 伊川县| 林芝县| 临洮县| 邛崃市| 旅游| 太湖县| 永德县| 赫章县| 巴林右旗| 玉林市| 信丰县| 吉木萨尔县| 醴陵市| 朔州市| 若尔盖县| 西藏| 加查县| 瓦房店市| 涟水县| 宣汉县| 灵石县| 韶关市| 双江| 陆良县| 祥云县| 安康市| 新竹市| 普宁市| 五台县| 杨浦区| 普兰县| 新和县| 同仁县|