Data Analytics and Video Tutorials
Data Analysis is the process of taking a set of data and understanding how it is created, processed and reported on. It enables a better way of understanding how to use the data for reporting and decision-making.
Are you developing a website and looking to execute some Python script directly from the website? Here we take you through how to achieve this using Python Flask, the scenarios we demonstrate are as follows: In both scenarios above you will be presented with pop-up boxes like below, but the python code can be changed…
Sometimes in your data analytics project, you will be working with float data types and integers, but the value NaN may also appear, which will give you headaches if you don’t know how to fix the problem at hand. A NaN is defined as “Not a Number” and represents missing values in the data. If…
Read More “ValueError: cannot convert float NaN to integer” »
When working with Python lists in your data analytics projects, when you trying to read the data, a common problem occurs if you have a list of lists, and it is not properly formatted. In this instance, Python will not be able to read one or more lists and as a result, will throw this…
Read More “TypeError: List Indices Must Be Integers Or Slices, Not Tuple” »
Have you learnt how to connect to your data in Tableau and now want to understand how to group your Tableau data? Here we go through a number of steps to help you understand better how to approach this, and what benefits it will bring to your data analytics project. Why would I group in…
Livestream #2 – What does a data analyst do? You are probably sitting there hearing about big data and databases, data analytics and machine learning, and wondering where a data analyst fits in. Here we will look to break it down step by step. Difference between a Data Analyst and a Business Analyst Data Analyst…
Pandas groupby using column values In this second video how to groupby using pandas and as part of expanding the data analytics information of this website, we are looking to explain how you can use a groupby selection but only using the column values and not the column names. Below we import our data into a…
Read More “Python Tutorial: Pandas groupby columns ( video 2)” »
Regular expressions explained Regular expressions are a set of characters usually in a particular sequence that helps find a match/pattern for a specific piece of data in a dataset. The purpose is to allow a uniform of set characters that can be reused multiple times, based on the requirements of the user, without having to…
What are python reserved keywords? When coding in the Python language there are particular python reserved words that the system uses, which cannot be accessed as a variable or a function as the computer program uses them to perform specific tasks. When you try to use them, the system will block them and throws out…
Using a Tkinter input box for your data projects There may be an occasion as you are building out a data science or data analytics project, checks need to be performed on the dataset as follows: Big data sets and speed requirements in conjunction with The need to reduce the volume of data returned is…
Read More “Python tutorial: Create an input box in Tkinter” »
How would you like to present your data analytics work better? When starting your data analytics projects, one of the critical considerations is how to present your results quickly and understandably? Undoubtedly this is true if you are only going to look at the results yourself. If the work you do is a repeatable process,…
Read More “Python tutorial: How to create a graphical user interface in Tkinter” »