pandas.DataFrame将行(index)和列(column)进行转置

 

原始数据

data = [['AMB_TEMP', '14', '14', '14', '13', '12', '12', '12', '12', '15',
        '17', '20', '22', '22', '22', '22', '22', '21', '19', '17', '16',
        '15', '15', '15', '15'],
       ['CH4', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8',
        '1.8', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8',
        '1.8', '1.8', '1.8', '1.8', '1.8', '1.8', '1.8'],
       ['CO', '0.51', '0.41', '0.39', '0.37', '0.35', '0.3', '0.37',
        '0.47', '0.78', '0.74', '0.59', '0.52', '0.41', '0.4', '0.37',
        '0.37', '0.47', '0.69', '0.56', '0.45', '0.38', '0.35', '0.36',
        '0.32'],
       ['NMHC', '0.2', '0.15', '0.13', '0.12', '0.11', '0.06', '0.1',
        '0.13', '0.26', '0.23', '0.2', '0.18', '0.12', '0.11', '0.1',
        '0.13', '0.14', '0.23', '0.18', '0.12', '0.1', '0.09', '0.1',
        '0.08'],
       ['NO', '0.9', '0.6', '0.5', '1.7', '1.8', '1.5', '1.9', '2.2',
        '6.6', '7.9', '4.2', '2.9', '3.4', '3', '2.5', '2.2', '2.5',
        '2.3', '2.1', '1.9', '1.5', '1.6', '1.8', '1.5'],
       ['NO2', '16', '9.2', '8.2', '6.9', '6.8', '3.8', '6.9', '7.8',
        '15', '21', '14', '11', '14', '12', '11', '11', '22', '28', '19',
        '12', '8.1', '7', '6.9', '6'],
       ['NOx', '17', '9.8', '8.7', '8.6', '8.5', '5.3', '8.8', '9.9',
        '22', '29', '18', '14', '17', '15', '14', '13', '25', '30', '21',
        '13', '9.7', '8.6', '8.7', '7.5'],
       ['O3', '16', '30', '27', '23', '24', '28', '24', '22', '21', '29',
        '44', '58', '50', '57', '65', '64', '51', '34', '33', '34', '37',
        '38', '38', '36'],
       ['PM10', '56', '50', '48', '35', '25', '12', '4', '2', '11', '38',
        '56', '64', '56', '57', '52', '51', '66', '85', '85', '63', '46',
        '36', '42', '42'],
       ['PM2.5', '26', '39', '36', '35', '31', '28', '25', '20', '19',
        '30', '41', '44', '33', '37', '36', '45', '42', '49', '45', '44',
        '41', '30', '24', '13'],
       ['RAINFALL', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR',
        'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR', 'NR',
        'NR', 'NR', 'NR', 'NR'],
       ['RH', '77', '68', '67', '74', '72', '73', '74', '73', '66', '56',
        '45', '37', '40', '42', '47', '49', '56', '67', '72', '69', '70',
        '70', '70', '69'],
       ['SO2', '1.8', '2', '1.7', '1.6', '1.9', '1.4', '1.5', '1.6',
        '5.1', '15', '4.5', '2.7', '3.5', '3.6', '3.9', '4.4', '9.9',
        '5.1', '3.4', '2.3', '2', '1.9', '1.9', '1.9'],
       ['THC', '2', '2', '2', '1.9', '1.9', '1.8', '1.9', '1.9', '2.1',
        '2', '2', '2', '1.9', '1.9', '1.9', '1.9', '1.9', '2.1', '2',
        '1.9', '1.9', '1.9', '1.9', '1.9'],
       ['WD_HR', '37', '80', '57', '76', '110', '106', '101', '104',
        '124', '46', '241', '280', '297', '305', '307', '304', '307',
        '124', '118', '121', '113', '112', '106', '110'],
       ['WIND_DIREC', '35', '79', '2.4', '55', '94', '116', '106', '94',
        '232', '153', '283', '269', '290', '316', '313', '305', '291',
        '124', '119', '118', '114', '108', '102', '111'],
       ['WIND_SPEED', '1.4', '1.8', '1', '0.6', '1.7', '2.5', '2.5', '2',
        '0.6', '0.8', '1.6', '1.9', '2.1', '3.3', '2.5', '2.2', '1.4',
        '2.2', '2.8', '3', '2.6', '2.7', '2.1', '2.1'],
       ['WS_HR', '0.5', '0.9', '0.6', '0.3', '0.6', '1.9', '2', '2',
        '0.5', '0.3', '0.8', '1.2', '2', '2.6', '2.1', '2.1', '1.9', '1',
        '2.5', '2.5', '2.8', '2.6', '2.4', '2.3']]
cols = ['測項', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11',
       '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23']

df = pd.DataFrame(data=data,columns=cols)

开始转置

 

cols=df['測項']
df.drop("測項",axis=1,inplace=True)
tmp_3 = pd.DataFrame(df.values.T,columns=cols)