Analyze some Data

$30-250 USD

已完成

已发布

大约 7 年前

$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.

项目 ID: 13581708

关于此项目

29提案

远程项目

活跃7 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 employers to know more about my work. Waiting for your positive response. Thanks.

$100 USD 在3天之内

4.9

(155条评论)

6.4

29威客以平均价$129 USD来参与此工作竞价

@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天之内

5.0

(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天之内

4.9

(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 Collecting (Using Macro) MS Office C++ HTML VBA Mathematics Excel VBA Macro Automation User Forms Data Analyzing PivotTable Chart Graphic Presentations Photoshop Data Presentations And any task related to Excel Feel free to contact me.

$100 USD 在1天之内

5.0

(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 have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details and the price is negotiable based on the project.

$55 USD 在3天之内

5.0

(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 will be proceeded Thank you in advance

$70 USD 在3天之内

4.8

(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天之内

4.6

(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天之内

4.7

(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天之内

5.0

(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. I have understood your requirement on creating filters (automated) on your worksheet. I can quickly deliver the task and customise it as per your requirement. Further value addition would also be provided. Message me so that we can discuss the details and take it forward. Regards, Dinesh V I believe that the combination of my expertise in Excel and my immense experience in Finance field would be a great advantage to have.

$200 USD 在3天之内

4.7

(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天之内

5.0

(3条评论)

1.8

@rajeshrafaliya

A proposal has not yet been provided

$150 USD 在3天之内

5.0

(1条评论)

0.6

@jalpa18061992

A proposal has not yet been provided

$155 USD 在3天之内

0.0

(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.0

(0条评论)

1.7

@ajaybaidya

A proposal has not yet been provided

$155 USD 在3天之内

0.0

(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 the brief description about my Education and Technical Expertise: I have done Bachelor of Engineering in Computer from the top most reputed university in India. I was university topper. My work experience during the last 18 months in MuSigma(Data Analytics Firm) includes supporting world largest Retail Giant in improving performance and optimizing processes all-round the globe. I have worked hands on on Microsoft Excel, Tableau and SQL. I have advanced level knowledge of Excel which comprises of: • All basic Excel formulae • Array Formulae, Conditional Formatting • Creating dashboards and charts in excel • Pivot Tables and Pivot Charts • Using Excel VBA for automation of the repeated process • Linear Regression Analysis, Time Series-Moving Average Analysis, t-Test, z-Test, ANOVA Analysis etc using Excel Also, my knowledge on Tableau comprises of creating different types of charts and dashboards, to represent the data in the most understandable way. I have very good level knowledge of Tableau which comprises of: • Creating different type of dynamic charts • Using Level of Details(LOD's) formulae in calculations • Using best practice tips and tricks to reduce the buffer time in tableau • Creating visually appealing dashboards

$133 USD 在3天之内