編集履歴

質問編集履歴

エラー解決（行指定エラー）のため、更新しておきます。

2019/03/01 01:08

投稿

shu_magi

スコア19

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -91,231 +91,3 @@
 別テーブルの条件(x1, x2, y1, y2)を参照し、データテーブルのx, yがそのうちどの区間に入っているか判別、対応するarea列の値を返す、ことをしたいです。
-### 【追記】発生している問題・エラーメッセージ
-以下プログラムを実行しましたが、エラーがでて処理が完了しません。
-test_datav03の21列目に、反映結果のデータを入れたいと考えています。
-list_test.csvが定義テーブルのデータです。
-```Python
-import numpy as np
-import pandas as pd
-#csvを読み込み
-df = pd.read_csv("testdata_v03.csv", header=0)
-print(df)
-df_ref = pd.read_csv("list_test.csv", header=0)
-df.T.apply(lambda x: ','.join(df_ref[(df_ref.values[:, 1] <= x.values[9]) &
-                                     (df_ref.values[:, 2] >= x.values[9]) &
-                                     (df_ref.values[:, 3] <= x.values[10]) &
-                                     (df_ref.values[:, 4] >= x.values[10])].iloc[:, 21].values.astype(str)))
-print(df)
-```
-以下エラーがでています。
----------------------------------------------------------------------------
-IndexError                                Traceback (most recent call last)
-<ipython-input-3-4a0b1b44785f> in <module>()
-      9 df_ref = pd.read_csv("area_list_test.csv", header=0)
-     10
----> 11 df.T.apply(lambda x: ','.join(df_ref[(df_ref.values[:, 1] <= x.values[9]) &
-     12                                      (df_ref.values[:, 2] >= x.values[9]) &
-     13                                      (df_ref.values[:, 3] <= x.values[10]) &
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\frame.py in apply(self, func, axis, broadcast, raw, reduce, result_type, args, **kwds)
-   6012                          args=args,
-   6013                          kwds=kwds)
--> 6014         return op.get_result()
-   6015
-   6016     def applymap(self, func):
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in get_result(self)
-    316                                       *self.args, **self.kwds)
-    317
---> 318         return super(FrameRowApply, self).get_result()
-    319
-    320     def apply_broadcast(self):
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in get_result(self)
-    140             return self.apply_raw()
-    141
---> 142         return self.apply_standard()
-    143
-    144     def apply_empty_result(self):
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in apply_standard(self)
-    246
-    247         # compute the result using the series generator
---> 248         self.apply_series_generator()
-    249
-    250         # wrap results
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in apply_series_generator(self)
-    275             try:
-    276                 for i, v in enumerate(series_gen):
---> 277                     results[i] = self.f(v)
-    278                     keys.append(v.name)
-    279             except Exception as e:
-<ipython-input-3-4a0b1b44785f> in <lambda>(x)
-     12                                      (df_ref.values[:, 2] >= x.values[9]) &
-     13                                      (df_ref.values[:, 3] <= x.values[10]) &
----> 14                                      (df_ref.values[:, 4] >= x.values[10])].iloc[:, 21].values.astype(str)))
-     15
-     16 print(df)
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in __getitem__(self, key)
-   1470             except (KeyError, IndexError):
-   1471                 pass
--> 1472             return self._getitem_tuple(key)
-   1473         else:
-   1474             # we by definition only have the 0th axis
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _getitem_tuple(self, tup)
-   2011     def _getitem_tuple(self, tup):
-   2012
--> 2013         self._has_valid_tuple(tup)
-   2014         try:
-   2015             return self._getitem_lowerdim(tup)
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _has_valid_tuple(self, key)
-    220                 raise IndexingError('Too many indexers')
-    221             try:
---> 222                 self._validate_key(k, i)
-    223             except ValueError:
-    224                 raise ValueError("Location based indexing can only have "
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _validate_key(self, key, axis)
-   1955             return
-   1956         elif is_integer(key):
--> 1957             self._validate_integer(key, axis)
-   1958         elif isinstance(key, tuple):
-   1959             # a tuple should already have been caught by this point
-~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _validate_integer(self, key, axis)
-   2007         l = len(ax)
-   2008         if key >= l or key < -l:
--> 2009             raise IndexError("single positional indexer is out-of-bounds")
-   2010
-   2011     def _getitem_tuple(self, tup):
-IndexError: ('single positional indexer is out-of-bounds', 'occurred at index 0')

プログラムを実際のテストファイルで実装したところ、エラーがでたため、その部分を追記しました。

2019/03/01 01:08

投稿

shu_magi

スコア19

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -86,8 +86,236 @@
-### 発生している問題・エラーメッセージ
+### 実施イメージ
 別テーブルの条件(x1, x2, y1, y2)を参照し、データテーブルのx, yがそのうちどの区間に入っているか判別、対応するarea列の値を返す、ことをしたいです。
+### 【追記】発生している問題・エラーメッセージ
+以下プログラムを実行しましたが、エラーがでて処理が完了しません。
+test_datav03の21列目に、反映結果のデータを入れたいと考えています。
+list_test.csvが定義テーブルのデータです。
+```Python
+import numpy as np
+import pandas as pd
+#csvを読み込み
+df = pd.read_csv("testdata_v03.csv", header=0)
+print(df)
+df_ref = pd.read_csv("list_test.csv", header=0)
+df.T.apply(lambda x: ','.join(df_ref[(df_ref.values[:, 1] <= x.values[9]) &
+                                     (df_ref.values[:, 2] >= x.values[9]) &
+                                     (df_ref.values[:, 3] <= x.values[10]) &
+                                     (df_ref.values[:, 4] >= x.values[10])].iloc[:, 21].values.astype(str)))
+print(df)
+```
+以下エラーがでています。
+---------------------------------------------------------------------------
+IndexError                                Traceback (most recent call last)
+<ipython-input-3-4a0b1b44785f> in <module>()
+      9 df_ref = pd.read_csv("area_list_test.csv", header=0)
+     10
+---> 11 df.T.apply(lambda x: ','.join(df_ref[(df_ref.values[:, 1] <= x.values[9]) &
+     12                                      (df_ref.values[:, 2] >= x.values[9]) &
+     13                                      (df_ref.values[:, 3] <= x.values[10]) &
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\frame.py in apply(self, func, axis, broadcast, raw, reduce, result_type, args, **kwds)
+   6012                          args=args,
+   6013                          kwds=kwds)
+-> 6014         return op.get_result()
+   6015
+   6016     def applymap(self, func):
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in get_result(self)
+    316                                       *self.args, **self.kwds)
+    317
+--> 318         return super(FrameRowApply, self).get_result()
+    319
+    320     def apply_broadcast(self):
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in get_result(self)
+    140             return self.apply_raw()
+    141
+--> 142         return self.apply_standard()
+    143
+    144     def apply_empty_result(self):
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in apply_standard(self)
+    246
+    247         # compute the result using the series generator
+--> 248         self.apply_series_generator()
+    249
+    250         # wrap results
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\apply.py in apply_series_generator(self)
+    275             try:
+    276                 for i, v in enumerate(series_gen):
+--> 277                     results[i] = self.f(v)
+    278                     keys.append(v.name)
+    279             except Exception as e:
+<ipython-input-3-4a0b1b44785f> in <lambda>(x)
+     12                                      (df_ref.values[:, 2] >= x.values[9]) &
+     13                                      (df_ref.values[:, 3] <= x.values[10]) &
+---> 14                                      (df_ref.values[:, 4] >= x.values[10])].iloc[:, 21].values.astype(str)))
+     15
+     16 print(df)
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in __getitem__(self, key)
+   1470             except (KeyError, IndexError):
+   1471                 pass
+-> 1472             return self._getitem_tuple(key)
+   1473         else:
+   1474             # we by definition only have the 0th axis
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _getitem_tuple(self, tup)
+   2011     def _getitem_tuple(self, tup):
+   2012
+-> 2013         self._has_valid_tuple(tup)
+   2014         try:
+   2015             return self._getitem_lowerdim(tup)
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _has_valid_tuple(self, key)
+    220                 raise IndexingError('Too many indexers')
+    221             try:
+--> 222                 self._validate_key(k, i)
+    223             except ValueError:
+    224                 raise ValueError("Location based indexing can only have "
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _validate_key(self, key, axis)
+   1955             return
+   1956         elif is_integer(key):
+-> 1957             self._validate_integer(key, axis)
+   1958         elif isinstance(key, tuple):
+   1959             # a tuple should already have been caught by this point
+~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexing.py in _validate_integer(self, key, axis)
+   2007         l = len(ax)
+   2008         if key >= l or key < -l:
+-> 2009             raise IndexError("single positional indexer is out-of-bounds")
+   2010
+   2011     def _getitem_tuple(self, tup):
+IndexError: ('single positional indexer is out-of-bounds', 'occurred at index 0')