Metadata Creation - Functional capability to read any file format and provide a tabular exportable format containing :
1. Column Name
2. Column Type - Numeric(discrete/continuous),Date,Categorical(Unordered/Ordered)
3. Unique Key - this needs to be guessed - if row count of data is equal to distinct count of the records for this column, mark it as a unique key
4. Description - [Column to be left blank - to be filled by User]
5. Notes - [Column to be left blank - to be filled by User on any quick observations/annotations]
6. Missing Value percentage
7. No. of Unique Values
8. Min Value
9. Max Value
10. Q1 Value
11. Q3 Value
12. Average Value
13. Standard Deviation Value
14. Median Value
15. Top 5 Factor levels
1 2 |
path |
Specify the path of the file to be read into R.If it does not contain an absolute path, the file name is relative to the current working directory. |
data |
If the dataset is imported using other import packages, pass the dataset in the data argument. |
savepath |
The path of the xlsx file you want to save the analysis in. If the file does not exist it will create a new file of the specified name. |
sheet |
The name of the worksheet in which the analysis will be outputted.By default the sheet name is "Metadata" |
sep |
The field separator character. Values on each line of the file are separated by this character.By default the separator is ",". |
skip |
Integer: the number of lines of the data file to skip before beginning to read data.By default skip = 0. |
skip |
Integer: the number of lines of the data file to skip before beginning to read data.By default skip = 0. |
sheet |
Specify the sheet name of the excel file that you want to read in. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.