I think most of the answers provided here are not working with Pandas 2.2.3 and Instead of saving the Series as CSV and loading back, I have saved the pandas object as pickle using df.to_pickle() and read it back using pd.read_pickle().
2.2.3
df.to_pickle()
pd.read_pickle()