C# Data Quality / Data Cleansing Procedure

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

I need an example procedure written in C# .NET which I will be integrating into an existing web application.

The goal of the procedure is to evaluate 'rules' against a dataset to check the quality of the data. If a rule fails, it will be output to the user at the end

We need to effectively run two different types checks as part of this sample and we may need to get into more complex scenarios going forward. The types of checks we need to run:

1. Is A > B (and derivatives of this i.e. A >= B, A < B, A <= B, A=B,A!=B)

2. Is A+B > C or SUM(A,B) > C

If a rule is passed, we don't need to see any output.

If a rule fails, we would need to add it to a list and see a consolidated list of failures at the conclusion of the check.

Sample Data:

I've attached two tables in the file. One with data which should allow you to run these checks. You should import this into the application as json (see [url removed, login to view] attached for the same data converted to json) or similar.

Using this data, you need to implement the Rules checks on the 'Rules' tab of the Excel file.

This should not be hard coded. I need the ability to pass fields to any functions etc so I can make these checks dynamic in the future.

In your bid, please discuss a little about how you think you would solve this problem. Do you have experience implementing such algorithms in a dynamic manner? Also, please discuss how long you think this will take you and when you are able to start.

I will award this project quickly if someone shows they are able to complete and start quickly.

.NET C# Programming Data Processing

Project ID: #10526128

About the project

22 proposals Remote project Active 7 years ago

22 freelancers are bidding on average $192 for this job

agilepksolutions

Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 4+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I u More

$147 USD in 3 days
(52 Reviews)
7.0
zuiguanglong

C# is my main skill! I found your job post and I'm very interested in your project. As a certified desktop application developer with 10-years experience developing C#, I think I have the right skills you're looki More

$155 USD in 3 days
(38 Reviews)
6.0
ngscoder

Hi I am UK based, Microsoft Certified Professional in C# and SQL Server with 10+ years of experience. I am full time freelancer and would like to take on your project. I can start tomorrow morning and will be abl More

$277 USD in 3 days
(27 Reviews)
5.8
logos104

Hi. I have about 15 years of programming experience. Mostly I used C, C++ and C# for my projects development. You mentioned that you've attached samples, but I see nothing attached to the project. Could you send me s More

$200 USD in 3 days
(56 Reviews)
5.4
eperfections

I have 10+ years experience. I am the BEST programmer on this platform. Ready to start immediately. Plz share complete details.

$250 USD in 3 days
(21 Reviews)
5.0
murtaza1981

Hi, Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. Thanks, Murtaza

$250 USD in 5 days
(11 Reviews)
4.5
clickok

Dear Sir. It's a pretty straightforward project. My idea about that project is 3 "tabs": 1) Main Tab. where the user will select the json file, click "Execute" button and, using the Rules, will display in a gri More

$210 USD in 9 days
(10 Reviews)
4.2
XpaMoBHuk

Hi, Files were not attached. Could you send them please. The general approach is to load these sets as dynamic lists, load a separate list of defined rules and create an algorithm to apply rules against these sets More

$200 USD in 5 days
(6 Reviews)
4.3
AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to pin More

$200 USD in 3 days
(3 Reviews)
3.8
pakaimsolutions

Hello, I hope you doing very well! I have gone through the description and would like to provide a quality solution using my 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#). More

$125 USD in 3 days
(8 Reviews)
3.3
ikeyan

Hi, I would like to take up this assignment... I use Visual Studio 2010, C# .... Appraoch: 1) Use dynamic query building algorithm... 2) Keep the validation rules in an xml to make this as an extensive app... More

$200 USD in 3 days
(1 Review)
3.4
JindoVu

Hi Boss! The problem just only check logic your bussines, with extensive experience web application .NET so I believe that I can fix problem for you faster hope we will build long time relationship. I look forwa More

$150 USD in 3 days
(1 Review)
1.0
kenblock112

I am 5+ year experienced .net developers working as path time freelancers from last 5+ year, developing websites, window application. My main goal is to provide Life & Quality of work to IT within time. I am working on More

$155 USD in 3 days
(1 Review)
0.8
microg

Hi, I'd be happy to implement the ruleset and validation mechanism for you. I'm available every day and I can start working for you almost instantly. I'm located in Canada (Pacific Timezone) but I can accommodate my More

$222 USD in 3 days
(0 Reviews)
0.0
Reynarr060

Hello, I fell that I am more than capable with performing the tasks appointed to me because this is what I do for a living and I see this everyday, meaning you get fast high quality work along with great customer servi More

$235 USD in 5 days
(0 Reviews)
0.0
BubbleJet23

Hey mate, You have no files attached to the project? I'm a C# Developer and bidding low to get my first initial C# project under my belt. Let me know if you would like to proceed with my bid and send through any req More

$30 USD in 3 days
(0 Reviews)
0.0
haroldborda

I have 16 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact me to clarify all details.

$100 USD in 3 days
(0 Reviews)
0.0
MuteXsolutions

Hi, We read your description and we are interested to give you the solution. Kindly message us here and then we will send you the document with the brief understanding and the solution. We have experienced individua More

$127 USD in 4 days
(0 Reviews)
0.0
misterkim79

I have 8 years of experience in .net developing software. I'm always do my work in time and you will be satisfied. In last time I often work with asp.net mvc and entity framework, sql server, angularJs. In most cases t More

$244 USD in 3 days
(0 Reviews)
0.0