
This course includes our updated coding exercises so you can practice your skills as you learn.
See a demo
Variables are essentially labeled containers used to store data values. Instead of remembering a specific number or string, you give it a name like user_age = 25.
These are the symbols that perform actions on variables and values.
Arithmetic: +, -, *, /.
Comparison: == (equal to), != (not equal), > (greater than).
Explore solution operations in Python for data analytics and data science, applying practical coding patterns to streamline problem-solving workflows.
Lists are ordered collections of items stored in a single variable, defined by square brackets [].
Accessing Elements in a List
Modifying Elements in a List
Adding Elements to a List
Removing Elements from a List
Removing an Item by Value
This is how your code makes decisions. It checks if a condition is True or False. If it’s true, the code inside runs; if not, it skips it (or goes to an else).
You will need these datasets for the next exercises
Introduction to Pandas library in Python using Google Colab
- Import pandas as pd
- Upload datasets
- Explore datasets
You are going to learn how to select specific columns in dataframe
Learn to select data frame rows in Python for data analytics by filtering on salary above 80000, using string contains, and combining conditions with and and or, with proper brackets.
- Here you are going to use isnull() and sum() functions to detect missing value in dataset
- Treating missing values with dropna() etc.
Sometimes your dataset has a seperator which is not comma (,) in this case your read_csv() will have problems to read it. You need to specify it
We are unifying Employees lists together
Concatenate two tables into a single dataframe, then reset the index with drop equals true to drop the old index and create a new continuous index that continues.
Rename a column in a pandas data frame to label pay as gross salary, using df3.rename with in place, and verify the updated columns.
Create a new column to compute net salary by deducting 23% tax from gross salary, and validate the results.
setting up colab environment
Learn to set up Google Colab, connect to Google Drive, install and import pandas, locate your dataset, and read a csv with a named index and missing values.
Learn how to encode categorical data with one-hot encoding in scikit-learn, turning origin into binary columns (Americas, Europe, Asia) for regression modeling.
Learn to detect missing values, visualize a correlation matrix with Seaborn, and apply linear interpolation via SciPy interp1d to fill gaps in data.
Learn how to run correlation matrix analysis on data such as auto data, build the correlation matrix from selected columns, and visualize it with a seaborn heatmap using annotations.
Explore fundamentals of supervised versus unsupervised learning and parametric versus non-parametric models, then train and evaluate regression with a train and test split, using r squared and mean squared error.
split data into train and test sets, add an intercept, fit a regression model to predict mpg, and evaluate with root mean square error on the test set.
Transform select variables with numpy log, create a new dataset, and assess with scatter plots and ordinary least squares regression to improve R-squared and reduce root mean square error.
Explore polynomial regression in Python with polynomial features to compare linear and higher-degree fits on auto and horsepower data, using train-test splits and adjusted R-squared to avoid overfitting.
In this section you will see how to assess the goodness of your prediction by calculating the error between actual Y values and predicted Y. The smaller it is the better results you get.
In this course, we aim to provide you with a focused and efficient approach to preparing for data science tasks through practical questions. I understand that your time is valuable, so I have carefully curated the content to cut out any unnecessary noise and provide you with the most relevant materials.
First section of the course will prepare you for fundamentals of Python.
Moving beyond theory, the course will dive into a wide range of practical data science questions. These questions have been carefully selected to represent the types of problems frequently encountered in real-world data science roles. By practicing these questions, you will develop the skills and intuition necessary to tackle similar problems during interviews.
Throughout the course, we have filtered out any extraneous materials and focused solely on the core topics and questions that are most likely to come up in data science interviews. This approach will save you time and allow you to focus your efforts on what truly matters.
Index:
Missing values and how to handle them? (Python)
What are categorical variables and how to include them into model (Python)
What is a Correlation Matrix's role? (Python)
How to check relationship between variables? (Python)
How to interpret the regression analysis? (Python)
How to improve the regression model results with logarithmic transformation? (Python)
How to use polynomial model? (Python)
What is an overfitting? How to prevent it? (Theory)
Supervised vs Unsupervised Learning (Theory)
Parametric and Non-parametric model (Theory)