Clean up excel spreadsheet imports by triming the number of columns, automatically chooses first complete row which row should be the top row useing "complete.cases"
1 | at_trim_xlsheet2(df, column_last = ncol(df))
|
df |
dataframe imported from excel that needs to be trimmed and cleaned |
column_last |
numeric identifier for the last column to be imported. defaults to the last column present. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.