Analyze some Data

Ολοκληρωμένο Αναρτήθηκε Πριν 6 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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.

Επεξεργασία Δεδομένων Excel PHP XML

Ταυτότητα Εργασίας: #13581708

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

29 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 6 χρόνια

Ανατέθηκε στον:

dpune

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 Περισσότερα

$100 USD σε 3 μέρες
(155 Αξιολογήσεις)
6.4

29 freelancers κάνουν προσφορές κατά μέσο όρο $129 για αυτή τη δουλειά

gangabass

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

$77 USD σε 1 μέρα
(465 Αξιολογήσεις)
7.4
axiomswb

we have expertise in excel VBA,php,sql. client satisfaction is our main motto for long term relationship.

$100 USD σε 4 μέρες
(73 Αξιολογήσεις)
6.4
rumarahman

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 Περισσότερα

$100 USD σε 1 μέρα
(38 Αξιολογήσεις)
5.1
prabakarm23

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 Περισσότερα

$55 USD σε 3 μέρες
(57 Αξιολογήσεις)
5.0
kahilH

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 Περισσότερα

$70 USD σε 3 μέρες
(37 Αξιολογήσεις)
5.3
surekash7096

I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.

$100 USD σε 2 μέρες
(68 Αξιολογήσεις)
5.4
modsaid

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

$150 USD σε 1 μέρα
(3 Αξιολογήσεις)
3.8
IMExpertEngineer

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

$277 USD σε 3 μέρες
(3 Αξιολογήσεις)
3.4
GuruExcel

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. Περισσότερα

$200 USD σε 3 μέρες
(8 Αξιολογήσεις)
3.2
mahmoud249

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 .

$30 USD σε 3 μέρες
(3 Αξιολογήσεις)
1.8
rajeshrafaliya

A proposal has not yet been provided

$150 USD σε 3 μέρες
(1 Κριτική)
0.6
jalpa18061992

A proposal has not yet been provided

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
martinrisa1

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

$54 USD σε 1 μέρα
(0 Αξιολογήσεις)
1.7
ajaybaidya

A proposal has not yet been provided

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
rohitnag92

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 Περισσότερα

$133 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
shevitza

I have experiance in similar tasks and I can make solution with VBA code. You can started this macro when it is nessesary.

$138 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0