MINDMAP Basic Python and SQL for Data Science

 The basics of python and SQL are the first and the main ones we have to learn.

For Python, I used    GREAT LEARNING PYHTON COURSE FREE


This course just covers all the fundamental topics to understand python.


For SQL you can choose free courses like these or many are available on youtube as well.



Mind map to study basic python for data science

   

              

         BASIC CONCEPTS

              |

     Variables and Data Types

              |

          Operators

              |

            Lists

              |

          Dictionaries

              |

            Tuples

              |

           Strings

              |

     CONTROL STRUCTURES

              |

           Conditionals

              |

             Loops

              |

           Functions

              |

           Libraries

              |

        NUMPY AND PANDAS

              |

              NumPy

              |

             Pandas

         

NOTE: Here we didn't cover more libraries such as matplotlib &seaborrn which we will cover in Exploratory data analysis (EDA).



Mind map to study basic SQL

           
                
        DATA MANIPULATION
                |
            SELECT 
                |
           FROM/JOIN
                |
           WHERE/AND/OR
                |
            GROUP BY
                |
            HAVING
                |
            ORDER BY
                |
            LIMIT/OFFSET
                |
         DATA DEFINITION
                |
            CREATE TABLE
                |
           ALTER TABLE
                |
           DROP TABLE
                |
           CONSTRAINTS
                |
         DATA CONTROL
                |
           INSERT INTO
                |
           UPDATE
                |
           DELETE FROM

Comments

Post a Comment

Popular posts from this blog

EDA preprocessing using MYSQL steps

EDA Preprocessing in MySQL: Connect to the MySQL database. Retrieve the dataset or table to be analyzed. Handle missing values: Identify columns with missing values. Decide on a strategy to handle missing values (e.g., removing rows, imputation). Implement the chosen strategy to fill or remove missing values. Handle duplicate values: Identify duplicate rows or columns. Decide on a strategy to handle duplicates (e.g., removing duplicates, keeping the first or last occurrence). Implement the chosen strategy to remove or modify duplicate values. Handle outliers: Identify columns with outliers. Decide on an approach to handle outliers (e.g., removing outliers, transforming values). Implement the chosen approach to handle outliers. Perform data type conversion and normalization: Convert columns to the appropriate data types (e.g., dates to datetime, numbers to numeric types). Normalize numerical columns if required (e.g., scaling to a specific range). Handle categorical variables: Identify ...
Read more

Mindmap for studying Fundamentals of Mathematics in Data Science

Image
  Here's a mind map outlining the fundamentals of mathematics in data science Fundamentals of Mathematics in Data Science ──────────── │ Math Basics │ ──────────── │ ┌──────────────┴──────────────┐ Statistics Linear Algebra │ │ ┌──────────┴──────────┐ ┌─────────┴─────────┐ Descriptive Statistics │ Matrix Opera t ions │ │ │ │ │ │ Mean, Median, Mode │ Eigenvalues, Eigenvectors Variance, Standard │ Determinants, Inverses Deviation │ Matrix Multiplication │ Matrix Transposition │ Dot Products ┌──────────────┴──────────────┐ Calculus Probability ┌──────...
Read more

Where To Begin

Image
As a computer science student aiming to become a data scientist is one of the options from a vast pool. I think I don't have to explain here what data science is and stuffs like that. So, What is the purpose of this blog? This blog will showcase my journey as fresher to a Data Scientist, maybe more. So the blog will contain all the steps that I am taking for this. I hope this will help others to follow me through my journey as well as keep me on track. It will contain learning materials,links, projects, codes..etc. To learn Data Science Python is essential. That leads us to the First Step of our learning journey    Basics Of Python (Explained in the next blog)
Read more