It’s a bottleneck Split metadata and data into separate DFs. Use series ID as key. Tidy separately and join.