How to Tabulate Variables in Python

In this tutorial, we’ll discuss how to tabulate variables in Python. Managing and analyzing data is a significant aspect of Python, and understanding how to tabulate variables will add to your data manipulation skills. The Python library we will use for tabulation is called Pandas, which provides data structures and data analysis tools.

Step 1: Install and import the Pandas library

To use pandas, we first need to install it using pip. Type the following command in your terminal:

1
pip install pandas

Next, we should import pandas into our Python program:

1
import pandas as pd

Step 2: Create a DataFrame

In pandas, a DataFrame is a two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). You can think of it like a spreadsheet SQL table or a dictionary of Series objects.

1
2
3
4
data = {'Names': ['John', 'Anna', 'Peter', 'Linda'],
        'Age': [28, 24, 35, 32],
        'City': ['New York', 'Paris', 'Berlin', 'London']}
df = pd.DataFrame(data)

Step 3: Tabulating the Variables

To tabulate the variables, we can use the crosstab function from pandas:

1
2
table = pd.crosstab(df['Age'], df['City'])
print(table)

Step 4: Analyzing the Results

The tabulated results allow a quick review of the distribution and relationship between the variables. Each row corresponds to an ‘Age’ value and each column to a ‘City’ value. A number in any cell indicates the number of instances matching the corresponding ‘Age’ and ‘City’.

Full Code

1
2
3
4
5
6
7
8
9
import pandas as pd
 
data = {'Names': ['John', 'Anna', 'Peter', 'Linda'],
        'Age': [28, 24, 35, 32],
        'City': ['New York', 'Paris', 'Berlin', 'London']}
df = pd.DataFrame(data)
 
table = pd.crosstab(df['Age'], df['City'])
print(table)
 
City  Berlin  London  New York  Paris
Age                                  
24         0       0         0      1
28         0       0         1      0
32         0       1         0      0
35         1       0         0      0

Conclusion

Tabulating variables in Python using the pandas library is a straightforward process. The use of DataFrames and the crosstab function afford incredibly versatile data manipulation capabilities. With this knowledge, you’re set to perform more complex data analysis tasks, enhancing your Python skills.