Boolean logic Flashcards
What is a Boolean operator?
a symbol that names the operation or calculation to be performed
What are the more common terms for rows and columns in data analytics
Rows = Records
Columns = Fields
What is ‘Long’ data?
Data in which each row is one time point per subject, so each subject will have data in multiple rows
What is ‘Wide’ data?
A dataset in which every data subject has a single row with multiple columns to hold the values of various attributes of the subject
Define data transformation
Data transformation is the process of changing the data’s format, structure, or values.
Why might you transform data?
Organisation, compatibility, migration, merging, enhancement, comparison.
When is wide data preferable?
When creating tables and charts with a few variables about each subject, and when comparing straightforward line graphs
When is long data preferable?
When storing a lot of variables about each subject (eg; 50 years worth of interest rates for multiple banks), and when performing advanced statistical analysis or graphing
What is unstructured data?
Data that is not organised in any easily identifiable manner
What is structured data?
Data organised in a certain format such as rows and columns
What is string data?
A sequence of characters and punctuation that contains textual information
What is text data?
A sequence of characters and punctuation that contains textual information (also called string data
What is nominal data?
A type of qualitative data that is categorised without a set order
What is ordinal data?
Qualitative data with a set order or scale
