Python & Pandas - Fundamentals
DataFrames, Series, indexing (loc, iloc), boolean filtering, data types, read_csv, describe, info, head/tail, shape, columns
1What is the main Pandas data structure for storing tabular data?
What is the main Pandas data structure for storing tabular data?
Answer
The DataFrame is the core Pandas data structure. It represents a two-dimensional table with rows and columns, similar to a spreadsheet or SQL table. Each column is a Series, and each row has an index. The DataFrame enables efficient manipulation of structured data through its many built-in methods.
2What is a Series in Pandas?
What is a Series in Pandas?
Answer
A Series is a one-dimensional array with an index. It represents a single column of data in a DataFrame. Each element has a label (index) enabling fast access by name or position. A Series can hold only one data type (int, float, string, etc.), which distinguishes it from a plain Python list.
3Which Pandas function reads a CSV file and loads it into a DataFrame?
Which Pandas function reads a CSV file and loads it into a DataFrame?
Answer
The pd.read_csv() function reads a CSV file and returns a DataFrame. It accepts many parameters: sep for the delimiter, header for the header row, encoding for file encoding, dtype to force column types, and na_values to define missing values. It is the most common method to import data into Pandas.
What does the df.shape attribute return on a DataFrame?
Which method displays the first 5 rows of a DataFrame?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Fundamentals
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
BigQuery - Fundamentals
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Cohort and Retention Analysis
Google Tag Manager and Tracking
APIs and Webhooks
dbt - Fundamentals
AB Testing and Applied Statistics
Looker Studio (Google Data Studio)
Power BI - Fundamentals
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free