OpenRefine: Difference between revisions

From EU Knowledge Graph
Jump to navigation Jump to search
No edit summary
No edit summary
Line 74: Line 74:
|}
|}


* Configure the Eu Knowledge Graph as a Wikibase
=== Configure the Eu Knowledge Graph as a Wikibase ===
** On the top right click on the Extensions Wikidata button and select "Select Wikibase instance"
* On the top right click on the Extensions Wikidata button and select "Select Wikibase instance"
** Add Wikibase
* Add Wikibase
** Paste
* Paste
<syntaxhighlight lang="json">
<syntaxhighlight lang="json">
{
{
Line 113: Line 113:
</syntaxhighlight>
</syntaxhighlight>


** Press "Add Wikibase" and the Eu Knowledge Graph will appear in the list as one option to choose
* Press "Add Wikibase" and the Eu Knowledge Graph will appear in the list as one options to choose.


=== Reconcile your data ===
=== Reconcile your data ===


In general follow the instructions on OpenRefine for these steps.
In general follow the [https://docs.openrefine.org/manual/wikibase/reconciling instructions on OpenRefine] for these steps. Here is just an example:
Select the column with the Q-ID
 
* Choose the column "entity" and click on "Reconcile -> Use Values as Identifiers"
* Then the column will be completely reconcile


=== Model your data using the Wikibase Schema ===
=== Model your data using the Wikibase Schema ===
In general follow the [https://docs.openrefine.org/manual/wikibase/schema-alignment instructions on OpenRefine] for these steps. Here is just an example:
* Click on the schema tab
* Below you find an image on how we aligned the schema of the csv and the Eu Knowledge Graph.


=== Upload your data ===
=== Upload your data ===
* In the upper right click on Wikidata -> Upload Edits to Wikibase
* Log in
* Upload Edits
The data you ingested is not available in the Eu Knowledge Graph!

Revision as of 09:10, 26 June 2022

This page contains instructions to connect OpenRefine to edit the Eu Knowledge Graph.

Requirements

Setup

  • Upload you data. For example
    • Create Project
    • Clipboard
    • Insert the data in the Table below
    • Next
    • Create Project
entity program cci website
https://linkedopendata.eu/entity/Q2463293 2014GR16M1OP001 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/Greece/2014GR16M1OP001
https://linkedopendata.eu/entity/Q2463518 2014TC16I5CB001 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB001
https://linkedopendata.eu/entity/Q2463519 2014TC16I5CB002 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB002
https://linkedopendata.eu/entity/Q2463520 2014TC16I5CB003 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB003
https://linkedopendata.eu/entity/Q4294076 2014TC16I5CB004 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB004
https://linkedopendata.eu/entity/Q2463524 2014TC16I5CB005 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB005
https://linkedopendata.eu/entity/Q2463525 2014TC16I5CB006 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB006
https://linkedopendata.eu/entity/Q2463526 2014TC16I5CB007 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB007
https://linkedopendata.eu/entity/Q2463529 2014TC16I5CB008 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB008
https://linkedopendata.eu/entity/Q2463530 2014TC16I5CB009 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB009
https://linkedopendata.eu/entity/Q2463531 2014TC16I5CB010 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB010
https://linkedopendata.eu/entity/Q2463534 2014TC16M4TN001 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16M4TN001
https://linkedopendata.eu/entity/Q2463535 2014TC16M4TN002 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16M4TN002

Configure the Eu Knowledge Graph as a Wikibase

  • On the top right click on the Extensions Wikidata button and select "Select Wikibase instance"
  • Add Wikibase
  • Paste
{
   "version":"1.0",
   "mediawiki":{
      "name":"EU Knowledge Graph",
      "root":"https://linkedopendata.eu/wiki/",
      "main_page":"https://linkedopendata.eu/wiki/Main_Page",
      "api":"https://linkedopendata.eu/w/api.php"
   },
   "wikibase":{
      "site_iri":"https://linkedopendata.eu/entity/",
      "tag":"",
      "maxlag":5,
      "properties":{
         "instance_of":"P35",
         "subclass_of":"P302"
      },
      "constraints":{
         "property_constraint_pid":"P861",
         "exception_to_constraint_pid":"P406",
         "constraint_status_pid":"P1150",
         "mandatory_constraint_qid":"Q236765",
         "suggestion_constraint_qid":"Q236827",
         "distinct_values_constraint_qid":"Q196794"
      }
   },
   "reconciliation":{
      "endpoint":"https://openrefine-reconciliation.linkedopendata.eu/${lang}/api"
   },
   "editgroups":{
      "url_schema":"([[:toollabs:editgroups/b/OR/${batch_id}|details]])"
   }
}
  • Press "Add Wikibase" and the Eu Knowledge Graph will appear in the list as one options to choose.

Reconcile your data

In general follow the instructions on OpenRefine for these steps. Here is just an example:

  • Choose the column "entity" and click on "Reconcile -> Use Values as Identifiers"
  • Then the column will be completely reconcile

Model your data using the Wikibase Schema

In general follow the instructions on OpenRefine for these steps. Here is just an example:

  • Click on the schema tab
  • Below you find an image on how we aligned the schema of the csv and the Eu Knowledge Graph.

Upload your data

  • In the upper right click on Wikidata -> Upload Edits to Wikibase
  • Log in
  • Upload Edits

The data you ingested is not available in the Eu Knowledge Graph!