#python #pandas #lessonlearned today: (1) Merge does not preserve the order unless you are merging by the index. (2) Make sure to use `ignore_index=True` when you concat or your index might acquire duplicates. Want to hear how much fun I had #debugging to come up with these gems of wisdom? #pythonprogramming