I want to use pandas.read_table () to read the data in the data table into a pandas Dataframe object:
ImportPandas as Pdunames= ['user_id','Gender',' Age','Occupation','Zip']users= Pd.read_table ('C:\1M Data\ml-1m\users.dat', sep='::', Header = None, names = unames)
But error: Invalid mode (' R ') or filename: ' C:\x01M data\\ml-1m\\users.dat '
This error occurs when you use the built-in function file () or open (). Either because the file's open mode is incorrect, or if there is a problem with the filename. The former only needs to pay attention to whether the file can be read or writable. The latter is a file-path-related issue that requires R or R to be escaped before the file name, such as file (r "E:\Test.txt", ' r '). or turn the backslash \ into two, such as file ("E:\\test.txt", ' R ').
Therefore, to change the code to:
Users = pd.read_table (r'C:\1M data\ml-1m\users.dat', sep='::' , Header = None, names = unames)
Python ioerror:invalid mode (' R ') or filename