diff options
Diffstat (limited to 'python/murano.py')
| -rw-r--r-- | python/murano.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/python/murano.py b/python/murano.py index 6ea78e70..e4f714f3 100644 --- a/python/murano.py +++ b/python/murano.py @@ -15,9 +15,10 @@ df = df.drop(todrop, axis=1) ## drop columns with ID in it df = df.drop([col for col in df if 'ID' in col], axis=1) ## cleanup url -df.Website.replace("http://","") -df.loc[df.Website.str.startswith('www').fillna(False),'Website'] = 'http://' + \ - df.Website[df.Website.str.startswith('www').fillna(False)] +website = df.Website +website = website.replace("http://","") +df.loc[website.str.startswith('www').fillna(False),'Website'] = 'http://' + \ + website[website.str.startswith('www').fillna(False)] df = df.drop(['Teams', 'Do Not Call', 'Assigned User Name', 'Hit Status'], axis=1) df['Minimum Track Record'] = pd.to_numeric(df['Minimum Track Record'], errors='coerce') |