Coding Practice: Python Pandas, SQL & Algorithms

This repository is where I store and organize my coding practice for Python Pandas, SQL, and algorithms. The exercises come from a few different platforms like LeetCode, StartaScratch, and DataLemur, and are split into topics to help me focus on different areas of learning. The idea is to keep track of problems I've worked on and revisit certain topics when I want to reinforce specific skills.

Folder Structure

The repository is split into three main sections based on the language or problem type: python_pandas, sql, and python_algorithm. Each of these folders contains subfolders categorized by the types of problems I practiced.

Python Pandas

python_pandas/
    ├── dataframe_manipulation/   # Basic manipulations of DataFrames
    ├── datetime/                 # Working with datetime objects in Pandas
    ├── filtering/                # Filtering rows and columns in DataFrames
    ├── groupby_operations/       # Grouping and aggregating data
    ├── lambda_function/          # Using lambda functions within DataFrames
    ├── merging_joining/          # Combining DataFrames with merges and joins
    ├── pivot/                    # Creating pivot tables
    ├── set_operations/           # Performing set operations on data
    ├── window_function/          # Using rolling windows and other window functions

SQL

sql/
    ├── basic_select_queries/     # Simple SELECT queries
    ├── cte/                      # Using Common Table Expressions (CTEs)
    ├── datetime/                 # Handling date and time in SQL
    ├── groupby_operations/       # Aggregating data with GROUP BY
    ├── joins/                    # Different types of SQL joins
    ├── set_operations/           # Set operations like UNION and INTERSECT
    ├── string_manipulation/      # Working with strings in SQL
    ├── subqueries/               # Using subqueries for complex logic
    ├── window_function/          # SQL window functions like RANK, ROW_NUMBER, etc.

Python Algorithms

python_algorithm/
    ├── sorting/                  # Implementations of various sorting algorithms
    ├── search/                   # Searching algorithms like binary search, linear search
    ├── recursion/                # Problems involving recursive approaches
    ├── dynamic_programming/      # Problems solved using dynamic programming techniques
    ├── graphs/                   # Graph-based algorithms (BFS, DFS, etc.)
    ├── backtracking/             # Backtracking problems and solutions

What This Repository Contains

This is where I practice solving problems related to data manipulation, querying, and algorithms. Each folder contains different types of problems, organized by the core concept or function that the problem focuses on. This repository is more of a personal playground for learning and improvement. :-)