Create dataframe from lists
Tags: #python #list #dataframe #snippet #pandas #operations
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.
import pandas as pd
# Setup your columns name
col_key = "KEYS"
col_value = "VALUE"
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,
]
# 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)
df = pd.DataFrame(zip_iterators, columns=[col_key, col_value])
df