pandas columns to list code example

Example 1: python - convert a column in a dataframe into a list

myvar_list = df["myvar"].tolist()

Example 2: how to get a dataframe column as a list

import pandas as pd

data_dict = {'one': pd.Series([1, 2, 3], index=['a', 'b', 'c']),
             'two': pd.Series([1, 2, 3, 4], index=['a', 'b', 'c', 'd'])}

df = pd.DataFrame(data_dict)

print(f"DataFrame:\n{df}\n")
print(f"column types:\n{df.dtypes}")

col_one_list = df['one'].tolist()

col_one_arr = df['one'].to_numpy()

print(f"\ncol_one_list:\n{col_one_list}\ntype:{type(col_one_list)}")
print(f"\ncol_one_arr:\n{col_one_arr}\ntype:{type(col_one_arr)}")

Example 3: get dataframe column into a list

df_gearME = pd.read_excel('Gear M&Es.xlsx')
df_gearME['ColA'].to_list()

Example 4: python pandas return column name of a specific column

# Basic syntax:
list(df.columns)[column_number]
# This returns the column name of the column of interest