Data Cleaning With Python, Data Analysis, Dataframes Python, Marketing Analytics.
string rather than a numerical sum of all revenue values from all the rows : sales['Revenue'].sum() As a solution we remove the $ sign first and then change the datatype to ‘int’ before performing the sum operation : sales['Revenue'] = sales['Revenue'].str.strip('$') sales['Revenue'] =