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.
6 freelancers are bidding on average $34 for this job
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