Data Cleansing and Analysing

[Simon1187]

The dataset contained within is typical of the type of research publication data. It represents actual data used in a recently completed project and was obtained from a well-used global database called 'Scopus' (owned by the publisher Elsevier). Scopus data is notorious for inconsistencies and errors. 

DATA ELEMENTS

EID   - A Scopus unique identifier for an indexed research output

Author Count   - The count of Authors listed for each research output

Author ID   - A Scopus unique identifier for each author

Auth Name   - The name of the author (Surname and First Initital only)

Afilliation ID   - A Scopus unique identifier for each institution and/or research unit

Afilliation Name   - The name of the institution and/or research unit

Afilliation City   - The city location of the institution and/or research unit

Afilliation Country   - The country location of the institution and/or research unit

QUESTIONS

 Find the individual author associated with the most research outputs.

Can you please help me with them? 

Thanks, 

Simon

[atcodedog05]

Hi @Simon1187 

This seems to be like a certification question sorry we are not allowed to answer this.

[Simon1187 · Accepted solution]

@atcodedog05 

No this is not a certification question.

[saveeshkumar · Accepted solution]

Hi @Simon1187 ,

Please find the flow.

Thanks