Among sub-items of energy consumption in public buildings, lighting sockets play an important role in energy-saving analysis. So, the energy consumption data quality of lighting sockets is important. However, limited by the initial cost of energy monitoring platform, it is difficult to install electricity meters covering all branches and to retrofit the incompact classification electricity branches, which results in a mixture of the lighting socket energy consumption and other components. In this study, a separation methodology is proposed. First, the abnormal data in the energy monitoring platform are cleaned and screened using a clustering algorithm. Second, the average outdoor air temperature partitioning model (OATPM) method and the k-nearest neighbor (KNN) clustering algorithm method are proposed for identifying and separating the abnormal data. These two methods have complementary advantages in the best applicable scenarios, including calculation accuracy and other aspects. The verification results for three buildings show that the relative error of this separation methodology is less than 15%. Finally, this paper presents the optimization parameters of the KNN method. Through this methodology, building managers need only historical data in an energy monitoring platform to separate the combined power consumption of the lighting sockets and air-conditioning online, independent of detailed information statistics.