CODEWITHSUNDEEP
pythonpython-3.xpandas
shaswatatripathy
shaswatatripathy

Reputation: 171

how to remove this warning in python 3

trying to lower and strip a column in python 3 using panda, but getting the warning-- what is the right way so this warning will not come up 

df["col1"] = df[["col1"]].apply(lambda x: x.str.strip())
df["col1"] = df[["col1"]].apply(lambda x: x.str.lower())

The warning

A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  self[k1] = value[k2]

how to remove the warning

Upvotes: 0

Views: 647

Answers (1)

Neil
Neil

Reputation: 14313

To get rid of this warning apply it to a series instead of a dataframe. Using df[["col1"]] is creating a new dataframe that you are then setting to the column. If you instead just modify the column it'll be fine. Additionally, I chained the two together.

df["col1"] = df["col1"].str.strip().str.lower()

Upvotes: 1

Related Questions