[問題] 讀取dataframe中某一列某一行

[jasonfghx (環宇 芯繫天下)]

https://mybox.ncku.edu.tw/navigate/s/C7780C75A59347E783561806F62FE387GSY

這是我的數據檔案

簡單範例我測試沒問題

但是我用這個數據來測

import numpy as np
import pandas as pd
i=pd.read_csv("taipei.csv",sep=",")
i.head(3)
print (i[1,2])

執行的結果是錯誤

Traceback (most recent call last):

  File "<ipython-input-60-a348a131c1bf>", line 1, in <module>
    print (i[1,2])

  File "C:\Users\user\Anaconda3\lib\site-packages\pandas\core\frame.py", line
2685, in __getitem__
    return self._getitem_column(key)

  File "C:\Users\user\Anaconda3\lib\site-packages\pandas\core\frame.py", line
2692, in _getitem_column
    return self._get_item_cache(key)

  File "C:\Users\user\Anaconda3\lib\site-packages\pandas\core\generic.py",
line 2486, in _get_item_cache
    values = self._data.get(item)

  File "C:\Users\user\Anaconda3\lib\site-packages\pandas\core\internals.py",
line 4115, in get
    loc = self.items.get_loc(item)

  File
"C:\Users\user\Anaconda3\lib\site-packages\pandas\core\indexes\base.py", line
3065, in get_loc
    return self._engine.get_loc(self._maybe_cast_indexer(key))

  File "pandas\_libs\index.pyx", line 140, in
pandas._libs.index.IndexEngine.get_loc

  File "pandas\_libs\index.pyx", line 162, in
pandas._libs.index.IndexEngine.get_loc

  File "pandas\_libs\hashtable_class_helper.pxi", line 1492, in
pandas._libs.hashtable.PyObjectHashTable.get_item

  File "pandas\_libs\hashtable_class_helper.pxi", line 1500, in
pandas._libs.hashtable.PyObjectHashTable.get_item

KeyError: (1, 2)

這他訊息

實在閱讀上有困難, 煩請協助感恩

請問我可以如何改善?

--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.116.234.34
※ 文章網址: https://www.ptt.cc/bbs/Python/M.1530540521.A.322.html
推 TitanEric: 這個是numpy寫法 應該要i.loc[0][1] 前面的方括弧是row
→ TitanEric:  indrx 後面的是column name
→ TitanEric: 或是使用i.iat[0,1] 這樣兩邊都是index
→ abc2090614: 用i.iloc[0,1]比較好也比較快
→ abc2090614: 如果只取一列就用.iat
推 sherees: .at