I once read a line of code which is to read a csv file into pandas dataframe.

test = pd.read_csv(data_path,thousands=',').replace("#REF!", np.nan)

What does the "#REF!" mean? Does that correspond to any unique character?

CodePudding user response：

That error comes from an Excel file. According to Microsoft docs: "The #REF! error shows when a formula refers to a cell that's not valid . This happens most often when cells that were referenced by formulas get deleted, or pasted over."