Quiz No.3: Master Pandas and EDA with Interactive Quiz - Codanics

Course Content

How and Why to Register

Dear, to register for the 6 months AI and Data Science Mentorship Program, click this link and fill the form give there: https://shorturl.at/fuMX6

0/2

Who is a Data Scientist?

Software installation and Important Details

In this section you will learn which software are important to install and learn from.

0/5

Software installation and websites for this course

Website introduction and opportunity to learn and earn for Free

Complete Installation of Softwares

Login to made for the course

Questions answered live on 26 09 2023

Day-1

Introduction and details about 6 months plan

0/5

Welcome and 6 months plan

Laptop buying guide for this course

LLMs’ websites and logins to learn prompt Engineering

VScode themes and extensions for Killer look

Questions and Answers Day-1

Day-2

What is AI and How is it Different From Data Science?

0/6

Artificial Intelligence Kya Hai?

AI vs Data Science vs ML vs DL

Big Players in AI

Benefits of AI in our Daily life

Registration Deadline for Paid Zoom Classes

Day-3

0/13

Data Science vs. AI

Data Science vs. Data Analytics

AI and Types of AI

Reading and Blogs for the course

Find jobs in AI and Data Science

Kia AI meri job khaye ge?

Ideas for AI Developers

Main Goals of this Course

Why should I learn Python to learn AI?

Software Installation to learn Python for AI and Data Science

Conda Environments for coding in Python

Python IDEs and VScode

Day-4

0/1

Start with Python

Day-5

Learn Python from Zero

0/5

Conda Environments (A-Z)

First Line of code in python

Variables in Python

Operator in python

Data Types in Python

Day-6

0/5

Indentations and if conditions in Python

User input program in python

Data structures and indexing in python

Control flow statements in python

Nested Loops in Python

Day-7

0/4

Functions & Lmbda funtions in Python

Modules and Libraries in Python

Types of Errors in Python

Jupyter Notebook and File Handling in Python

Day-8

Master Pandas Library

0/2

Mastering Pandas Library and EDA (Part-1)

Practice on Pandas before next lectures

Day-9

0/2

Quiz No.1: Pandas Basics

Mastering Pandas Library and EDA (Part-2)

Day-10

0/3

Quiz No.2: Exploratory Data Analysis (EDA)

Mastering Pandas Library and EDA (Part-3)

Learn MarkDown Language in 72 minutes

Day-11

0/1

Mastering Pandas Library and EDA (Part-4)

Day-12

0/1

Mastering Pandas Library and EDA (Part-5)

Day-13

0/2

Quiz No.3: Master Pandas and EDA with Interactive Quiz

Automatic EDA with ydata-profiling

Day-14

0/1

EDA on Google Play Store Data (Part-1)

Day-15

0/2

Exploratory Data Analysis q zaroori hy?

Missing Values ka rola kia hy?

Day-16

0/1

Mastering Pandas Library and EDA (Part-8)

Day-17: Complete EDA on Google PlayStore Apps

0/1

Complete EDA on Google Play Store Apps

Day-18: Outliers

0/6

What are outliers?

Types of Outliers

How to identify Outliers? Visual + IQR Methods

Z-score method for outliers detection

How to handle Outliers?

Outliers in one go (Quick Summary)

Day-19: Complete EDA project on Apple APP store apps Dataset

0/3

Use AI for Fast paced EDA

Big Datasets for EDA practice

Complete EDA on Apple APP store Data (A-Z)

Day-20

0/6

Pandas Python Library for EDA Analysis: A Comprehensive Guide

Exploratory Data Analysis (EDA) Kyun Zaroori Hai?

Missing values k Rolay

Day-21: Data Visualization-1

0/3

What is Data Visualization?

Types of Plots/Charts

Making plots/charts in Python

Day-22: Data Science Portfolio

0/6

What is a Data Science Portfolio?

Elements of a great Data Science Portfolio

Steps to Create Data Science Portfolio

What do recruiters look for in Data science jobs?

How this course will build your portfolio?

Polish your LinkedIn Profile for Data Science Jobs

Day-23: Data Visualization-2

0/2

Data Visualization in Python (Blog and Code)

Data Visualization in Python

Day-24: Data Visualization-3

0/3

Plotting with Seaborn in Python | Data Visualization

Plotly and Data Visualization for 2D and 3D Interactive plots

15 important plots to make with plotly in python

Day-25: Quiz Time, Data Visualization-4

0/1

Data Visualization Quiz

Day-26: Data Visualization-5

0/5

Sunburst plot in Python using plotly

Animated Plots in Python

GEO Maps in Python using plotly: Interactive and Animated maps

Saving Plotly Plots in gif files

Python plotly Visualization: A complete Beginner guide

Day-27: Data Scaling/Normalization/standardization and Encoding

0/2

Feature Scaling/Normalization

Feature Encoding

Day-28: NumPy (Part-1)

0/1

Introduction to numpy (a python Library)

Day-29: NumPy (Part-2)

0/1

Mastering Numpy with extended functions of arrays

Day-30: NumPy (Part-3)

0/1

NumPy indexing and slicing

Day-31: NumPy (Part-4)

0/1

Creating NumPy arrays from Data

Day-32a: NumPy (Part-5)

0/1

Matrices in NumPy python library

Day-32b: Data Preprocessing / Data Wrangling

0/1

Mastering the art of Data preprocessing

Day-33: Zero-to-Math for Data Science (Part-1)

0/4

What is Mathematics?

Branches of Mathematics

What did you learn Today?

Day-34: Zero-to-Math for Data Science (Part-2)

0/5

Number Theory in few words

Applications of Number theory

Pros of learning Number Theory and Mathematics

Factors and Multiples

Divisibility Rules in Math

Day-35: Zero-to-Math for Data Science (Part-3)

0/4

GCD and LCM in math

Modular Arithmetic

What is Modulus?

Numbers and their types in number theory

Day-36: Zero-to-Math for Data Science (Part-4)

0/6

What is Algebra?

Why Algebra is important to learn?

How to learn Algebra?

Types of Algebra

History of Algebra

Algebra and Data Science

Day-37: Algebra in Data Science

0/1

Algebra and Data Science (Reading Material)

Day-38: Pre-Algebra (Part-1)

0/3

Pre-Algebra: Basic to Advanced understanding

Basics of pre-algebra

Introduction to pre-algebra

Day-39: Pre-Algebra (Part-2)

0/4

Fractions and Decimals

Ratios and proportions

Percentages and Percent Calculations

Day-40: Pre-Algebra (Part-3)

0/5

Solving equations

Measurements, Units and Geometry

Data Analysis and Algebra

Problem solving in algebra

Exercise Questions for pre-algebra

Day-41: Elementary Algebra

0/2

Elementary Algebra

Important Tasks

Day-42: Linear Algebra (Part-1)

0/3

What is a vector?

What are Matrices?

Day-43: Linear Algebra (Part-2)

0/4

Linear Algebra Definitions

Cartesian coordinates Geometry and Linear Algebra

Scalars and Scaling a vector

Day-44: Linear Algebra (Part-3)

0/6

Vectors’ Addition

Vector span and Linear Dependence of vectors

x and y intercepts in linear algebra

Dot product of vectors

Cross product of two vectors

Day-45: Linear Algebra (Part-4)

0/8

Basis Vectors and Transformation

Linear Transformation and Matrices

Matrices are Linear Transformations

Shear Transformations

Why do we need transformations?

Matrix Multiplications as compositions

Matrices and Types (Part-1/2)

Matrices and Types (Part-2/2)

Day-46: Linear Algebra (Part-5)

0/5

Addition and Subtraction of matrices

Matrices Multiplication

Importance of Matrices Multiplication in Data Science and AI

Determinants of Matrices

Important Tasks

Day-47: Linear Algebra (part-6)

0/6

Inverse of a Matrix

System of Equations

Types of Linear Equations

Writing System of Equations

Matrix form of System of Equations

Assignment Alert

Day-48: Linear Algebra (Part-7)- Solving System of Equations

0/7

Solving system of equations

Graphical Method

Substitution Method

Elimination Method

Matrix inversion Method

Advance Methods

Assignment Alert

Day-49: Linear Algebra (Part-8)- Solving System of Equations

0/5

Advance Methods to solve system of equations

Gaussian Elimination Method

Gauss-Jordan Elimination Method

LU Decomposition Method

Singular Value Decomposition (SVD)

Day-50: Linear Algebra (Part-9)- Solving System of Equations

0/4

Row Operations Permissible vs. non-permissible

Eigenvalues and Eigenvectors

Important Tasks before upcoming lectures

Day-51: Linear Algebra (Part-10) – Python

0/12

Linear Algebra Articles

Solving System of Equations in python

Solve system of complex equations in python

Vectors in Python

Linear Transformation in python

Shear Transformation in python

singular value decompositions (SVD) in python

Linear Algebra-Notes

Vectors in Linear Algebra-Notes

Linear Transformation-Notes

Statistics is next

Day-52: Statistics for Data Science (Part-1)

0/9

What is Statistics?

What will we learn?

Why statistics is important?

Scales or Levels of Measurements

Qualitative vs. Quantitative Data

Discrete vs. Continuous vs. Binary Data

What is Time Series Data?

What is spatial Data?

Day-53: Statistics for Data Science (Part-2)

0/5

Categorical vs. Ordinal Categorical Data

Multivariate Data Type

Structured vs. Unstructured Data

Boolean Data Type

Operationalization and Proxy Measurements

Day-54: Statistics for Data Science (Part-3)

0/8

Surrogate Endpoints in statistics

True and Error Score

Types of Errors in Data Collection

Type-I and Type-II errors

Examples from the Audience for Type I and Type II errors

Reliability and validity

Notes of All lectures on ABC of statistics for Data Science

Day-55: Statistics for Data Science (Part-4)

0/6

Measurement and Data Bias

How to remove bias?

Statistics and types of Statistics

Why is statistics important to learn?

Data Analysis and Types of Data Analysis

Next Tasks to Learn: Sample and Population

Day-56: Statistics for Data Science (Part-5)

0/1

Central Tendency: Mean, Median, and Mode

Day-57: Statistics for Data Science (Part-6)

0/8

Central Tendency of the Data Complete Guide

Hormonic Mean understanding of the formula

Limitations of using mean in Data Science and statistics

Median in statistics

Mode in Statistics

Population vs. sample and their means

Variability | Dispersion | Spread of the Data

Day-58: Statistics for Data Science (Part-7)

0/5

Inter quartile Range (IQR)

Standard Deviation and Standard Error

Normal distribution and Standard Deviation

Day-59: Statistics for Data Science (Part-8)

0/2

Data Distributions and types of data distributions

Skewness and Kurtosis

Day-60: Statistics for Data Science (Part-9)

0/2

Primary vs. Secondary | Data

Next Tasks for upcoming lectures on sampling

Day-61: Statistics for Data Science (Part-10)

0/5

Data Collection in the age of big data

Best Practices for Data Collection

Representative and Non-representative sample types

Details of each Sampling Techniques for Data Collection

Hybrid Sampling

Day-62: Statistics for Data Science (Part-11)

0/4

Descriptive Statistics

EDA and Statistics

How to choose the right statistical method?

EDA and the Four Pillars of statistics

Day-63: Statistics for Data Science (Part-12)

0/4

Dependent vs. independent variables

Inferential Statistics

Hypothesis Testing

Confidence Interval in statistics

Day-64: Statistics for Data Science (Part-13)

0/6

Chi-Square Test in Python

Next Statistical tests

Test for Normal Distribution Shapiro-Wilk Test in Python

t-tests in Python

Levene’s test in Python

One-way ANOVA in python

Day-65: Statistics for Data Science (Part-14)

0/3

ANOVA | one-way, 2-way and N-way in Python

MANOVA in python

Correlation in Python

Day-66: Statistics for Data Science (Part-15)

0/6

Chi-squared test case study in python

t-test and case studies in python

One-way and Two-way ANOVA case studies

Correlation | Pearson’s and Spearman’s | Case studies in python

EDA and basic Pillars of Statistics

Book announcement for Statistics ABC of statistics

Day-67: Machine Learning (Part-1)

0/2

What is machine learning?

Types of Machine Learning

Day-68: Machine Learning (Part-2)

0/6

ML Model Building to Deployment | Steps A-Z

What is an algorithm?

Training and Testing Data | Features and Labels | Model

Overfitting vs. Underfitting

Important Python libraries for Machine Learning

Installation steps

Day-69: Machine Learning (Part-3)

0/1

Data Pre-processing before ML Model

Day-70: Machine Learning (Part-4)

0/2

Steps in Data Pre-processing

Dealing with Missing values in Python

Day-71: Machine Learning (Part-5)

0/3

Dealing with Data Inconsistencies / Anomalies

Outliers | Data Pre-processing

IQR Method to remove Outliers

Day-72: Machine Learning (Part-6)

0/5

Data concatenation

Data Preprocessing Steps

Feature Scaling and Normalization

Standard Scaling or standardizing the data

Day-73: Machine Learning (Part-7)

0/7

Min-max, MaxAbs, and Robust Scalars in python

Most used Scaling methods for feature scaling

Normalization and Nonlinear Data Transformation of data

L2 and L1 Normalization in python

Feature Scaling vs. Normalization

Tips about Scaling and normalization

Assignment Alert

Day-74: Machine Learning (Part-8)

0/7

What is feature encoding?

Benefits of feature encoding

Feature Encoding in Python using scikit-learn

Feature-encoding with pandas python

Data Discretization | Data Binning

Data preprocessing steps completed

Scikit-learn base Jupyter notebook

Day-75: Machine Learning (Part-9)

0/1

Linear Regression A-Z

Day-76: Machine Learning (Part-10)

0/3

Logistic Regression (Theory)

Logistic Regression and example in Python A-Z

Evaluation Metrics for Regression & Classification Models

Day-77: Machine Learning (Part-11)

0/5

Train test split matters

Support Vector Machines (SVM) Theory

Support Vector Machines (SVM) in Python

Assignment Alert about SVM

Upload Notebooks on Kaggle

Day-78: Machine Learning (Part-12)

0/7

K-Nearest Neighbors (KNN) Theory

Euclidean Distance

Manhattan Distance

Minkowski Distance

Why Minkowski Distance is Important?

Hamming Distance

K-Nearest Neighbors (KNN) in Python

Day-79: Machine Learning (Part-13) Decision Tree

0/6

Algorithms we have learned so far

What is Decision tree Algorithm?

Elements of Decision Tree

Entropy, Gini impurity and information gain theory

Entropy, Gini impurity and information gain in python

Decision Tree Classifier in Python

Day-80: Machine Learning (Part-14)-Ensemble Algorithms

0/3

Ensemble Algorithms

Random Forest (Theory)

Random Forest in Python for Classification and Regression

Day-81: Machine Learning (Part-15)-Evaluation Metrics

0/2

Evaluation Metrics in Machine Learning

Regression Metrics

Day-82: Machine Learning (Part-16)-Metrics for Classification

0/1

Evaluation Metrics for Classification Algorithms

Day-83: Machine Learning (Part-17)

0/2

Ensemble Algorithms Family

Boosting in Ensemble Methods

Day-84: Machine Learning (Part-18)

0/3

Boosting algorithms and their pros. and cons.

Booting algorithms vs. Neural Networks

xgBoost vs. Random forest vs. Decision Tree | in python

Day-85: Machine Learning (Part-19)

0/1

catBoost algorithm in Python

Day-86: Machine Learning (Part-20)

0/3

Hyperparameter Tuning and Cross Validation

Cross Validation in machine learning (Part-1)

Cross Validation in machine learning (Part-2)

Day-87: Machine Learning (Part-21)

0/2

pipeline in Machine Learning using Scikit-learn

Best Model Selection in Python using Scikit-learn

Day-88: Machine Learning (Part-22)

0/4

Naive Bayes Algorithm (Part-1)

Types of Naive Bayes Algorithm | NB (Part-2)

NAIVE Bayes in Python | Naive Bayes Algorithm (Part-3)

Questions and Answers | Naive Bayes Algorithm (Part-4)

Day-89: Machine Learning (Part-23)

0/1

Best hyperparameter tuned Model Selection

Day-90: Machine Learning (Part-24)

0/3

How to select the best model (Presentation-1) and Feedback

How to select the best model (Presentation-2) and Feedback

Question and Answers session on 90th day of this course

Day-91: Machine Learning (Part-25)

0/1

Encoding and Inverse Transform the data

Day-92: Machine Learning (Part-26)

0/4

Basic Method | Missing Values Imputation (Part-1)

Machine Learning models | Missing Values Imputation (Part-2)

Advance Methods | Missing Values Imputation (Part-3)

Last lecture of 2023 for AI and Data Science

Day-93: Machine Learning (Part-27)

0/1

Supervised Machine Learning and Assumptions

Day-94: Machine Learning (Part-28)

0/2

Mathematics and Assumptions of Linear Regression

Multilinear Regression and Mathematics with Assumptions

Day-95: Machine Learning (Part-29)

0/2

Polynomial Regression Theory and Assumptions

Polynomial Regression in Python with coding

Day-96: Machine Learning (Part-30)

0/2

Ridge Regression in Python L2 Regularization

Lasso Regression | L1 Regularization

Day-97: Machine Learning (Part-31)

0/3

Heart Disease prediction | A complete ML Project (Part-1)

Heart Disease prediction | A complete ML Project (Part-2)

Heart Disease prediction | A complete ML Project (Part-3)

Day-98: Machine Learning (Part-32)

0/2

Heart Disease prediction | A complete ML Project (Part-4)

Heart Disease prediction | A complete ML Project (Part-5)

Day-99: Machine Learning (Part-33)

0/2

Heart Disease prediction | A complete ML Project (Part-6)

Heart Disease prediction | A complete ML Project (Part-7)

Day-100: Un-Supervised Machine Learning (Part-1)

0/4

Un-supervised Machine Learning – Introduction

What is Clustering?

k-Means clustering – Theory

k-Mean clustering in python

Day-101: Un-Supervised Machine Learning (Part-2)

0/6

Hierarchical Clustering | Theory

Hierarchical Clustering | Coding in python

Gaussian Mixture Models (GMMs) | Theory

Gaussian Mixture Models (GMMs) | Metrics

Day-102: Un-Supervised Machine Learning (Part-3)

0/6

Feature Engineering (Part-1)

Feature Engineering (Part-2)

PCA | Principal Component Analysis | Theory

PCA | Principal Component Analysis | Case Study in Python

SVD | Singular Value Decomposition

t-SNE | t-distributed Stochastic Neighbor Embedding

Day-103: Deep Learning (Part-1)

0/3

Introduction to Deep Learning

Machine Learning vs. Deep Learning

Small Data vs. Big Data for Deep Learning

Day-104: Deep Learning (Part-2)

0/2

What is a Neural Network?

Types of Neural Network

Day-105: Deep Learning (Part-3)

0/2

Architecture of Neural Networks

Single Layer vs. Multilayer Neural Network

Day-106: Deep Learning (Part-4)

0/3

Multi Layer Perceptron

Types of Multi Layer Perceptron

Applications of Multi layer perceptron

Day-107: Deep Learning (Part-5)

0/3

Python Libraries for Deep Learning

Ten steps to create a neural Network

Build Neural Networks in Python with TensorFlow

Day-108: Deep Learning (Part-6)

0/2

GPU for Deep Learning with TensorFlow

Build a Multilayer Perceptron in Python with TensorFlow

Day-109: Deep Learning (Part-7)

0/2

Call Back Function for Early Stopping of epochs

How many neurons should be in each layer?

Day-110: Deep Learning (Part-8)-Activation Functions

0/4

Activation functions in Neural Network | Linear vs. Step vs. Sigmoid

tanH, ReLu, Leaky Relu, Paramteric ReLu activation functions

Softmax activation function | Multiclass classification

How to choose an activation function for neural network?

Day-111: Case Studies (Complete Machine/Deep Learning Projects)

0/5

Case Study on UCI Heart Disease Data Project 1

Case Study on UCI Heart Disease Data Project 2

Case Study on UCI Heart Disease Data Project 3

Case Study on UCI Heart Disease Data Project 4

Competitions and Assignments for the course

Day-112: Deep Learning (Part-9)-Complete Project

0/2

Case Study for Kaggle Competition-(Complete Deep Learning Project)

What is random seeding or Random State in ML?

Day-113: Deep Learning (Part-10)-Complete Project

0/3

Case Study on Bank Churn Dataset

Important Assignment for Kaggle Competitions

Announcement about the AI Job Ready Course on Codanics

Day-114: Deep Learning (Part-11)-Convolutional Neural Network (CNN)

0/3

Convolutional Neural Network (CNN) | Part-1

Convolutional Neural Network (CNN) | Part-2

Convolutional Neural Network (CNN) | Part-3

Day-115: Deep Learning (Part-12)-Convolutional Neural Network (CNN)

0/3

Convolutional Neural Network (CNN) | Part-4

Convolutional Neural Network (CNN) | Part-5

Convolutional Neural Network (CNN) | Part-6

Day-116: Deep Learning (Part-13)-Computer Vision

0/3

What is Computer Vision?

Python & Computer vision

Assignment alert

Day-117: Deep Learning (Part-14)-Complete CNN Project

0/1

Paddy Rice Disease Detection Project

Day-118: Deep Learning (Part-15)-Recurrent Neural Network (RNN)

0/3

Introduction to RNN

RNN In depth Understanding

RNN and Python for Project making

Day-119: Deep Learning (Part-16)-Natural Language Processing (NLP)

0/2

Introduction to Natural Language Processing

Sentiment Analysis and NLP

Day-120: Deep Learning (Part-17)-Natural Language Processing (NLP)

0/3

LSTM (Long Short Term Memory) for NLP

History of ANN, CNN, RNN, LSTM, GRU

LSTM vs. GRU types of RNN for Deep learning in NLP

Day-121: Time Series Analysis (Part-1)

0/1

Introduction to Time Series Analaysis

Day-122: Time Series Analysis (Part-2)

0/3

Data Analysis Types for Time Series Data

Types of Data about Time

Time series analysis and plotting in python

Day-123: Time Series Analysis (Part-3)

0/1

Time Series Project understanding and development

Day-124: Time Series Analysis (Part-4)

0/3

Time series Weather forecasting project (Part-1)

Time series Weather forecasting project (Part-2)

Time series Weather forecasting project (Part-2)

Day-125: Time Series Analysis (Part-5)

0/2

prophet model from FB (meta) for time series analysis (1/2)

prophet model from FB (meta) for time series analysis (1/2)

Day-126: Time Series Analysis (Part-6): Web-scrapping

0/3

What is web scrapping?

Web scrapping in python

Stock market data scrapping in python

Day-127: Time Series Analysis (Part-7): ARIMA models for time series

0/3

ARIMA (Time series analysis) in python (Part-1)

ARIMA (Time series analysis) in python (Part-2)

ARIMA (Time series analysis) in python (Part-3)

Day-128: Time Series Analysis (Part-8): Complete Project

0/1

ARIMA, SARIMA, SARIMAX in python complete project

Day-129: git & GitHub Crash Course

0/1

git and GitHub crash course

Day-130: Over-fitting and Under-fitting in a Model

0/3

Underfitting in a Machine/Deep Learning Model

Overfitting in a Machine/Deep Learning Model

Good Fit or Robust Model in Machine/Deep Learning

Day-131: Improving Machine/Deep Learning Model’s Performance

0/2

How to Improve Model’s Fitness?

Project Based Improving Model’s Fitness

Day-132: Transfer Learning and Pre-trained Models (Part-1)

0/3

Introduction to Transfer learning

Transfer Learning in Python using TensorFlow

Assignment Alert for Transfer Learning

Day-133: Transfer Learning and Pre-trained Models (Part-2)

0/1

Use of TensorFlow for Image Classification – A complete Project

Day-134 Transfer Learning and Pre-trained Models (Part-3)

0/1

MobileNetV2 pre-trained Mode: A complete Project

Day-135: Generative AI (Part-1)

0/2

What is Generative AI?

Important Key Terms used in Generative AI

Day-136: Generative AI (Part-2)

0/2

How does Generative AI work?

Generative AI in 2024

Day-137: Generative AI (Part-3)

0/1

Generative AI | Kia meri job kha jaye ge?

Day-138: Generative AI (Part-4)

0/2

Progressive growing Generative Adversarial Networks (GANs)

Assignment Alert

Day-139: Generative AI (Part-5)-Tensorboard

0/1

TensorBoard: a crash course

Day-140: Generative AI (Part-6)-Diffusion Models

0/2

Introduction to Diffusion Models

Stable Diffusion Models in python

Day-141: Generative AI (Part-7)

0/2

SORA: An openAI’s model for AI video generation

Important Logins to create before next lecture

Day-142: Prompt Engineering

0/5

Introduction to prompt Engineering

Types of Prompt Enginnering

Prompt Designing Strategies to write best prompt

Generate Prompts from LLMs

LLMs and prompt engineering live demo

Day-143: Huggingface

0/1

Use pre trained models from Huggingface

Day-144: LangChain and APIs

0/4

Introduction to API (Application Programming Interface)

LangChain workflow for LLMs

Applications of LangChain for LLMs

LangChain + OpenAI API + HuggingFace API

Day-145: Streamlit for webapp development and deployment (Part-1)

0/3

Introduction and installation

My first app in streamlit

streamlit cheat sheet

Day-146: Streamlit for webapp development and deployment (Part-2)

0/1

Streamlit Data Science application

Day-147: Streamlit for webapp development and deployment (Part-3)

0/1

Streamlit webapp without coding but prompting

Day-148: Streamlit for webapp development and deployment (Part-4)

0/2

Creating a word Cloud app on streamlit python

requirements.txt file for streamlit apps

Day-149: Streamlit for webapp development and deployment (Part-5)

0/1

Streamlit app deployment on free servers

Day-150: Streamlit for webapp development and deployment (Part-6)

0/1

Create an app only in 14 lines of codes

Day-151: Streamlit for webapp development and deployment (Part-7)

0/1

Manage Secrets in streamlit deployment with python

Day-152: Streamlit for webapp development and deployment (Part-8)

0/1

ask the pdf and other docx application

Day-153: Streamlit for webapp development and deployment (Part-9)

0/1

Streamlit project read pdfs in a folder

Day-154: Streamlit for webapp development and deployment (Part-10)

0/1

Stock Market Analysis and Prediction app

Day-155: Streamlit for webapp development and deployment (Part-11)

0/1

Dall-e-3 Image generation app in python

Day-156: Streamlit for webapp development and deployment (Part-12)

0/1

Speech to text Streamlit Application development

Day-157: Streamlit for webapp development and deployment (Part-13)

0/1

Text to speech Streamlit application

How to Earn using Data Science and AI skills

0/1

How to earn online using Data Science and AI

Day-158: Flask for web app development (Part-1)

0/2

is FLASK better than streamlit?

Installation and basics of web app development in flask

Day-159: Flask for web app development (Part-2)

0/5

flask Installation and basic application development

Open Conda environments inside vscode

Flask app for basic EDA and plotting

Image Generation app development in flask python

Day-160: Flask for web app development (Part-3)

0/1

End to End machine Learning project in flask | house price prediction

Day-161: Flask for web app development (Part-4)

0/1

End to End machine Learning project in flask | Tip prediction

Day-162: Flask for web app development (Part-5)

0/1

Diabetes prediction app development

Day-163: Flask for web app development (Part-6)

0/1

Text to speech web app development

Day-164: Flask for web app development (Part-7)

0/2

WordCloud app development

Speech to text app using openAI API

Day-165: Flask for web app deployment (Part-8)

0/1

Web application deployment on Amazon AWS EC2 Instance

Day-166: FastAPI (Part-1)

0/2

Intro to FastAPI | is FastAPI really fast?

Installing FastAPI using conda

Day-167: FastAPI (Part-2)

0/1

Book Store app in FastAPI in python

Day-168: FastAPI (Part-3)

0/1

FastAPI basics and running server

Day-169: FastAPI (Part-4)

0/1

Swagger docs in FastAPI

Day-170: FastAPI (Part-5)

0/1

Path parameters in FastAPI

Day-171: FastAPI (Part-6)

0/1

Users path parameters in FastAPI

Day-172: FastAPI (Part-7)

0/1

Titanic app backend development with FastAPI

Day-173: FastAPI (Part-8)

0/2

Add static plots to FastAPI app

Add interactive plots in FastAPI app using plotly

Day-174: FastAPI (Part-9)

0/1

Different port numbers for FastAPI

Day-175: Tableau Complete Course (Part-1)

0/8

What is Tableau?

Tableau Learning Resources

Tableau Public Installation Free

How Tableau Public Looks Like? Interface

Load Data in Tableau Public

Load and handle Dataset in Tableau Public

Data Types check in Tableau Public

Data Filtering and sorting in Tableau Public

Day-176: Tableau Complete Course (Part-2)

0/6

Data Visualization in Tableau Public

Scatter Plots in Tableau Public

Dynamic Scatter Plot in Tableau Public

Flip your charts in tableau public

Bar plots and sorting in Tableau public

GEO Maps in Tableau public

Day-177: Tableau Complete Course (Part-3)

0/2

Your Own Project Visualization in Tableau Public

Saving your plots with Tableau Public

Day-178: Tableau Complete Course (Part-4)

0/4

Area Charts in Tableau Public

Group charts in Tableau

Tableau Interactive Dashboard Development

Tableau Dashboard Deployment for Community

Day-179: Power BI (Part-1)

0/3

Introduction to Data Visualization and Power BI

Power BI vs. Tableau vs. Python?

Top 11 benefits of using Power BI

Day-180: Power BI (Part-2)

0/3

Install Power BI Desktop

Update Power BI features and Updates

Learning Resources for Power BI

Day-181: Power BI (Part-3)

0/4

Business Intelligence with Power BI

Seven Steps Workflow to use Power BI

Power BI interface and Features

Connect Data in Power BI

Day-182: Power BI (Part-4)

0/4

Data Visualization and Plotting in Power BI

Column/Bar charts in Power BI

Create a bar plot like a professional

Pro tips to make a stunning plot in Power BI

Day-183: Power BI (Part-5)

0/4

Pie Charts in power BI

Donut Charts in Power BI

Tree Map in Power BI

Line Chats in Power BI

Day-184: Structured Querry Language (SQL) for Beginners

0/16

Install MySQL on Windows 10

Create a MySQL Database for Beginners

Create/modify tables in mySQL

DISTINCT function in mySQL

Constraints in mySQL

Auto increment in mySQL

mySQL workbench first look and interface

Import mySQL database in mySQL workbench

Pandas processing on mySQL database

SELECT clause in mySQL

Data Manupulation in mySQL

WHERE clause and comparison operators

AND OR NOT and IN

BETWEEN clause in mySQL

Six months of AI and Data Science Mentorship Program

0%

1414

You have to finish 50 questions in 17 minutes

Created by

Dr. Aammar Tufail

How good am I using Pandas for EDA analysis

How good am I in using pandas for Exploratory Data Analysis (EDA)?

Have you already practice pandas library of Python for Doing EDA analysis?

If yes, then this quiz is for you. Attempt and get 80% marks to pass the quiz.

The number of attempts remaining is 3

1 / 50

Which method is used to compute pairwise correlation of columns excluding NA/null values?

A) df.column_corr()

B) df.pair_corr()

C) df.corr()

D) df.compute_corr()

2 / 50

How do you change the data type of a column in pandas?

A) df['column'].astype('new_type')

B) df['column'].change_type('new_type')

C) df['column'].type('new_type')

D) df['column'].convert('new_type')

3 / 50

What is the purpose of the melt function in pandas?

A) To drop values from a DataFrame

B) To unpivot a DataFrame from wide format to long format

C) To pivot a DataFrame from long format to wide format

D) To sort a DataFrame

4 / 50

How do you set the title of a box plot created using pandas?

A) caption='Title'

B) title='Title'

C) label='Title'

D) heading='Title'

5 / 50

Which method is used to round a DataFrame to a variable number of decimal places?

A) df.float()

B) df.decimal()

C) df.precision()

D) df.round()

6 / 50

What is the method to drop duplicate rows from a DataFrame?

A) df.delete_duplicates()

B) df.remove_duplicates()

C) df.unique_rows()

D) df.drop_duplicates()

7 / 50

How do you save a plot created using pandas to a file?

A) df.saveplot('filename.png')

B) plt.savefig('filename.png')

C) df.export('filename.png')

D) df.save('filename.png')

8 / 50

Which method is used to drop a specific column from a DataFrame?

A) df.remove('column_name')

B) df.drop(columns='column_name')

C) df.drop_column('column_name')

D) df.delete('column_name')

9 / 50

What is the purpose of the pivot_table method in pandas?

A) To create a spreadsheet-style pivot table as a DataFrame

B) To drop values from a DataFrame

C) To sort a DataFrame

D) To plot a DataFrame

10 / 50

How would you filter rows in a DataFrame based on a condition?

A) df.filter('column_name' > value)

B) df[df['column_name'] > value]

C) df.condition('column_name' > value)

D) df.query('column_name' > value)

11 / 50

What is the method to get a random sample of rows from a DataFrame?

A) df.sample(n)

B) df.get_sample(n)

C) df.random(n)

D) df.select_random(n)

12 / 50

How would you convert a pandas DataFrame to a NumPy array?

A) df.array()

B) df.to_numpy()

C) df.numpy()

D) df.to_array()

13 / 50

Which parameter would you use with df.plot(kind='box') to plot by a particular column?

A) using='column'

B) by='column'

C) column='column'

D) with='column'

14 / 50

How would you get the sum of values for each column?

A) df.total()

B) df.sum()

C) df.aggregate()

D) df.addition()

15 / 50

Which pandas function would you use to create a histogram?

A) df['column'].plot(kind='hist')

B) df['column'].histogram()

C) df['column'].create_hist()

D) df['column'].plot_histogram()

16 / 50

Which method is used to concatenate two DataFrames?

A) df1.concat(df2)

B) df1.join(df2)

C) df1.merge(df2)

D) pandas.concat([df1 df2])

17 / 50

What is the primary use of a box plot in data analysis?

A) To upload data to a database

B) To create databases

C) To fill missing values

D) To visualize the distribution and identify outliers

18 / 50

Which method is used to return the first n rows of a DataFrame?

A) df.first(n)

B) df.top(n)

C) df.begin(n)

D) df.head(n)

19 / 50

Why is it important to tackle null values in a dataset during data analysis?

A) Null values increase data accuracy

B) Null values can distort statistical analysis and machine learning models

C) Null values improve data quality

D) Null values are required for data visualization

20 / 50

Which method is used to merge two DataFrames based on a common column?

A) pandas.concat([df1 df2] on='common_column')

B) pandas.merge(df1 df2 on='common_column')

C) df1.concat(df2 on='common_column')

D) df1.join(df2 on='common_column')

21 / 50

How would you count the number of unique values in a column?

A) df['column'].unique_count()

B) df['column'].distinct()

C) df['column'].count_unique()

D) df['column'].nunique()

22 / 50

What is the method to get the data types of each column in a DataFrame?

A) df.types()

B) df.get_types()

C) df.dtypes

D) df.columns_types()

23 / 50

How do you convert a series of date-strings to a pandas datetime object?

A) pandas.to_datetime(Series)

B) pandas.str_to_date(Series)

C) pandas.convert_to_datetime(Series)

D) pandas.date_convert(Series)

24 / 50

How do you set a pandas option to display a maximum of 10 rows?

A) pandas.set('max_rows' 10)

B) pandas.option('max_rows' 10)

C) pandas.display('max_rows' 10)

D) pandas.set_option('display.max_rows' 10)

25 / 50

How would you create a correlation matrix in pandas?

A) df.corr_matrix()

B) df.corr()

C) df.correlation()

D) df.correlate()

26 / 50

How would you create a box plot for every column in a DataFrame using pandas?

A) df.create_boxplot()

B) df.plot.box()

C) df.boxplot()

D) df.plot(kind='box')

27 / 50

Which method is used to reset the index of a DataFrame?

A) df.new_index()

B) df.index_reset()

C) df.set_index()

D) df.reset_index()

28 / 50

How would you read a CSV file in pandas?

A) pandas.open_csv('file.csv')

B) pandas.load_csv('file.csv')

C) pandas.read_csv('file.csv')

D) pandas.get_csv('file.csv')

29 / 50

Which method is used to drop rows with missing values in pandas?

A) df.dropna()

B) df.remove_na()

C) df.delete_na()

D) df.drop_null()

30 / 50

How would you create a box plot for a specific column using pandas?

A) df['column'].boxplot()

B) df['column'].plot(kind='box')

C) df['column'].create_boxplot()

D) df['column'].plot.box()

31 / 50

How do you fill missing values with a specific value in a DataFrame?

A) df.missing_fill(value)

B) df.replace_na(value)

C) df.fillna(value)

D) df.null_fill(value)

32 / 50

Which method is used to compute descriptive statistics of a DataFrame?

A) df.statistics()

B) df.info()

C) df.summary()

D) df.describe()

33 / 50

How do you perform data normalization in pandas?

A) df.norm()

B) df.normalize()

C) df.standardize()

D) (df - df.min()) / (df.max() - df.min())

34 / 50

Which method is used to sort the index of a pandas DataFrame?

A) df.order()

B) df.sort_index()

C) df.sort()

D) df.arrange()

35 / 50

How do you set the index of a DataFrame?

A) df.set_index('column_name')

B) df.set_index_column('column_name')

C) df.index('column_name')

D) df.index_set('column_name')

36 / 50

Which pandas method is used to calculate pairwise covariance of columns?

A) df.cov()

B) df.cov_matrix()

C) df.covariance()

D) df.pair_cov()

37 / 50

How would you rename a column in a DataFrame?

A) df.change_name('old_name' 'new_name')

B) df.column_rename('old_name' 'new_name')

C) df.rename_column('old_name' 'new_name')

D) df.rename(columns={'old_name':'new_name'})

38 / 50

What is the purpose of the cut function in pandas?

A) To cut strings

B) To cut missing values

C) To slice data frames

D) To bin values into discrete intervals

39 / 50

How do you select rows in a DataFrame based on index labels?

A) df.iloc[labels]

B) df.loc[labels]

C) df.get[labels]

D) df.select[labels]

40 / 50

Which function is used to replace values given in to_replace with value?

A) df.replace(to_replace value)

B) df.change(to_replace value)

C) df.substitute(to_replace value)

D) df.swap(to_replace value)

41 / 50

Which method is used to reshape a DataFrame using a melt operation?

A) pandas.melt(df)

B) df.reshape_melt()

C) df.melt()

D) df.melt_reshape()

42 / 50

What is the method to calculate the mean of each column in a DataFrame?

A) df.median()

B) df.average()

C) df.mean()

D) df.calculate_mean()

43 / 50

Which method is used to compute a simple cross-tabulation of two (or more) factors?

A) pandas.tabulate()

B) pandas.table()

C) pandas.crosstab()

D) pandas.cross_table()

44 / 50

How do you select a specific column from a DataFrame?

A) df.get('column_name')

B) df.column('column_name')

C) df.select('column_name')

D) df['column_name']

45 / 50

What is the purpose of the groupby method in pandas?

A) To plot data based on a key

B) To drop data based on a key

C) To sort data based on a key

D) To group data based on one or more keys

46 / 50

What is the method to display the first 5 rows of a DataFrame?

A) df.display()

B) df.first()

C) df.head()

D) df.show()

47 / 50

How do you check for missing values in a DataFrame?

A) df.isnull()

B) df.null()

C) df.empty()

D) df.missing()

48 / 50

Which method in pandas is used to write DataFrame to a comma-separated values (csv) file?

A) df.save_csv('file_path')

B) df.csv('file_path')

C) df.write_csv('file_path')

D) df.to_csv('file_path')

49 / 50

Which method is used to get the statistical summary of a DataFrame?

A) df.describe()

B) df.summary()

C) df.info()

D) df.statistics()

50 / 50

Which method is used to sort a DataFrame based on a specific column?

A) df.sort('column_name')

B) df.sort_values(by='column_name')

C) df.order('column_name')

D) df.arrange('column_name')

Your score is

LinkedIn Facebook Twitter VKontakte

0%

See review

About Lesson

Master Pandas and Exploratory Data Analysis (EDA) Through Our Interactive Quiz

0% Complete