The contract between cleaning and analysis
The cleaned file is not just tidier. It carries structure a raw export does not have. That structure is what lets the analysis reach the internal unit and the city.
Author positions are preserved, so the three columns stay aligned and a collaboration network can be rebuilt without guessing who wrote with whom:
Authors 1:Idri A.; 2:Hosni M.; 3:Abran A.
Author full names 1:Idri, Ali (6602789810); 2:Hosni, Mohamed (57189341317)
Author(s) ID 1:6602789810; 2:57189341317; 3:7004233119
Affiliation segments are labelled, so an empty field is simply omitted and reading never depends on position:
subparent: ENSMR, parent 1: National School of Mineral Industry, city: Rabat, country: Morocco
parent 1: University of Murcia, city: Murcia, region: Murcia, country: Spain
parent 1: LIRIMA, site: virtual, country: France
subparent, parent 1, parent 2, city, site, region, country. Several affiliations of one article stay separated by ; .