PinnedJames McNeillinTowards Data SciencePython water quality EDA and Potability analysisUnderstanding data analysis, visualization techniques11 min read·Jul 8, 2023--5--5
PinnedJames McNeillinTowards Data ScienceDeep dive into SQL window functionsThe SQL window function performs calculations across a set of table rows to streamline data analysis9 min read·Feb 21, 2022----
James McNeillinTowards Data SciencePython Water Quality — Baseline Classification ModelAssess feature importance when estimating water quality using a reference baseline model11 min read·Jan 8, 2024----
James McNeillinTowards Data ScienceDeclaring Variables within SQLEnsuring key variables are declared at the beginning of the SQL code can help to automate the re-use of the code.8 min read·Feb 17, 2022--1--1
James McNeillinTowards Data ScienceStrings in SQL, Part 2Aggregating and segmenting string variables with SQL5 min read·Jan 13, 2022----
James McNeillinTowards Data ScienceStrings in SQL part 1Extracting meaningful insights from character columns using SQL string techniques5 min read·Nov 17, 2021----
James McNeillinTowards Data ScienceDeveloping SQL tablesBy creating and developing SQL tables only then can we understand how to best use the memory available.8 min read·Aug 21, 2021----
James McNeillinCodeXMicrosofts underwater data centreAs the number of data centres continues to grow, can a climate efficient solution to energy consumption be achieved by going underwater?4 min read·Jul 25, 2021----
James McNeillinTowards Data ScienceGetting started with NLP in PythonBeginning a journey into the Natural Language Processing space9 min read·Jul 17, 2021--1--1
James McNeillinTowards Data ScienceAdvanced SQL operationsReviewing more advanced SQL operations to extract additional data insights from the Irish Weather dataset.5 min read·Jun 26, 2021--1--1