Find Jobs
Hire Freelancers

C# Data Quality / Data Cleansing Procedures

$25-50 USD / hour

进行中
已发布超过 8 年前

$25-50 USD / hour

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 [login to view URL] 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 & proposal, 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.
项目 ID: 8227308

关于此项目

19提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I maybe use C#reflection, process string, Linq to object, lamda expression to check and build dynamic condition: 1. Validating A, B, C, ... must be one of field name in datatables. If does not exists -> return False. 2. Validate fields in input formula to make sure they are the same datatype before build and execute the condition to get the result. If does not match -> return False 3. Replace fields in input formula by Row[fieldName] to retrieve data for comparison. 4. Pass the condition into lamda expression to run condition and get the result -> If the return of Action is false then add this to List<T>.
$27 USD 在10天之内
4.9 (24条评论)
5.8
5.8
19威客以平均价$34 USD/小时来参与此工作竞价
用户头像
Hello! My name is Janos and I would like to help you on this. Thanks to your concise description I believe I have a good understanding of the requirements. It's an interesting project! About: I have 12 years of experience with .net and SQL development coming from both a corporate environment (for the last 1p years I led development of SEWS-CE a major automotive company's bespoke ERP, EDI & MRP systems) as well as freelancing (please see my previous works here). Please can you get in touch via the freelancer chat to discuss the handling of the validation rules in detail? I look forward to speaking to you. Regards, Janos
$42 USD 在20天之内
5.0 (24条评论)
7.3
7.3
用户头像
Hi. I have exp in C# and have done alot of similar projects. I am ready to do this project for you. Thanks!
$50 USD 在40天之内
4.6 (68条评论)
6.6
6.6
用户头像
Hello, I found your offer very interesting for me. I'm skilled IT developer with more than 7 years experience with .NET development. I've developed wide range projects with using .NET for WEB an Desktop. I have used such technologies as MVVM, MVC, IoC, Prism(Unity, MEF), etc. I can offer you full stack development service and up to 40 hours per week work schedule. I would be glad to discuss your project in details. Best regards, Oleg
$41 USD 在3天之内
5.0 (19条评论)
5.9
5.9
用户头像
A proposal has not yet been provided
$50 USD 在3天之内
5.0 (40条评论)
6.0
6.0
用户头像
Hello, YSoft Solution, a leading software development company based in India. We have expertise in Asp.net and we have developed many web applications using asp.net. Our team of expert can work on this task and complete within deadline. We have good experience in .NET, C# Programming and we can achieve this task easily. It will be our pleasure to work with you as our team of experts can use their expertise on this task. Please send me message, so that we can converse further about this task. Our skills : Asp.net ,HTML C#/VB and SQL server Thanks
$30 USD 在30天之内
5.0 (16条评论)
5.6
5.6
用户头像
Hi, Please feel free to discuss the project with me ................................................................................................................... Thanks, Murtaza
$30 USD 在40天之内
5.0 (11条评论)
4.5
4.5
用户头像
[ Ready to Start work on the next minute you award me] Dear Hiring Manager, I have carefully read your project requirements and I totally understand the need of your project. Here introducing myself in very straight forward way. I am not believed in long cover letter. Key Features : 8+ years of Experience / 200+ Project Build / Fluent English / Hardworking / Honest / Flexible Time / Work on Weekend / Have Passport / Visited Germany 2012 for Client side work. SKILL : ASP.NET,Sitefinity,Classic ASP,MVC4,MVC3,C#,VB.NET,Dotnet Nuke,Html5,Facebook API, Bootstrap Responsive Mobile,Xamarin,NHibernet,Ajax,Java Script,AngularJS,JQuery,SQL Server and I'm very interested in your job post involving these skills. Portfolio will be send on request. I am available to chat by IM, email or Skype, and would be happy to set up a convenient time to discuss the application you're moving and some ideas about the safest way to get it into the cloud. I will be available 48+ hours per week for this position Warm Regards!
$25 USD 在48天之内
5.0 (6条评论)
4.0
4.0
用户头像
Dear sir, The excel or json file that you upload is not a table based data. It's a kind of matrix, therefore, it should be modified first into tables so it can be processed. I have made a simple and raw mockup application based on your excel file. I need youto chat with me, so i i can attach the program or screenshots. Regards
$27 USD 在30天之内
4.9 (11条评论)
3.8
3.8
用户头像
Hi, Looks like the Excel sheet is missing. Please share the same. Once I have a look at the same I should be able to discuss the approach with you. Let me introduce myself as an expert C# programmer. I have worked on C# using Visual Studio 2003, 2005, 2008 , 2010 and 2012 with back ends like MS Access 97,2000, 2003, 2007, SQL Server, MySQL and Oracle. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$40 USD 在10天之内
5.0 (15条评论)
3.8
3.8
用户头像
Предложение еще не подано
$25 USD 在3天之内
5.0 (1条评论)
0.2
0.2
用户头像
HI For this project I can write best procedure with handling performance issue too. As you need in C# and not on db side there will be concern for performance which can be handle easily in C#. Waiting for your reply.
$27 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, Here are a couple of questions, to glean more clarity into this project: 1. What is a procedure? Is this an add-on in excel that you are looking for, which you would then want to call inside your VBA scripts? 2. In the sample formulae - what are A, B & C? These might be actual columns in the excel, but there would need to be some checks around the type of data they hold. We can integrate those checks in 3. The output, I assume, is a list of failed rules, which brings me to a couple of related questions a. We would need to model a Rule object b. The list returned would contain a Rule objects that would have a tostring built in, which can be called to return a string representation of the rule. Let me know if this understanding is correct 4. Please provide for the excel file. I did not see that attached here Timelines: Will be able to start next week working 3 hrs/day only on business days Initial estimate is at least a week's worth of work. This might increase depending on further discussions that uncover more details. Thanks, Algofactory
$30 USD 在3天之内
0.0 (1条评论)
0.0
0.0
用户头像
We have gone through your proposal , as per my understanding it look like you want A "Rule Engine" for product, We have develop kind of "Rule Engine", so we can bring your desire output, As per my knowledge the timeline you have given its too short for this project, it will require around 20 days/3 hrs a day, first we will develop a API for Rule Engine and need to call this API for desire output. also we will provide basic UI design for manage Rule Engine.
$38 USD 在20天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$25 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Ardmore, United States
5.0
17
付款方式已验证
会员自4月 18, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。