data validation shiny interface
$30-250 USD
Paiement à la livraison
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
Nº du projet : #30176905
