While dropping new DataFrame returns. If you want to apply changes to the current DataFrame you have to specify inplace parameter. Option 1 Assigning back to df – df = df.drop(790) Option 2 Inplace argument – df.drop(790, inplace=True)
You need new_df = sales[~sales.CustomerID.isin(badcu)]
Use max with axis=1: df = df.max(axis=1) print (df) 0 2.0 1 3.2 2 8.8 3 7.8 dtype: float64 And if need new column: df[‘max_value’] = df.max(axis=1) print (df) a b c max_value 0 1.2 2.0 0.10 2.0 1 2.1 1.1 3.20 3.2 2 0.2 1.9 8.80 8.8 3 3.3 7.8 0.12 7.8
I have been facing the same issue for a long time as well: PyCharm debugging is extremely slow when using large pandas dataframes. If I want to view the contents of a dataframe in the Watches is often gives me a time out after waiting for minutes, so I basically stopped using the debug when … Read more
By the print you posted, it seems like you have whitespaces as delimiters. pd.read_csv will read using , as default separator, so you have to explicitly state it: pd.read_csv(‘source.txt’,header=0, delim_whitespace=True)