Data Analytics and Video Tutorials
Pattern matching is used to find repeat characters and or numbers that are in a specific format. As a result, you can use it within a data quality project.
In Python, there are a number of re-occurring value errors that you will come across. In this particular error it is usually related to when you are running regular expressions as part of a pattern search. So how does the problem occur? In the below, the aim of the code is to purely create a…
Read More “ValueError: pattern contains no capture groups” »
Following on from from our previous posts on SQL, this post will help to explain how to use wildcards in your query. What would you use a wild card in the first place? When a data analyst dealing with a large dataset, it is most likely that they will not know every piece of data….
Have you encountered a problem where you have some spaces in a string that you do not need? Data analytics can throw up lots of challenges we hope to help you solve this problem easily. This problem can be quite common and can cause problems as follows: Comparing strings does not work as expected. Automated…