BI Analyst, Arsenal fan, food lover, maths tutor & founder of Maths with Lily @ mathswithlily.com

I recently put my business, Maths with Lily, on Instagram — here’s what I’ve learnt in a week of organic growth.

Image for post
Image for post
Photo by Dominik Dancs on Unsplash


My experience of creating a WordPress blog in 2021 — including why I threw my first attempt in the bin.

Image for post
Image for post
Original image by author using Canva


How to use five of the top searched column operations for Python package Pandas on Google

Image for post
Image for post
Photo by billow926 on Unsplash


Copying and exporting data from SSMS to share can be frustrating without headers — here’s how to include them

Image for post
Image for post
Photo by Jonas Jacobsson on Unsplash


An intro to Pandas plots you can use to help transition your analysis and data visualisations from Microsoft Excel to Python

Image for post
Image for post
Photo by JESHOOTS.COM on Unsplash

Getting started


And why I’m not about to turn my back on it

Image for post
Image for post
Photo by erica steeves on Unsplash

1. The upfront cost is only £2!


13 methods you can use to avoid repeating tasks in Microsoft Excel, while up-skilling yourself in Python and gaining back time.

Image for post
Image for post
Photo by Alexander Schimmeck on Unsplash


How you can use these pandas methods to transition from Microsoft Excel to Python, saving you serious time and sanity.

Image for post
Image for post
Photo by Pascal Müller on Unsplash

1. Import an Excel file

df = pd.read_excel(some_file_path)

2. View your new dataframe


How to use python to make working with bank holidays that bit easier, in particular using the holidays package for your automation.

Image for post
Image for post
Photo by Annie Spratt on Unsplash


Learn how to setup and run python (or R) scripts within your SQL code

Image for post
Image for post
Photo by HiveBoxx on Unsplash

Step 1: Enable Machine Learning Services within SQL Server

  • Database Engine Services
  • Machine Learning Services and Language Extension
  • Python (and/or R)

Step 2: enable external script execution

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store