ALTER TABLE `table_name` ADD COLUMN `column_name2` varchar(255) AFTER `column_name1`;
metadata['class_pnemonia'] = metadata['class'].astype('category').map({0: 'HEALTHY ', 1: 'PNEUMONIA'})