Rename, then Combine and then do some operations on .csv/.excel Files
$2-8 USD / hour
Suljettu
Julkaistu yli 7 vuotta sitten
$2-8 USD / hour
One of my client purchase data from a company → The data is the domain registered with details such as Name, email, Phone etc.
The details are divided into folders based on countries such as →
Australia
New Zealand
USA
UK
Ireland and all other Countries.
In this country Folder, a file is kept, which is normally of the sort [login to view URL] that means the name is same in all the folders [login to view URL], for example.
See this Video → [login to view URL]
Operation 1→ Change the name of the file, which is CSV or excel sort of format to country format such. Precisely this image → [login to view URL], but you have to make it in such a manner that it can handle any extension in excel. For example, in Australia folder, the "[login to view URL] or [login to view URL]" should be changed to [login to view URL] and in zimbabwe folder, it should be changed to zimbabwe_1.csv. Similarly for other countries. Then collect these modified names extension in one folder named common. Got It?
Operation 2 → Combine all the modified Files into one big File. I am showing you structure of the sample [login to view URL] file see this video → [login to view URL] We will need 3 columns to be combined = Domain Name, Full Name, and Email. While doing this combination it will be advisable If 4th column can be created which will have entry like from where the entry is coming such as Australia_1, Zimbabwe_1
Operation 3 → Concatenation result in a new column like this → Full Name <Email> that means name and email concatenated in the above format that I showed you.
Good Day!
I am Michael Falguera and I would like to express my interest to work in your job post.
I have more than 5 years’ experience in Data Processing including Data Entry, Data Mining, Data Extraction and others. I am also familiar in using the the internet. I am also proficient in using computer software application such as Microsoft Word, Excel, Powerpoint and others.
I also have a personal laptop and a reliable internet connection, so, rest assured that I can perform my duty efficiently and timely.
Feel free to send me a message or thru skype (mikel.0926)so we can further discuss about your job order.
Thank you and have a good day!
I`m very interested in your project because I can accomplish it very FAST. I have done similar tasks using R programming language and I already have a template for combining columns different csv`s into one (with the separate column with csv`v names). I can do any sort of data wrangling.
I understand that I have no reviews on Freelancer.com, so I can make test assignment for free.
Hi Dear !!
I have gone thorgh your video and screen shots . I am expert in converstion CSV to Ms Excel and Ms Excel to CSV . If you want I can give you this data in in MySQL Table or MS ACCESS .
Hi,
I'm hardworking, responsible and creative person with a few years of experience as Software Developer in some international corporations. I have also master degree in Computer Science.
I can create Windows application that do all these 3 operations. The cost of program will be about 150-170 $ and creation time 1-2 days.
Best regards
Piotr
Prog-NET
i complete my work on the time with my full effort and skills. i have professional skills of MS Excel and have a 6 month diploma in MS Office. i have also master degree in commerce and specialization in finance. currently i am doing work of Huawei technologies as an operator.
Hello,
I Would like to negotiate with you. I have a team of four members and we hope to complete your project with in 3 hours a day. If you select us, let us know every single detail of the project. We will do our best.
Thank you
hi there,
I am writing in response to your ad.
My technical skills and Qualifications make me a perfect candidate for this position.
I am a software engineer, detail oriented, self-starter, focused on quality and well organized person.
Additionally, I have expertise in Manual as well Automation testing.
I have worked in software field for 2 years, this has provided me with valuable knowledge that I would bring to this position.
Please take a moment to review my proposal.
I believe I have the qualifications you need and I look forward to hearing from you soon.
Sincerely,
Cherry Badjatya
813-240-3315
We have been in existence for last 3 years and have worked on different projects in Voice and data entry and have always discharged them satisfactorily. We have skilled data entry operators and quality voice agents to finish tasks with high level standards in a time bound manner.
As a tech lead i always work with excel(microsoft office)for report preparations.
As a part of the report preparations i must be keen about the data merging / information preparation from the available data to provide to the client.
Dear Sir/Madame,
Greetings of Peace!
I have read the description of the job you posted and with great interest, I would like to apply for this job. I already have done a task exactly like this. I believe this experience qualifies me as a strong contender for this hiring.
To know more about me, I have been working as an online technician for more than 3 years. I do answer queries and provide technical assistance through Live Chat, Email or through the Phone. This experience has really enhanced my communication and typing skills since it is a must to type as fast as possible when chatting. I am a Bachelor of Science in Information Technology and I'm unquestionably oriented with computer technology that is why I am comfortable on using most of Windows Applications and software.
I believe in integrity and honesty, so I make sure to observe quality in any task given to me.
Thank you and I hope to hear from you soon.
Sincerely,
Sumaiya