Reindex

PHOTO EMBED

Thu May 26 2022 16:16:34 GMT+0000 (Coordinated Universal Time)

Saved by @vivienfeng11 

flattened=flattened.reindex(['invoice_id','reservation_id','Usage_gross',
                             'Mileage_gross','Late_return_gross',
                             'PCN_gross','PCN_admin_gross',
                             'Flex_gross',
                             'Driving_credits_gross',
                             'Total_VAT'], axis=1)
flattened=flattened.fillna(0)
content_copyCOPY

Change the column name

http://localhost:8888/notebooks/Z4B invoice - Croydon 22-02-09.ipynb