Closed

data validation shiny interface

I have a shiny app that has an user interface to change datatype and create plots based on the data type. Would need to extend the app to additional features

Requirement: User uploads data as csv/excel. He reviews and edits the data and save it to a database ( can be just csv or excel for now). His validation should be base on the what is in the database.

Example: Lets say we have a database that has the following columns age, gender, race. The allowed datatypes are numeric and character. The values allowed are numeric ( non-decimal for age), Gender ( M, F, other) , Race ( B, W, M, A, Multiple). Lets say, the user uploaded an excel file with Colum name "Sex" values mostly as M, F and other, but some values are Male, Female etc. I would like to provide a screen in shiny app, that would allow the user to "map" the column names and values that are existing in the Database so that when he pushes that data into database the table has consistent representation. So, in this case on the "Mapping Screen" The user needs to change column name Sex to small case "gender" like in the database. Then, if there is Male in the column values that has to be changed to M and Female in the column name it should be changed to F. This need to be be done using the UI screen instead of writing an automatic mapper behind the screen. So, that user knows that he is validating and pushing the correct values and column names to the database.

User uploaded Gender values | database Gender values

M ---------------------------------------> M

F ---------------------------------------> F

Male ---------------------------------------> M

Female ---------------------------------------> F

Other ---------------------------------------> other

This kind of mapper has to be there for every "Character: column in the database. Finally, once mapped appropriately, display the complete table and then he should be able to append to the database.

Requirements for shiny app

Need modular shiny approach

Appealing mapping UI design

Basic cleaning of user uploaded data removing extra space, clean_names using janitor, identify any special characters and Notify user

No need for database setup, the concept can be shown by csv files

Styling app using custom css files

For existing plot add text box, so that the text added by user can be pushed to the existing markdown report

Current state of the app

We have modular app that allows user to change datatype, but it is not based on mapping to the database ( or a master file)

Based on the data type, user can create respective plots

User can choose how many plots he can add.

Deliverables

Requirements for shiny app

Need modular shiny approach

Appealing mapping UI design

Basic cleaning of user uploaded data removing extra space, clean_names using janitor, identify any special characters and Notify user

No need for database setup, the concept can be shown by csv files

Styling app using custom css files

For existing plot add text box, so that the text added by user can be pushed to the existing markdown report

Skills: R Programming Language

See more: excel data validation empty cell 2007, data validation marketing research, data validation methods market research, website data validation, telecommunication data validation, additional features jfreecharts, data validation list closed workbook excel, excel data validation extraction, exist data validation drupal, javascript card data validation, suggest additional features online exam system, vba excel data validation worksheet, market research data validation, additional features, data validation file file, data validation accounts payable, data validation excel file, mixed methods data validation variant

About the Employer:
( 0 reviews ) Bucharest, Romania

Project ID: #30176905

1 freelancer is bidding on average $180 for this job

iamashik24

hi i am a python ,R developer and machine learning engineer. i can do the project for you and get the code as per requirement. feel free to contact me and we can discuss the details .

$180 USD in 1 day
(0 Reviews)
0.0