append just returns a new object without automatically updating, which can lead to mistakes
this is the nature of pandas itself
Pandas Notion
Dataframe Similars
Vectorized operation
Python| Pandas dataframe.append() - GeeksforGeeks
Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas dataframe.append() function is used to append rows of other dataframe to the end of the given dataframe, returning a new dataframe object.
https://www.geeksforgeeks.org/python-pandas-dataframe-append/


Seong-lae Cho