Links

Create dataframe from lists

Tags: #python #list #dataframe #snippet #pandas #operations
Author: Florent Ravenel
Last update: 2023-04-12 (Created: 2022-03-07)
Description: This notebook provides instructions on how to use Python to create a dataframe from lists.

Input

Import libraries

import pandas as pd

Variables

# Setup your columns name
col_key = "KEYS"
col_value = "VALUE"

Lists

keys = [
1995,
1996,
1997,
1998,
1999,
2000,
2001,
2002,
2003,
2004,
2005,
2006,
2007,
2008,
2009,
2010,
2011,
2012,
]
value = [
219,
146,
112,
127,
124,
180,
236,
207,
236,
263,
350,
430,
474,
526,
488,
537,
500,
439,
]

Model

Create zip iterator

# Call zip(iter1, iter2) with one list as iter1 and another list as iter2 to create a zip iterator containing pairs of elements from the two lists.
zip_iterators = zip(keys, value)

Output

Create dataframe

df = pd.DataFrame(zip_iterators, columns=[col_key, col_value])
df