In the posts in this category you will find Python scripts. Python is said to be one of the easiest programming language to learn. Learning one language will also make it easier to learn another, much more advanced, one. As a Bachelor student in the cognitive science programme I got to take Python courses. However, it was not before I started my Ph.D years that I realized how much use I had because I knew some programming.
For a psychology researcher Python might be ideal since it is relatively easy to learn and there is a huge Python community to get help from. How to build experiments using free and open-source tools such as PsychoPy, OpenSesame, Expyriment, and PyEPL is, for instance, something you could find in this category.
In this post, we will calculate a correlation matrix in Python with NumPy and Pandas. Now, there will be several Python correlation matrix examples in this tutorial. First, we will read data from a CSV file so we can simply have a look at the numpy.corrcoef and Pandas DataFrame.corr methods. Now, building a correlation table […]
Create a Correlation Matrix in Python with NumPy and Pandas Read More »
Renaming columns in Pandas can be a lifesaver when working with data. Sometimes, we might receive data from a colleague or download it from the internet, and the column names might not be informative or consistent with our analysis. This could lead to confusion and errors in data interpretation, so it’s essential to know how
Pandas Tutorial: Renaming Columns in Pandas Dataframe Read More »
Here you will learn how to use Pandas read_html to scrape tables from web pages such as Wikipedia.
How to use Pandas read_html to Scrape Data from HTML Tables Read More »
In this Python data visualization tutorial, we will work with Pandas scatter_matrix method to explore trends in data. Previously, we have learned how to create scatter plots with Seaborn and histograms with Pandas. This post will focus on scatter matrices (pair plots) using Pandas.
How to use Pandas Scatter Matrix (Pair Plot) to Visualize Trends in Data Read More »
In this Python tutorial, we will learn how to get the absolute value in Python. First, we will use one of Pythons built-in functions abs() to do this. In this section, we will go through a couple of examples of how to get the absolute value. Second, we will import data with Pandas and use
How to get Absolute Value in Python with abs() and Pandas Read More »
In this short Python Pandas tutorial, we will learn how to convert a Pandas dataframe to a NumPy array. Specifically, we will learn how easy it is to transform a dataframe into an array using the two methods values and to_numpy, respectively. Furthermore, we will also learn how to import data from an Excel file
How to Convert a Pandas DataFrame to a NumPy Array Read More »
In this brief Python Pandas tutorial, we will go through the steps of creating a dataframe from a dictionary. Specifically, we will learn how to convert a dictionary to a Pandas dataframe in 3 simple steps. First, however, we will just look at the syntax. After we have had a quick look at the syntax
How to Convert a Python Dictionary to a Pandas DataFrame Read More »
Do you ever spend hours sifting through Excel files, trying to make sense of the data? Openpyxl can help! In this tutorial, we’ve covered everything you need to know about using Openpyxl in Python to read and manipulate Excel files. You will learn to import the necessary modules, set the file path, and read the file and its active sheet. We’ll also dive deeper into manipulating the sheet, including creating a dictionary from an Excel file and reading multiple Excel files in a directory.
By mastering these techniques, you can streamline your data processing workflow and gain valuable insights from your data in a fraction of the time. Whether you are a data analyst or someone looking to make sense of complex data sets, Openpyxl is a powerful tool to help you achieve your goals. So, grab your favorite beverage, fire up your Python IDE, and let’s get started!
Your Guide to Reading Excel (xlsx) Files in Python Read More »
In this short post, you will learn 6 methods to get the column names from Pandas dataframe. One of the nice things about Pandas dataframes is that each column will have a name (i.e., the variables in the dataset). Now, we can use these names to access specific columns by name without having to know which column number it is.
How to Get the Column Names from a Pandas Dataframe – Print and List Read More »
Learn how to make a histogram using Pandas hist() method. In this post, you will learn 3 simple steps on how to plot a histogram with Pandas.
How to Plot a Histogram with Pandas in 3 Simple Steps Read More »