Preparation of a Data
Oluwaseun Eyebiokin
Data Analyst | Data Entry | Clinical Statistical Programmer | CDISC Standards (SDTM, ADaM) | Data Wrangling | TFL Generation (Tables, Listings, Figures) | Data Visualization | R Programming | Python for Data Science
"Data comes in many formats but the only ones that are preferred are the ones that are Tidy data", so says Garrett Grolemund. Hadley Wickham put it that "Tidy datasets are all alike; but every messy data is messy in its own way. I quoted this to show the importance of having not just table, dataset but a tidy table, dataset. Being neat is not what makes a data Tidy and being Tidy is not about shoving everything into one table. Before performing any analysis on a data one of the most common, consistent things to do is to explore the data, checking the solid (blank) columns, looking for the columns that does not fit into the table on which analysis is performed on, removing the columns before starting the analysis, checking the column names to be sure that the values in it really match what is on top of the columns, like having a date value but the column being named currency, in this case the column name need to be changed. After preparing the data, one is good to go ahead with the analysis. hashtag#My3MTT hashtag#3MTTWeeklyReflection