Closed

Web Application to Automate Manipulation of Spreadsheet / CSV Data using AWS, S3 & Lambda

We're a Healthcare staffing company in the Atlanta, Georgia area. We have a manual process that needs to be automated. This process involves manipulating an input file using reference data from three other reference files to produce an output file. Each of the files is a CSV/XLS file.

There are three(3) reference datasets -- call them REF-A, REF-B, and REF-C. There is an input dataset in another CSV/XLS file (INPUT) which must be manipulated to create the output file (OUTPUT).

The current process involves adding spreadsheet columns, moving data around, inserting lookups to the reference files, and manipulating some fields (eg. adding or removing hyphens from social security number, searching field for a substring, etc. All of these things can be done programmatically while parsing the input file.

What I envision is a password protected web application that allows the three reference files to be uploaded. Then, an input file is uploaded, click a button which causes the file to be processed and provides a link to download the output file. The process can be repeated over and over using additional input files.

I'm open to implementation discussion and various architectural/implementation strategies. But, I have a strong preference to a server less implementation using AWS Lambda functions and S3 object store. Could be implemented in Java, Node.js or python. Can use other AWS services but would like a minimal cost approach.

Skills: Aws Lambda, HTML5, node.js, Python

See more: php create table csv data, insert data using file csv sysutil, csv data feed web page, import csv mysql using web form, import data csv file using dts wizard, application automate web surfing, capture web site data using robots, sugarcrm click attachment open application, export crm data using web service, retrieve data csv file using javascript, using data csv file using javascript, data manipulation excel csv file, excel csv data manipulation, download web page existing excel spreadsheet using vbscript, import data csv access using vb6, using turbo lister import csv data template, csv data manipulation, fill in a spreadsheet with data using a two tabbed file, simple web scraping fill in a spreadsheet with data, extract data from csv files using R

About the Employer:
( 0 reviews ) College Park, United States

Project ID: #17986377

21 freelancers are bidding on average $217 for this job

bluediscover

Hi, As you can see on my profile, I have expertise in AWS products. I can develop well architectured project with AWS Lambda, S3, etc. For serverless I prefer to use python. Looking forward to discussing in cha More

$333 USD in 3 days
(59 Reviews)
7.2
shadabkhan92

https://www.freelancer.com/projects/Python/Qualitative-Comparative-Study-Face-13933384/ https://www.freelancer.com/projects/php/License-Plate-Detection-With-Chinese/ lets chat

$333 USD in 3 days
(24 Reviews)
6.2
leemilun

Hi, Dear. Nice to meet you. I've read your post carefully. I'm Python/Web expert. Please discuss more details on chatting room. Regards. Gao M.

$222 USD in 3 days
(18 Reviews)
5.3
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Web Application to Automate Manipulation of Spreadsheet. I've delivered more than 400 + projects in the last 5 years and this mak More

$180 USD in 3 days
(21 Reviews)
5.3
adeelpirzada

Hi, I am a Senior Software with more than 10 years of experience in .Net-stack development. I have developed dozens on Desktop Apps, Utilities, Automation Tools, Machine Learning Tools, Web Apps using Python, C# and More

$35 USD in 3 days
(7 Reviews)
5.1
DarkKnight2206

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

$140 USD in 2 days
(22 Reviews)
5.1
novepi

Hi there, The requirement are quite clear and straightforward to implement so no questions really. All I need from your end is detailed instructions for the data manipulations by using sample files if possible. More

$200 USD in 3 days
(6 Reviews)
4.3
teguhpanjaitan

Hi, I'm a full stack developer. I'm working with AWS everyday and know how to do it with serverless method (S3 & Lambda). I would propose to modify the spreadsheet using PHP in lambda function. Please consider my bid More

$250 USD in 5 days
(4 Reviews)
3.3
Nerdulent

Hi.... By when do you expect it to be delivered?? Thanks

$155 USD in 10 days
(5 Reviews)
2.8
coriandercode

Hi! My name is Mohd. And I am an expert Desiner & Developer. I can do your task as you posted as i am having similar work done exp. That is why i am best fit for [login to view URL] contact me asap so that i serve you b More

$155 USD in 3 days
(5 Reviews)
2.9
nagarajdvdg2009

Hi, I have 8 years of experience in Software development. I have good knowledge on AWS and Lamda. Hope we can have more conversation about the requiremnt

$111 USD in 4 days
(2 Reviews)
2.1
gwpuck89

Hi there, I'm a fairly well-experienced AWS devops engineer *and* web developer and I'd be happy to help you with this project. I think your idea of using Lambda/S3 is probably the least expensive route. However, More

$250 USD in 3 days
(2 Reviews)
1.8
mkdara

Hi there, I'm grateful that you spared a part of your precious time for having a look at my proposal. I expertise in the field which is required in your project and I will deliver complete satisfactory work. I have en More

$200 USD in 10 days
(1 Review)
2.0
agrawal92

Hi, I can help you in implementing the mentioned requirements using Python along with AWS services. I've worked on a similar project before where I've integrated services like AWS Lambda, Step Functions, AWS Glue and A More

$125 USD in 10 days
(3 Reviews)
1.6
WebDevPro007

I can provide a process with input and output directories I'm already doing it for a client called Ubits You will have mail notification and logs we can also provide SMS notification if you want. Looking forward More

$333 USD in 7 days
(0 Reviews)
0.0
freelanceSpider

Hello sir Manipulation of excel/csv is quite possible in browser itself with background web worker, provided files are not too big. Although we can save generated files in S3 and if required further can be automated w More

$111 USD in 10 days
(0 Reviews)
0.0
caseyuhrig

Perfect for my skill set, I actually do data conversion for my own personal company. This projects sounds like like what I normally do :)

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

You have not talked about how you want the front end presented ( except that password protected web application ), so I am a little concerned on how much work and polish you require on the presentation level.I have bee More

$155 USD in 3 days
(0 Reviews)
0.0
DimuDesigns

Hello, Interested in the job. I am a Software Engineer specializing in end-to-end Web Development with expertise building applications that utilize Google's Cloud Platform (GCP). GCP is Google's server-less eq More

$750 USD in 21 days
(0 Reviews)
0.0
webdevgirl528

We have successfully completed several commercial contracts of varied scope and size in 2018. We specialize in design and building software, Artificial Intelligence, Data Science, Databases, websites, SEO, Graphic and More

$155 USD in 3 days
(0 Reviews)
0.0