Suljettu

Regex function - parse a column of values

I have a column containing around 8000 of values

The column describes a volume of alcohol bottle.

The job is to parse the column and reduce to new columns:

1. Clean volume

2. is no. of bottles >1

For the cleaning regex there are several rules but it easier to show an example of the first 100 values,

I attached an example of the parsing in the attached file

The output should be a file with the 2 columns filled.

This is a onetime run no need to build a tool to auto run it - once the data is cleaned i release the payment

Taidot: Regular Expressions

Näytä lisää: script fetch particular column values csv file perl, sum column values target excel, excel parse column, regex for csv file extension, regex csv column, csv regex java, regex parse csv with quotes, regex extract csv fields, alteryx split function, alteryx split string formula, regex validate csv, function calculate pip values mql4, excel vba copy column values, parse column csv file using php, excel assign rank value based column values, parse column csv php, column values loop php, duplicate column values excel, parse column wise csv file php, sql function parse icalendar

Tietoa työnantajasta:
( 4 arvostelua ) Bahan, Israel

Projektin tunnus: #18183182

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

aki003iitr

I am a data scientist and data engineer with more than 4 years of programming experience in Python and have proficiency with using regular expressions.

$100 USD 3 päivässä
(1 arvostelu)
3.0
gangabass

I can write a simple script that will parse your column and generate another Excel column just like you want. It will process all 8000 values you have. I can complete it in 5 hours and all I need to start is your so Lisää

$100 USD 1 päivässä
(2 arvostelua)
2.7
cemalkendo

Hi, Sample does not provide data for 2. Col but if there is 70cl x 8 than first col is 70cl and second is 8>1=true lets make it done.

$90 USD 3 päivässä
(0 arvostelua)
0.0
siddyy7777

I am new here and looking for these kind of jobs which i can do it and trust me once given the responsibility i won't disappoint [login to view URL] consider me for this project it will help a new comer like me on freelancer to Lisää

$222 USD 3 päivässä
(0 arvostelua)
0.0