Why can't pandas dataframe output column values be aligned separately?

when importing the csv file to clean the Filter file, it was found that a column of output values were not aligned, resulting in a duplicate data count in value_counts ()

clipboard.png

clipboard.png
how should I handle this situation, and is there any way to align these values?

Jun.11,2021

these values must have spaces. Try to get rid of the blanks.

df["Renovation"].str.strip().values_counts()

the problem of inconsistent data format can be solved by the following methods:

df['Renovation'] = df['Renovation'].apply(lambda x : x.strip())

you can also choose lstrip and rstrip

as needed.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3b43a-2bad1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3b43a-2bad1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?