Bits of Data Science

This repository contains a collection of resources in the form of eBooks related to Data Science, Machine Learning, and similar topics. 📖 book @datascienceiot

Foundation of Computer Vision 📖 book @datascienceiot

Prompting guide 101 📚 book @datascienceiot

CALCULUS MADE EASY BY SILVANUS P. THOMPSON 📖 book @datascienceiot

Python Data Science Handbook 📖 book @datascienceiot

Machine Learning: The Basics 📓 Book @datascienceiot

Book of machine learning algorithms & concepts explained to simply, even a human can understand. 📓 Book @datascienceiot

ADVANCED CALCULUS 📓 Book @datascienceiot

Modern Data Science with R 2nd edition (plus light edits and updates) 📓 Book @datascienceiot

Probabilistic Programming & Bayesian Methods for Hackers 📓 Book @datascienceiot

Scientific Visualization: Python + Matplotlib 📓 Book @datascienceiot

Conditional probability 📚 Visual explanation @datascienceiot

PATTERNS, PREDICTIONS, AND ACTIONS A story about machine learning 📚 Book @datascienceiot

35 Most Common SQL Interview Questions 👇👇 1.) Explain order of execution of SQL. 2.) What is difference between where and having? 3.) What is the use of group by? 4.) Explain all types of joins in SQL? 5.) What are triggers in SQL? 6.) What is stored procedure in SQL 7.) Explain all types of window functions? (Mainly rank, row_num, dense_rank, lead & lag) 8.) What is difference between Delete and Truncate? 9.) What is difference between DML, DDL and DCL? 10.) What are aggregate function and when do we use them? explain with few example. 11.) Which is faster between CTE and Subquery? 12.) What are constraints and types of Constraints? 13.) Types of Keys? 14.) Different types of Operators ? 15.) Difference between Group By and Where? 16.) What are Views? 17.) What are different types of constraints? 18.) What is difference between varchar and nvarchar? 19.) Similar for char and nchar? 20.) What are index and their types? 21.) What is an index? Explain its different types. 22.) List the different types of relationships in SQL. 23.) Differentiate between UNION and UNION ALL. 24.) How many types of clauses in SQL? 25.) What is the difference between UNION and UNION ALL in SQL? 26.) What are the various types of relationships in SQL? 27.) Difference between Primary Key and Secondary Key? 28.) What is the difference between where and having? 29.) Find the second highest salary of an employee? 30.) Write retention query in SQL? 31.) Write year-on-year growth in SQL? 32.) Write a query for cummulative sum in SQL? 33.) Difference between Function and Store procedure ? 34.) Do we use variable in views? 35.) What are the limitations of views? Here you can find essential SQL Interview Resources👇 https://topmate.io/analyst/864764 Like this post if you need more 👍❤️ Hope it helps :)

Data Scientist Roadmap | |-- 1. Basic Foundations |   |-- a. Mathematics |   |   |-- i. Linear Algebra |   |   |-- ii. Calculus |   |   |-- iii. Probability |   |   -- iv. Statistics |   | |   |-- b. Programming |   |   |-- i. Python |   |   |   |-- 1. Syntax and Basic Concepts |   |   |   |-- 2. Data Structures |   |   |   |-- 3. Control Structures |   |   |   |-- 4. Functions |   |   |   -- 5. Object-Oriented Programming |   |   | |   |   -- ii. R (optional, based on preference) |   | |   |-- c. Data Manipulation |   |   |-- i. Numpy (Python) |   |   |-- ii. Pandas (Python) |   |   -- iii. Dplyr (R) |   | |   -- d. Data Visualization |       |-- i. Matplotlib (Python) |       |-- ii. Seaborn (Python) |       -- iii. ggplot2 (R) | |-- 2. Data Exploration and Preprocessing |   |-- a. Exploratory Data Analysis (EDA) |   |-- b. Feature Engineering |   |-- c. Data Cleaning |   |-- d. Handling Missing Data |   -- e. Data Scaling and Normalization | |-- 3. Machine Learning |   |-- a. Supervised Learning |   |   |-- i. Regression |   |   |   |-- 1. Linear Regression |   |   |   -- 2. Polynomial Regression |   |   | |   |   -- ii. Classification |   |       |-- 1. Logistic Regression |   |       |-- 2. k-Nearest Neighbors |   |       |-- 3. Support Vector Machines |   |       |-- 4. Decision Trees |   |       -- 5. Random Forest |   | |   |-- b. Unsupervised Learning |   |   |-- i. Clustering |   |   |   |-- 1. K-means |   |   |   |-- 2. DBSCAN |   |   |   -- 3. Hierarchical Clustering |   |   | |   |   -- ii. Dimensionality Reduction |   |       |-- 1. Principal Component Analysis (PCA) |   |       |-- 2. t-Distributed Stochastic Neighbor Embedding (t-SNE) |   |       -- 3. Linear Discriminant Analysis (LDA) |   | |   |-- c. Reinforcement Learning |   |-- d. Model Evaluation and Validation |   |   |-- i. Cross-validation |   |   |-- ii. Hyperparameter Tuning |   |   -- iii. Model Selection |   | |   -- e. ML Libraries and Frameworks |       |-- i. Scikit-learn (Python) |       |-- ii. TensorFlow (Python) |       |-- iii. Keras (Python) |       -- iv. PyTorch (Python) | |-- 4. Deep Learning |   |-- a. Neural Networks |   |   |-- i. Perceptron |   |   -- ii. Multi-Layer Perceptron |   | |   |-- b. Convolutional Neural Networks (CNNs) |   |   |-- i. Image Classification |   |   |-- ii. Object Detection |   |   -- iii. Image Segmentation |   | |   |-- c. Recurrent Neural Networks (RNNs) |   |   |-- i. Sequence-to-Sequence Models |   |   |-- ii. Text Classification |   |   -- iii. Sentiment Analysis |   | |   |-- d. Long Short-Term Memory (LSTM) and Gated Recurrent Units (GRU) |   |   |-- i. Time Series Forecasting |   |   -- ii. Language Modeling |   | |   -- e. Generative Adversarial Networks (GANs) |       |-- i. Image Synthesis |       |-- ii. Style Transfer |       -- iii. Data Augmentation | |-- 5. Big Data Technologies |   |-- a. Hadoop |   |   |-- i. HDFS |   |   -- ii. MapReduce |   | |   |-- b. Spark |   |   |-- i. RDDs |   |   |-- ii. DataFrames |   |   -- iii. MLlib |   | |   -- c. NoSQL Databases |       |-- i. MongoDB |       |-- ii. Cassandra |       |-- iii. HBase |       -- iv. Couchbase | |-- 6. Data Visualization and Reporting |   |-- a. Dashboarding Tools |   |   |-- i. Tableau |   |   |-- ii. Power BI |   |   |-- iii. Dash (Python) |   |   -- iv. Shiny (R) |   | |   |-- b. Storytelling with Data |   -- c. Effective Communication | |-- 7. Domain Knowledge and Soft Skills |   |-- a. Industry-specific Knowledge |   |-- b. Problem-solving |   |-- c. Communication Skills |   |-- d. Time Management |   -- e. Teamwork | -- 8. Staying Updated and Continuous Learning     |-- a. Online Courses     |-- b. Books and Research Papers     |-- c. Blogs and Podcasts     |-- d. Conferences and Workshops     `-- e. Networking and Community Engagement

The Flask Mega-Tutorial 📓 Book

12. ANOVA: Analyzes differences in means among multiple groups. It differs from regression by comparing means across groups instead of modeling relationships between variables. 13. Dealing with Missing Data: Techniques like mean, median, or mode imputation, or more advanced methods like multiple imputation or k-nearest neighbors imputation can be used. 14. Parametric vs. Non-parametric Tests: Parametric tests assume specific data distributions, while non-parametric tests do not. Parametric tests are more powerful but require data to meet certain assumptions. 15. Data Normalization and Standardization: Techniques to scale data to a common range or standardize it with mean 0 and standard deviation 1. Common methods include min-max scaling and z-score standardization. Like for more 😄