NEW
Font size
S
M
L
XL
WorksheetsGetting and Cleaning Data
Total questions: 12
Worksheet time: 6mins
Name
Class
Date
1.
Raw data is ______
a)
A. Data that is ready for analysis
b)
B. Data that can be merged, subset and transformed
c)
C. Data that is often or difficult to be analyzed
d)
D. May be standards for processing
2.
Which of the following is most common problem with messy data?
a)
A. Column headers are values
b)
B. Variables are stored in both rows and columns
c)
C. A single observational unit is stored in multiple tables
d)
D. All of the mentioned
3.
Which of the following data is put into a formula to produce commonly accepted results?
a)
A. Raw
b)
B. Processed
c)
C. Synchronized
d)
D. All of the Mentioned
4.
Point out the correct statement:
a)
A. Nearly 80% of data analysis is spent on wrangling data
b)
B. Nearly 20% of data analysis is spent on data dredging
c)
C. Nearly 80% of data analysis is spent on the cleaning and preparing data
d)
D. None of the Mentioned
5.
Tidy data satisfies these rules except:
a)
A. Each variable in the data set is placed in its own column
b)
B. Each variable name is machine readable.
c)
C. Each observation is placed in its own row.
d)
D. Each value is placed in its own cell.
6.
Following represents correct sequence of steps in performing data analysis:-
a)
A. tidy data – data analysis -- raw data -- processing script
b)
B. processing script --- raw data --- tiny data --- data analysis
c)
C. data analysis --- raw data – processing script --- tidy data
d)
D. raw data – processing script --- tidy data --- data analysis
7.
Which one is FALSE?
a)
A. Columns = variables
b)
B. Rows = Observations
c)
C. Table = Data set
d)
D. File = Meta Data
8.
Which R package is used to read excel files?
a)
A. XML package
b)
B. Jsonlite package
c)
C. xlsx package
d)
D. datasets package
9.
Which of the following function is used for loading flat files?
a)
A. read.data
b)
B. read.sheet
c)
C. read.table
d)
D. None of the mentioned
10.
Here are the type of questions ask in data science except:
a)
A. What is the temperature in Shah Alam next Friday?
b)
B. Is it a SPAM or HAM?
c)
C. Which is the popular choice of flavors?
d)
D. Why people make donation?
11.
Read.csv2() is intended to ____
a)
A. read a comma as decimal point and a semicolon as field separator.
b)
B. read a comma separated value files.
c)
C. read a symbols or decimal point separated value files.
d)
D. read a character or white space separated value files.
12.
Which of the following is used to extract data from HTML code of websites?
a)
A. Webscraping
b)
B. Webdredging
c)
C. Webcleaning
d)
D. All of the Mentioned
Reset
