I need some help with linux (ubuntu) bash script and pandas commands to manipulate hte csv's
$8-15 USD / hour
Completed
Posted over 3 years ago
$8-15 USD / hour
I'm looking for help with both some bash script to manipulate csv files and also pandas commands to manipulate the csv's. The first thing i'm trying to do is to make the latestWkid value of the dictionary in this pandas frame a seperate column. Screen share would really help.
0 Spatial Referece extent
1 {'wkid': 102718, 'latestWkid': 2263}
2 {'wkid': 4326, 'latestWkid': 4326}
3 {'wkid': 4326, 'latestWkid': 4326}
4 {'wkid': 102718, 'latestWkid': 2263}
Here is some of the code i've already written in a jupyter notebook
import pandas as pd
!!cp [login to view URL] [login to view URL]
!!csvcut -c 4,9-11,15,16,19,31,35 [login to view URL] > [login to view URL]
!!rm [login to view URL]
df = pd.read_csv("[login to view URL]", names = ['Title', 'query', 'ServiceDescription', 'geometryType', 'fullExtent',
'SpatialRefereceextent', 'name', 'supportedQueryFormats',
'MaximumRecordCount'])
df = [login to view URL](5)
df2 = df['SpatialRefereceextent'].astype(str)
print(df2)
# for col in [login to view URL]:
# print(col)
def unpack(df, column, fillna=None):
ret = None
if fillna is None:
ret = [login to view URL]([df, [login to view URL]((d for idx, d in df[column].iteritems()))], axis=1)
del ret[column]
else:
ret = [login to view URL]([df, [login to view URL]((d for idx, d in df[column].iteritems())).fillna(fillna)], axis=1)
del ret[column]
return ret
df = unpack(df2, 'Spatial Referece extent', 0)
Hi! I am a Python expert with over 5 years experience dealing with Software, I can help working with your projects.
I've previously worked on the exact same project for another employer.
Web Automation with Selenium, Beautifulsoup
Network building like nb-iot with dataset
IDS building with CTU-13, KDD Dataset
Fake News detection with Dataset
Tor network related script
Payment server building
Scraper building for several business
ML and Deep Learning for classification and prediction(Tensorflow)
Unit Testing
Database: Mysql, Sqlite, Mongo, Postgresql
When do you need this finished by?
I understand how this task should be done with my skillsets, and can get this done for you quickly and qualifiedly!
Please research my work sample i worked before and I look forward to working on this project with you.
Thanks.
$12 USD in 40 days
5.0 (15 reviews)
5.7
5.7
3 freelancers are bidding on average $12 USD/hour for this job
I have been solving Machine Learning problems for around two years now.I love to solve challenging problems. I have lots of experience in classical Machine Learning , time-series and NLP algorithms.