df.squeeze() # converts to series # OR # When loading a file pd.read_csv("df.csv", index_col="col1", squeeze=True)