In Progress

I need some help with linux (ubuntu) bash script and pandas commands to manipulate hte csv's

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',


df = [login to view URL](5)

df2 = df['SpatialRefereceextent'].astype(str)


# 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]


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)

Skills: Python, Bash Scripting, Shell Script, Linux

See more: read csv file in python pandas, how to read csv file in command prompt, how to read csv file in shell script, command line to csv file, shell script output to csv file, working with csvs command line, create csv file command line, bash edit csv, linux sed bash script, need help linux sever offshore administration, linux bluetooth bash script broadcast files devices, linux varlogmessages bash script hours, howto linux ftp bash script, linux ubuntu shell script, i need help advertising my website, i need help designing a form, i need help designing a shirt, i need help designing clothes, i need help designing my van wrap, i need help find worker

About the Employer:
( 44 reviews ) Waukee, United States

Project ID: #27806583

Awarded to:


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, B More

$12 USD / hour
(11 Reviews)

6 freelancers are bidding on average $12/hour for this job


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 / hour
(1 Review)

Hi. I can do it and I'm ready to start right now. I'm a senior developer and an expert in ubuntu bash. I have read your description in detail and I can make your project excellent. I want to discuss your project in det More

$8 USD / hour
(0 Reviews)

I had BSc and MSc degree in Applied Mathematics and Informatics (gpa 4.8). Also undertaken postgraduate studies in Information and Navigation Systems (a candidate to PhD). I had solid experience in Software Engineering More

$15 USD / hour
(0 Reviews)

I am a Linux admin have 7 years of experience in this field. I worked in webhosting industry and manage datacenter from remote. I give full server management support and I can do this for you . I also have experience w More

$12 USD / hour
(0 Reviews)

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 / hour
(0 Reviews)