Find Jobs
Hire Freelancers

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)
Project ID: 27806583

About the project

3 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
hi. ican help you with the required output. i have gont through the first requirement. ifyoucan share sample data. i can provude you working code
$11 USD in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
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.
$12 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Waukee, United States
5.0
51
Payment method verified
Member since Feb 2, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.