Core Foundation Skills
- Python & Pandas: DataFrames, series, filtering, grouping, aggregation, reading CSV/JSON files.
- SQL Querying:
SELECT,JOIN(INNER, LEFT, RIGHT),GROUP BY,HAVING, Window functions (ROW_NUMBER,RANK), CTEs. - Statistics & Math: Mean, Median, Variance, Standard Deviation, Correlation vs Causation, Normal Distributions, Probability.