Updating Rows (learnsqlonline.org)
Updating rows in a SQL database is a crucial task that allows you to modify existing data in a table. SQL provides a straightforward way to update rows using the…
Continue readingData Visualisation
All Data Visualisation content from my online portfolio
Regular Expressions (learnpython.org)
Regular expressions, commonly known as regex, are sequences of characters that define a search pattern. They enable us to perform advanced text matching and manipulation by using metacharacters, quantifiers, and…
Continue readingList Comprehensions (learnpython.org)
List comprehensions provide a straightforward syntax for transforming data within lists. By applying expressions and conditions within the comprehension, you can modify each element of the original list and generate…
Continue readingPandas Basics (learnpython.org)
At the heart of Pandas lies the DataFrame, a two-dimensional table resembling a spreadsheet or SQL table. With labeled rows and columns, the DataFrame enables easy manipulation and analysis of…
Continue readingNavigating the Data Science Landscape
In the vast ocean of digital information, data science emerges as the lighthouse guiding organizations through the fog of uncertainty towards clarity and insight. As the world becomes increasingly data-driven,…
Continue readingConditions (learnpython.org)
Conditional statements are a powerful and essential tool for programmers, allowing them to write code that responds dynamically to different inputs and situations. In Python, conditional statements are easy to…
Continue readingBasic String Operations (learnpython.org)
Basic String Operations is a tutorial that covers the fundamental string operations in Python. The tutorial begins by defining what strings are and why they are useful in programming. It…
Continue reading