Working with data in Excel, only for professionals
1 .From the column Number to copy all the numbers into the column Name if there is no such number in it, duplicates in the name should not be
The 2ndRemove the gap at the beginning and end of the line, the columns Name and Number.3 .In the number column, there are fields in which 2, 3, 4 numbers.It is necessary to deepen these lines and leave in the Number only one number, the remaining fields must be filled with output data.For more understanding see the video https://www.loom.com/share/6b573f2fbedd4b5e99e3f24fb540c713
and 4.Removal of duplicates.We remove the rows where the numbers double, leave one row with the highest price.and 5.Check the name column on the code content, if the code is available, then we remove it.The numbers are divided by a coma.After each completed point you need to download the file to me for the check, I check, enter the editing, download you and continue the work.An example of a file attached, a file with which you will have to work 58000 lines.Please carefully get acquainted with tz and ask questions if they are.The priority is the solution written on Python, node.js, etc.Formulas and manual editing are clearly disappearing.I look forward to your offerings by price and deadlines.
In the request rate to indicate real prices and deadlines, template answers will not be considered!
Applications 1
Client's review of cooperation with Yurii Bakai
Working with data in Excel, only for professionalsЮрій хороший фахівець, чудово впорався із завданням!
Freelancer's review of cooperation with Oleksandr Ranichev
Working with data in Excel, only for professionalsРоботою з Олександром задоволений, чітко постановлює завдання та дуже ввічливий в спілкуванні. Один з найкращих замовників з якими я працював. Рекомендую!
-
3668 107 0 This can be done at VBA.
But there will be a few clarifications that will be addressed.
Current freelance projects in the category Data Parsing
Parsing the YouControl website (Yukontrol)
27 USD
It is necessary to scrape companies from certain categories on the Yukontrol website, including 1) name 2) EDRPOU 3) manager 4) phone All this data is open. Data Parsing ∙ 8 hours 54 seconds back ∙ 16 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 4 days 10 hours back ∙ 19 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 4 days 15 hours back ∙ 36 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 4 days 17 hours back ∙ 41 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 4 days 23 hours back ∙ 27 proposals |