Translate Excel column using R -- 2

The attached xlsx file has a column which contains text in German.

Output has 2 requirements:

1. Eliminate words that contain special characters and number and extract the cleaned text to new column. For example: "§82b E6723 Wanne Fugen sanieren" after extraction should contain "Wanne Fugen sanieren"

2. Use the extracted text column as input to run the translator function which will output the translations to a new column adjacent to the input column.

The current code I was using was found on Github and modifies only 1 row at a time.

I will also need your RCode that you used to accomplish the task. Please have the lines of code arranged in a manner which makes it easy to reproduce; all [login to view URL] and library commands should be in order. Include comments to explain any important actions

The timeline is either 2 hours (bonus of $10 given) or 8 hours.

Skills: R Programming Language

See more: hire excel expert for 2 hours, excel column row, google translate api column excel, translate excel english column spanish, increment column using macro excel, convert word row table excel column, changing width column excel file using cnet, iterate paste next column using macro excel, sample read excel worksheet using visual basic, save datatable excel aspnet using, comparing excel files using code, pdf excel column, translate excel file turkish english, translate english mandarin using english words, read excel data using, find excel data using, vba excel column label, translate excel file french english

About the Employer:
( 6 reviews ) New York, United States

Project ID: #14776074

6 freelancers are bidding on average $34 for this job


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e More

$50 USD in 1 day
(15 Reviews)

Expert in data processing .Job will be finished in 2 hrs My profile is as follows:- 4 years of experience in data [login to view URL] science and analytics professional with excellent coding skills in R and Python .  - P More

$30 USD in 1 day
(24 Reviews)

Bid is for removing "words" containing non-english alphabetic characters from the input string. storing result in column "German" Running a translation function over it and storing in column English Relevant Skills More

$25 USD in 1 day
(2 Reviews)

Send me details to view and do the work.

$55 USD in 1 day
(0 Reviews)

I have R coding experience from taking classes from Ivy league University, University of Pennsylvania. Relevant Skills and Experience I can get the job done. Proposed Milestones $25 USD - On completion

$25 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$20 USD in 2 days
(0 Reviews)