Cleaned Datasets and Analysis Scripts for EVs Charging stations and Grid Impact in Egypt

This dataset contains cleaned and processed data used in the study of smart electric vehicle (EV) charging stations and their impact on the electrical grid in Egypt. EV charging station data were collected from PlugShare (snapshot on March 15, 2024) and underwent duplicate removal and quality assurance (QA) checks. District-level population projections (2020–2030) were obtained from CAPMAS and Cairo Governorate publications. National electricity load profiles (2019–2024) were derived from the Egyptian Electricity Holding Company (EEHC) and the Ministry of Electricity and Renewable Energy (MOEE) official reports. In addition to the datasets (CSV format), the repository includes analysis scripts for K-means clustering, SPDI/STBI index calculations, and spatial mapping. These resources enable full reproducibility of the study results and can be reused in further research on EV infrastructure planning, demand analysis, and smart grid integration in Egypt and similar contexts.