The present invention discloses an energy consumption data processing method based on a table-code value. The method comprises: a device end transmits energy consumption data in a ''table-code value'' format; a data preprocessing program receives the energy consumption data; the data preprocessing program recognizes abnormal data in the energy consumption data by an Euclidean distance algorithm and a first algorithm, and recognizes missing data in the energy consumption data by a second algorithm; the data preprocessing program corrects the abnormal data by a mean interpolation method, and compensates the missing data by a valid data interpolation method; and the preprocessing program stores the normal energy consumption data, the corrected energy consumption data and the compensated energy consumption data into a table-code value table of the data preprocessing program. According to the method disclosed by the present invention, by using characteristics of the Euclidean distance algorithm, the mean interpolation method and the last valid data interpolation method, the abnormal data in the energy consumption data is recognized and corrected, and the missing data is compensated.