Analyze some Data
$30-250 USD
Πληρώθηκε κατά την παράδοση
Hello
I am looking to have a script/filter created for a csv/excel file. The file contains data on 28k items. Each item contains 39 columns of data most of which is irrelevant for this particular project. The focus is only on 8 of the columns (7 of these columns contain specs on each item, the 8th column contains price). A script needs to be created so that if all 7 columns have matching specs, the script then filters out the most expensive of those matching items and only leaves the cheapest priced item (column 8). This would also include multiple items with the same cheapest price. For example, the script returns 5 items that all have the same 7 specs. Item 1 has price of $500, Item 2 has price $490, Item 3 has a price $480, and Items 4 and 5 have a price of $475. Items 1, 2, and 3 would be filtered out and both Items 4 and 5 would remain. In addition, the script should still keep all items that are unique and do not yield any matching specs. The script will need to run weekly as the data will constantly be changing. I apologize if this sounds redundant but wanted to try and be as clear as I could on what needs to be accomplished.
Ταυτότητα Εργασίας: #13581708
Σχετικά με την εργασία
Ανατέθηκε στον:
Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Please look at the feedback left by my em Περισσότερα
29 freelancers κάνουν προσφορές κατά μέσο όρο $129 για αυτή τη δουλειά
First of all thank you for detailed description! I can create such script in less than a day and I can offer you best price here. All I need to start is your input file sample (for testing). Thanks. Roman
we have expertise in excel VBA,php,sql. client satisfaction is our main motto for long term relationship.
I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Finance Management Statistics Data Processing Data Collect Περισσότερα
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Περισσότερα
Hello Iam a java devveloper highly skilled in data Processing I suggest you a software done with Java with a Graphic User Interface(like a dashboard )and you have just to select the files you need to filter and it Περισσότερα
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
Bid Summmary Done lots of scripting before. I assume you need this on your servers to process some uploads. Can do this in different technologies, ruby, php, R. let me know ur preference can get it ready in a day
Hello Can you please share sample csv file with me and I'm ready to work on this project. Have good day thank you so much
Hi, I am an excel expert and have done numerous projects. I am also a Chartered Accountant by profession and have done projects around business planning, analysis, research, financial modeling for various clients. Περισσότερα
Hi . l have great experiences dealing with Excel and VBA I read the job description, it is in my interest field l am looking forward to working with you . Many thanks .
Hi, I am professional freelancer and student of theoretic informatics, I have several experience with data processing. Hire me and you will get a TOP quality product! Regards, Bc. Martin Risa
Respected Recruiter, I am writing in response to the above mentioned job requirement. I have read your job details and I can assure you that I can complete the work before the mentioned time Please find below t Περισσότερα
I have experiance in similar tasks and I can make solution with VBA code. You can started this macro when it is nessesary.