SyntaxPilot
Courses/Data Analytics with Python

Beginner · Free course

Data Analytics with Python

Clean, analyse and visualise real data with pandas.

90 lessons24 videos so far5 h 37 min of videoNotes for every lesson

What you’ll learn

  • NumPy and pandas
  • Cleaning and reshaping data
  • Visualisation
  • Analysis projects
0 of 90 complete

Curriculum

  1. 1What a data analyst does, and the analysis workflow12 min
  2. 2Data, datasets and types of datasoon
  3. 3Setting up: Jupyter, Colab and Python environmentssoon
  4. 4Python for data 1: variables, types and operators28 min
  5. 5Python for data 2: lists, tuples, dicts and sets14 min
  6. 6Python for data 3: conditions, loops and comprehensions13 min
  7. 7Python for data 4: functions, errors and files17 min
  8. 8NumPy 1: arrays and vectorised maths19 min
  9. 9NumPy 2: indexing, masks, reshaping and axes17 min
  10. 10NumPy 3: broadcasting, random numbers and NaN16 min
  11. 11pandas 1: the Series14 min
  12. 12pandas 2: the DataFramesoon
  13. 13pandas 3: reading and writing CSV, Excel, JSON and Parquet17 min
  14. 14pandas 4: selecting with [], loc and iloc11 min
  15. 15pandas 5: filtering rows12 min
  16. 16pandas 6: sorting, ranking and creating columnssoon
  17. 17pandas 7: apply, map, binning and method chaining14 min
  18. 18Data quality and profiling before cleaning11 min
  19. 19Cleaning 1: missing values13 min
  20. 20Cleaning 2: duplicates and data types12 min
  21. 21Cleaning 3: text data and regular expressions10 min
  22. 22Cleaning 4: dates and times13 min
  23. 23Cleaning 5: outliers, validation and sanity checks11 min
  24. 24GroupBy 1: split-apply-combine and aggregation10 min
  25. 25GroupBy 2: transform, filter and MultiIndex13 min
  26. 26Combining data: concat, merge and join13 min
  27. 27Reshaping: pivot, pivot_table, melt and crosstab11 min
  28. 28Time series in pandas: resample, rolling and shift16 min
  29. 29Working with bigger data: memory, speed and Parquetsoon
  30. 30Charts 1: matplotlib basicssoon
  31. 31Charts 2: histograms, scatter, box plots and subplotssoon
  32. 32Charts 3: choosing the right chartsoon
  33. 33Charts 4: seaborn for statistical plotssoon
  34. 34Descriptive statistics 1: averagessoon
  35. 35Descriptive statistics 2: spread and percentilessoon
  36. 36Descriptive statistics 3: shape, skew and z-scoressoon
  37. 37EDA 1: exploring one variable at a timesoon
  38. 38EDA 2: relationships between variablessoon
  39. 39Probability 1: events, rules and conditional probabilitysoon
  40. 40Probability 2: Bayes' theorem and base ratessoon
  41. 41Random variables and discrete distributionssoon
  42. 42Continuous distributions and the normal curvesoon
  43. 43Sampling methods and sampling biassoon
  44. 44Sampling distributions and the central limit theoremsoon
  45. 45Estimation: confidence intervals and the bootstrapsoon
  46. 46Hypothesis testing 1: the framework and p-valuessoon
  47. 47Hypothesis testing 2: t-tests and z-testssoon
  48. 48Hypothesis testing 3: chi-square, ANOVA and non-parametric testssoon
  49. 49Hypothesis testing 4: multiple testing and practical significancesoon
  50. 50Correlation, causation and confoundingsoon
  51. 51Regression 1: simple linear regressionsoon
  52. 52Regression 2: multiple regression and its assumptionssoon
  53. 53Regression 3: logistic regression and prediction basicssoon
  54. 54Excel for analysts 1: formulas and lookupssoon
  55. 55Excel for analysts 2: PivotTables and Power Querysoon
  56. 56SQL for analysts 1: querying databases from Pythonsoon
  57. 57SQL for analysts 2: CTEs, window functions and DuckDBsoon
  58. 58Power BI 1: Power Query and the data modelsoon
  59. 59Power BI 2: DAX measures and report designsoon
  60. 60Dashboards in Python: Plotly and Streamlitsoon
  61. 61Metrics and KPIs: defining what to measuresoon
  62. 62Revenue and growth metricssoon
  63. 63Engagement metrics: DAU, MAU and stickinesssoon
  64. 64Funnel analysissoon
  65. 65Cohort analysissoon
  66. 66Retention and churnsoon
  67. 67LTV, CAC and marketing attributionsoon
  68. 68Customer segmentation with RFMsoon
  69. 69Pareto, ABC analysis and market basket analysissoon
  70. 70A/B testing 1: designing an experimentsoon
  71. 71A/B testing 2: analysing resultssoon
  72. 72A/B testing 3: pitfalls and quasi-experimentssoon
  73. 73Time series concepts: trend, seasonality and stationaritysoon
  74. 74Forecasting 1: baselines, smoothing and error metricssoon
  75. 75Forecasting 2: ARIMA, Prophet and prediction intervalssoon
  76. 76Storytelling with data: from chart to insightsoon
  77. 77The analyst's workflow: framing problems and finding root causessoon
  78. 78Getting data from APIs and the websoon
  79. 79How analytics data is built: warehouses, ETL and dbtsoon
  80. 80Reproducible, responsible analysis: Git, structure and ethicssoon
  81. 81Interview prep 1: Python and pandas questionssoon
  82. 82Interview prep 2: SQL questions for analystssoon
  83. 83Interview prep 3: statistics and A/B testing questionssoon
  84. 84Interview prep 4: product sense, metrics and business casessoon
  85. 85Interview prep 5: portfolio, resume and take-home assignmentssoon
  86. 86Project 1: retail sales analysis end to endsoon
  87. 87Project 2: app user behaviour: funnels, cohorts and retentionsoon
  88. 88Project 3: analysing an A/B test of a checkout redesignsoon
  89. 89Project 4: cricket stats deep divesoon
  90. 90Capstone: forecasting sales and shipping a dashboardsoon