問題描述
我是熊貓新手.我下載并安裝了 Anaconda.然后我嘗試通過 Spyder 應(yīng)用程序運(yùn)行以下代碼:
I'm new to Pandas. I downloaded and installed Anaconda. Then I tried running the following code via the Spyder app:
import pandas as pd
import numpy as np
train = pd.read_csv('/Users/Ben/Documents/Kaggle/Titanic/train.csv')
train
雖然這會按我的預(yù)期打印數(shù)據(jù)幀，但它也會顯示這些錯誤
Although this prints the dataframe as I expected, it also shows these errors
//anaconda/lib/python3.4/site-packages/pandas/core/format.py:1969: RuntimeWarning: invalid value encountered in greater
has_large_values = (abs_vals > 1e8).any()
//anaconda/lib/python3.4/site-packages/pandas/core/format.py:1970: RuntimeWarning: invalid value encountered in less
has_small_values = ((abs_vals < 10 ** (-self.digits)) &
//anaconda/lib/python3.4/site-packages/pandas/core/format.py:1971: RuntimeWarning: invalid value encountered in greater
(abs_vals > 0)).any()
為什么會出現(xiàn)這些錯誤?
Why am I getting these errors?
我剛剛在 IPython 筆記本中測試了上面的代碼，它可以正常工作.那么，我的 Spyder 安裝有問題嗎?任何幫助將不勝感激.
I just tested the above code in an IPython notebook and it works without errors. So, is there something wrong with my Spyder installation? Any help would be appreciated.
經(jīng)過一些測試，我可以讀取 CSV 的前 5 行而不會收到警告.因此，我懷疑 float64 類型列的第 6 行中的 NaN 會觸發(fā)警告.
After some testing, I can read the first 5 rows of the CSV without getting the warning. So, I suspect a NaN in the 6th row for a float64 type column is triggering the warning.
推薦答案
我有同樣的錯誤，并確定這是一個錯誤.這似乎是由 Spyder 的 DataFrame 中存在 NaN 值引起的.我已經(jīng)卸載并重新安裝了所有軟件包，但沒有任何影響.NaN 值受支持并且在 DataFrame 中完全有效，尤其是在它們具有 DateTime 索引的情況下.
I have the same error and have decided that it is a bug. It seems to be caused by the presence of NaN values in a DataFrame in Spyder. I have uninstalled and reinstalled all packages and nothing has effected it. NaN values are supported and are completely valid in DataFrames especially if they have a DateTime index.
最后，我決定按如下方式抑制此警告.
In the end I have settled for suppressing this warnings as follows.
import warnings
warnings.simplefilter(action = "ignore", category = RuntimeWarning)
這篇關(guān)于Pandas 錯誤 - 遇到無效值的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！