1. Objective
What is goal of Globalvat data portal?
...
take original excel table & import into deep note
process the table:
highlighting the errors using simple analysis
produce additional columns like day of the week
produce a copy of deepnote output and store it in google sheets
work manually in the google sheets to clean it (using the highlighted errors)
then: import the cleaned google sheet via API into deepnote and
run again the code from before in deepnote
if needed: combine several month-tables into a yearly table or bigger to prepare for splitting
then, split it in deepnote into the final tables to be imported ino GV (this is equivalent to step C-2.a)
next steps
task | assigned | status | ||||||
|---|---|---|---|---|---|---|---|---|
complete initial excel files for all months Jacopo Cossu |
| |||||||
advice on package size to be imported (month, years, all) Francesco Beretta |
| |||||||
test & improve cleaning workflow as described above |
| |||||||
check the data and correct them manually |
|
...
Information of interest | Relations/ links | Examples | Description & Comments | Relevant to Research Questions |
|---|---|---|---|---|
Audience identifier | to Audience on “Audience identifier” | ! the form it should take must be determined | To link the participant event back to the audience | Ensures the correct quantification of partecipation for audience and derived properties |
Participation event identifier |
| ! the form it should take must be determined | ||
Personne reçue (comme indiquée) | Emo Cardinale Sibilia; S.E. Mons. Pisani; S.E. Mons. Cesarini; P. Cordovani O.P.; Conte Stanislao Medolago Albani; Barone de Pfyffer d'Altishofen | Constitutes the mention of an individual subject received in the audience, as reported by the source. | ||
Qualité personne (comme indiquée) | Assessore della S.C. per la Chiesa Orientale; Prefetto delle Cerimonie Pontificie; Maestro del Sacro Palazzo Apostolico; Sostituto della Segreteria di Stato; Segretario della S.C. dei Religiosi; Sotto-Segretario della S.C. dei Sacaramenti; Sotto-Segretario della S.C. dei Sacramenti per la vigilanza sui Tribunali matrimoniali; Tenente Colonello della Guardia Svizzera; Superiora dell'Istituto Volpicelli | Records the title, function, or more generally the description defining the person received on the title page of the physical file (documentary source) | ||
Groupe reçu\n(comme indiqué) | It constitutes the mention of a set of people (formal or informal groups), otherwise unspecifiable, as reported by the source | |||
Qualité groupe\n(comme indiquée) | Deprecated | Records the title, function or, more generally, description that defines the indistinct set of subjects as recorded by the source | ||
Mention d’accompagnement\n(comme indiquée) | "e la famiglia"; "con due sorelle"; "e un gruppo di connazionali" | Records mention of unnamed companions | ||
Accompagnement" | “personne accompagnée”; “personne accompagnant” | Records whether a person is mentioned as accompanied or chaperoned |
...