NEW
Font size
WorksheetsData Mining MID TERM content 1
Total questions: 75
Worksheet time: 38mins
In Python, which library is commonly used for data manipulation and analysis?
NumPy
Pandas
Matplotlib
TensorFlow
In Pandas, what is the function used to check the data types of each column in a DataFrame?
.types()
.dtypes
.get_types()
.checktypes()
If a Pandas column shows dtype: object, what does this usually represent?
Floating-point numbers
Strings or mixed data types
Boolean values
Date and time values
Which Pandas data structure is one-dimensional and similar to an array or list in Python?
DataFrame
Series
Dictionary
Tuple
What is the default dtype of integers in Pandas if you create a Series like pd.Series([1, 2, 3])?
float64
int32 or int64 (depending on system)
object
bool
What is the purpose of the line import pandas as pd?
To rename the Python interpreter
To import the pandas library with an alias
To install pandas in the code
To import pandas and NumPy together
If we want to calculate the average Price of all items, which Pandas function is most appropriate?
df['Price'].mean()
df['Price'].sum()
df['Price'].count()
df['Price'].min()
What is the main goal of Data Mining?
To delete unnecessary data
To extract useful patterns and knowledge from data
To store data in databases
To clean data only
Which of the following is a type of data commonly used in Data Mining?
Text data
Numerical data
Categorical data
All of the above
Python is widely used in Data Mining because it is:
Complex and hard to learn
Limited to only numerical operations
Easy to use and has powerful libraries
Only for making websites
Which Python library is most commonly used for data manipulation and analysis?
NumPy
Pandas
Matplotlib
TensorFlow
Jupyter Notebook is best described as:
A text editor only
A web-based environment for writing and running Python code
A library for data visualization
A programming language
In Python, a Series in Pandas can be described as:
A 2D labeled data structure
A 1D labeled array
A collection of Python functions
A type of chart
A Pandas DataFrame is essentially:
A single list of numbers
A 2D table of rows and columns
A database
A file format
Which of the following is a valid Python data type?
Integer
String
Boolean
All of the above
If you want to install a Python library, which command is commonly used?
run install library_name
download library_name
pip install library_name
setup library_name
In Jupyter Notebook, which key combination is often used to run a cell?
Shift + Enter
Ctrl + S
Alt + Tab
Ctrl + C
CLS permanently clears all files in the current directory.
True
False
CD .. moves the user to the parent directory.
True
False
The REN command can be used to move files to another directory.
True
False
In DOS, the wildcard ? replaces one or more characters in filenames.
True
False
The wildcard * can match zero or more characters in a filename.
True
False
The CHOICE command allows branching based on user input.
True
False
How to insert comments in Python ?
# this is a comment
// this is a comment
/* this is a comment */
What is the main goal of Data Mining?
To delete unnecessary data
To extract useful patterns and knowledge from data
To store data in databases
To clean data only
Which of the following is a type of data commonly used in Data Mining?
Text data
Numerical data
Categorical data
All of the above
Python is widely used in Data Mining because it is:
Complex and hard to learn
Limited to only numerical operations
Easy to use and has powerful libraries
Only for making websites
Which Python library is most commonly used for data manipulation and analysis?
NumPy
Pandas
Matplotlib
TensorFlow
Jupyter Notebook is best described as:
A text editor only
A web-based environment for writing and running Python code
A library for data visualization
A programming language
In Python, a Series in Pandas can be described as:
A 2D labeled data structure
A 1D labeled array
A collection of Python functions
A type of chart
A Pandas DataFrame is essentially:
A single list of numbers
A 2D table of rows and columns
A database
A file format
Which of the following is a valid Python data type?
Integer
String
Boolean
All of the above
If you want to install a Python library, which command is commonly used?
run install library_name
download library_name
pip install library_name
setup library_name
In Jupyter Notebook, which key combination is often used to run a cell?
Shift + Enter
Ctrl + S
Alt + Tab
Ctrl + C
what is the output of the code?
x = "apple"
y = "banana"
x = y = z = "Orange"
print(x)
print(y)
print(z)
Orange
Orange
Orange
apple
banana
Orange
banana
Orange
Orange
None of the above
What is data?
Processed facts with meaning
Raw facts and figures
Organized information
Interpreted results
Which of the following is information?
The number 45
A list of names
Average age of customers
Random characters
What does Data Science combine?
Math, programming, and art
Programming, math, and statistics
Science, biology, and math
History, logic, and math
Data mining is best described as:
Writing Python code
Discovering patterns from large datasets
Storing information in databases
Drawing graphs with Matplotlib
Which is structured data?
A CSV file of sales records
A folder of memes
A YouTube video
A voice recording
Which is unstructured data?
Excel table
SQL database
Social media posts
School grades sheet
Why is Python popular in data mining?
It’s very old
It has powerful libraries and is simple
It only works with numbers
It doesn’t require syntax
What does PIP stand for in Python?
Python Interpreter Program
Python Installer for Packages
Program Installation Protocol
Python Index Package
Which of the following is a Python library?
Excel
Pandas
What is a dataset?
A single number
A group of related data
A programming language
A library for graphs
Which of the following is a data type?
Boolean
Pandas
Numpy
Matplotlib
An integer is:
A decimal number
A whole number
A True/False value
A string of characters
A float is:
Text
A number with decimals
Only whole numbers
True or False values
Boolean values are:
Numbers
Text
True or False
Fractions
Which is a string?
25
25.6
"Hello World"
True
Syntax in programming is like:
Grammar in English
Colors in art
Steps in cooking
Notes in music
A conditional statement is used for:
Loops
Making decisions
Defining strings
Adding numbers
Operators in Python include:
+, -, *, /
if, else, while
print(), input()
True, False
An array is:
A table of rows and columns
A collection of items in one variable
A set of functions
A loop command
Which library is best for handling arrays?
Pandas
Numpy
Seaborn
Matplotlib
Pandas is mainly used for:
File storage
Machine learning
Data analysis in rows/columns
Graphics design
Which Python library creates charts?
Pandas
Matplotlib
Seaborn
Scikit-learn
Which library is built on Matplotlib?
Pandas
Numpy
Seaborn
Scikit-learn
Scikit-learn is mainly for:
Web design
Data storage
Machine learning
Image editing
What are batch files used for?
Drawing graphs
Automating tasks in Windows
Writing emails
Browsing the web
What does the ECHO command do?
Deletes files
Shows text on screen
Hides folders
Clears memory
The CLS command is used to:
Clear the screen
Copy files
Show directory
Run Python code
The DIR command shows:
Directories and files
Python libraries
Excel formulas
SQL queries
What is REM in a batch file?
Remove files
Restart memory
Write comments
Rename folder
Which Excel function finds the position of text?
MID
LEFT
FIND
LEN
Which function extracts characters from the middle of text?
RIGHT
LEFT
MID
COUNT
LEFT function extracts text from:
Right side
Middle
Beginning (left side)
Random characters
RIGHT function extracts text from:
Left side
Middle
End (right side)
Start_num position
TEXTSPLIT is used to:
Count numbers
Split text into pieces
Add values
Remove duplicates
COUNT function counts:
All text values
All cells, empty or not
Only numbers
Only strings
COUNTIF counts cells:
Without conditions
Based on one condition
With multiple criteria
Randomly
VLOOKUP searches a value in:
Any row
The first column of a table
A batch file
Python arrays
LEN function returns:
File length
The number of characters in text
The last character only
The first number in a list
SUM function is used to:
Divide numbers
Add numbers
Subtract numbers
Count words
In Pandas, pd.DataFrame() is used to:
Create a dataset table
Open a batch file
Start a Python IDE
Run machine learning
