diff options
| -rw-r--r-- | python/murano.py | 7 | ||||
| -rwxr-xr-x | scripts/db.sh | 6 |
2 files changed, 10 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') diff --git a/scripts/db.sh b/scripts/db.sh new file mode 100755 index 00000000..e3529058 --- /dev/null +++ b/scripts/db.sh @@ -0,0 +1,6 @@ +#!/bin/bash +#simple script to daemonize the database +#to kill use kill $(cat db.pid) +./pgweb_linux_amd64 -s --bookmark=investorsdb --bind="192.168.9.70" > db.log & echo $! > db.pid +disown + |