Find Jobs
Hire Freelancers

Combine data and match it against other data -- 2

$30-250 USD

Σε Εξέλιξη
Αναρτήθηκε πάνω από 7 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
We would provide the following: FTP with a folder with: About 165 csv files with apprx. 260,000 lines each and 9 columns. There are unique identifiers in Column A and information about these unique identifiers in the following columns. Each csv file’s name is a timestamp showing the exact date of the information in the file. One additional xlsb file with unique identifiers in Column A, Date in Column B and additional information for the unique identifier in the following columns. We need the following to be performed: All csv files to be combined into one database, keeping the date of each unique identifier. All unique identifiers with their dates in the xlsb file to be matched against the same unique identifiers from the same date in the csv files. Once matched, the data from column B to I from the csv files to be pasted in the xlsb files on the unique identifier’s line from column E to column L. Example: The xlsb file contains in Column A, unique identifier 123456, in column B, on the same line is date 01/08/2016 We would need to find the unique identifier 123456 in the csv file from 01/08/2016 and then copy the information from column B to I on the same line as the unique identifier, and then paste it in the xlsb file, on the same line as the unique identifier in the same order, starting from column E. Then, we would need the xlsb file with all of the above information and one file with the combined csv files. The database with all of the combined files would not necessarily contain all of the fields in each of the csv files but to the very first csv file should be added all the changes in the information concerning each unique identifiers. If no change has occurred, the unique identifier's information doesn't need to be duplicated. In order to get a better understanding of the scope of the job- the xlsb file contains about 40,000 lines. We have about 165 csv file. Each of the csv files contains about 240,000 lines. At the end, we will need the files and a guide how to perform this operation ourselves in the future.
Ταυτότητα εργασίας: 11282011

Σχετικά με την εργασία

14 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hi, I have sufficient understanding of MySQL apart from a host of other programming languages and testing experience. If given an opportunity to work on this project, will definitely do a timely good job of it. And thanks for the detailed explanation of the requirements. 2 clarifications from your below statement: "The database with all of the combined files would not necessarily contain all of the fields in each of the csv files but to the very first csv file should be added all the changes in the information concerning each unique identifiers. If no change has occurred, the unique identifier's information doesn't need to be duplicated." 1. you meant that the combined database would not contain "all the rows" and not "all the field" - meaning one row for one unique identifier from across the 165 csv files. so if all the csv files had the same 260000 unique identifiers, our DB would also have 260000 records ? 2. The xlsb appears to be a subset of the unique identifiers from the csv files. I hope we will be provided either the real or close to real files for coding and testing to confirm such assumptions. Bidding for seven days to be safe. If all clarifications are received quickly, can complete before that too. Regards, Ramya
$30 USD σε 7 ημέρες
0,0 (1 αξιολόγηση)
0,0
0,0
14 freelancers δίνουν μια μέση προσφορά $135 USD για αυτή τη δουλειά
Avatar Χρήστη
Hi. Feel free to contact me about this project .
$240 USD σε 7 ημέρες
5,0 (15 αξιολογήσεις)
5,3
5,3
Avatar Χρήστη
the title isn't enough please describe what your project is about. thanks .
$150 USD σε 3 ημέρες
5,0 (30 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
Hi! For this price, I will try not only to solve what you need, but also an automatic software that can be configured and does the task anytime in the future. Thus, you will be able to repeat it whenever needed. It would be done in 2-3 days maximum.
$200 USD σε 3 ημέρες
4,7 (16 αξιολογήσεις)
3,7
3,7
Avatar Χρήστη
We are glad to welcome ! Somo a company of IT services. Among the tools we use Talend ETL, Data Mining used . We can handle the data presented by you, and ademar provide routines, sources and advice so that you can use and improve the process. Contact Us
$166 USD σε 5 ημέρες
5,0 (3 αξιολογήσεις)
2,3
2,3
Avatar Χρήστη
Python professional, the project could be done with Python, which is good at dealing with texts and files
$55 USD σε 3 ημέρες
5,0 (1 αξιολόγηση)
1,8
1,8
Avatar Χρήστη
working experience in creating updating tables,databases,stored procedures,etc,. if you are interested please feel free to contact me
$155 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της BULGARIA
Sofia, Bulgaria
5,0
12
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιαν 5, 2016

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.