Data Analytics and Video Tutorials
Python pandas are used extensively to store data, as a result, it can be sliced and diced onto a screen. Also, it can be saved to a file.
So you are working on a number of different data analytics projects, and as part of some of them, you are bringing data in from a CSV file. One area you may want to look at is How to Compare Column Headers in CSV to a List in Python, but that could be coupled with…
Read More “How to count the no of rows and columns in a CSV file” »
In Python you may come across IndexError: index 2 is out of bounds for axis 0 with size 2 from time to time. The error relates to the use of indexes and the no of columns you are referencing. We discussed single positional indexer is out-of-bounds and in that blog post, it was related to…
Read More “IndexError: index 2 is out of bounds for axis 0 with size 2” »
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)” »
In this first video about pandas groupby and as part of expanding the data analytics information of this website, we are looking to explain how you can use a groupby selection to sort your data into similar datasets better so they can be better analysed. In the video below, we import our data into a…