Hi @rachitmanas, welcome! OpenRefine is written in Java and Javascript. Here is a quick guide for your first steps in the contribution process: https://github.com/OpenRefine/OpenRefine/wiki/Your-first-pull-request
@wetneb Thank You very much for replying! Honestly, Java and JavaScript are completely new language to me. I will be starting to learn them from today. Can you please also confirm whether those basic tutorials would be ok or I need to know some specific, focused sub-topic in these language.
Sorry if my question looks quite stupid to you. As I mentioned, I am a complete newbie to open source. I don't really know where to start. I saw the issues but I couldn't really get any close to solving them. I think one need to go through whole code base and understand it properly before they can start with their contribution.
Hi, I looked at OpenRefine some time ago (for clustering similar names in a cell and selecting a candidate) and just discovered the new release.
I need to classify cells as either names of persons or organisations/companies; I have a list of keywords identitfying companies (like "Ltd.", etc.).
I'm just getting into GREL and saw cell.cross(), but was wondering if there was a way to lookup if any keyword in a list of keywords (in another file or DB table) is contained in a cell.
Is there something like an ANY() operator that can be used? Or make an SQL query to a DB, preferably calling a stored procedure to implement this?
I need to classify cells as either names of persons or organisations/companies; I have a list of keywords identitfying companies (like "Ltd.", etc.).
I'm just getting into GREL and saw cell.cross(), but was wondering if there was a way to lookup if any keyword in a list of keywords (in another file or DB table) is contained in a cell.
Is there something like an ANY() operator that can be used? Or make an SQL query to a DB, preferably calling a stored procedure to implement this?
6 replies
https://github.com/OpenRefine/OpenRefine/issues/824#issuecomment-691712014
Can someone please tell how to resolve this?
Can someone please tell how to resolve this?
Yes, when I enter ./refine clean this error comes
I think its something with Maven.
sorry I did not see your screenshot above, yes it looks like you have not installed Maven on Windows correctly
This is the error when I run "mvn clean compile". What is going wrong here?
Hello everyone. This is Pranav Rajveer a sophomore Cse Undergrad from Central University, Chattisgarh (India). I am new to the open source world and I want to contribute to the organisation OpenRefine but I dont have any prior experience of Contributing in Open source. Can anyone throw some light to how i should start Contributing for this org.
I also have medium proficiency in C++ and elementary proficiency in Java and Js.
Thanku! Reply is awaited!!
1 reply
Hi All, Myself Mahesh Jindal. Presently i am working as a Data Engineer. I have experience in core development of big data architectural platforms, tools and technologies. I am proficient in working on Java, C++, Python, Big Data Frameworks and Cloud Platforms. I really liked this project and wanted to start open source contribution for the same. Can anyone please guide me ? Thanks in advance
2 replies
Hello, I want to create a spreadsheet to add information quickly about multiple items, then paste them to OpenRefine to reconciliate them with my WikiBase. What is the best way to organize RDF data that have 5 levels? Etc Item > Property > Statement > Property > Value
E.g. a way to maybe organise the image I sent above about Earth (Q2) in WIkidata to capture these levels, is to organise the property of the statement (rows) and their statements (columns) into an overearching column. But I understand that OpenRefine would not be able to process that
So what are some ways to organise this 5-level information into a spreadsheet format?
you could try to use the records mode for that: https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine/Editing/Advanced_schemas/en#Hierarchical_data
directly*
14 replies
So I'm trying to import this as some example data in OR to play with
{
"Actors": [
{
"name": "Tom Cruise",
"age": 56,
"Born At": "Syracuse, NY",
"Birthdate": "July 3, 1962",
"photo": "https://jsonformatter.org/img/tom-cruise.jpg",
"wife": null,
"weight": 67.5,
"hasChildren": true,
"hasGreyHair": false,
"children": [
"Suri",
"Isabella Jane",
"Connor"
]
},
{
"name": "Robert Downey Jr.",
"age": 53,
"Born At": "New York City, NY",
"Birthdate": "April 4, 1965",
"photo": "https://jsonformatter.org/img/Robert-Downey-Jr.jpg",
"wife": "Susan Downey",
"weight": 77.1,
"hasChildren": true,
"hasGreyHair": false,
"children": [
"Indio Falconer",
"Avri Roel",
"Exton Elias"
]
}
]
}
But it comes out like this (JSON), how can I make OR fill in the rows of the children with the rest of the information, or at least group the children in a single row like the 'hierarchical data' format?
2 replies
e.g. records mode
Ah, I think just by clickins the records mode it does it, but the only difference is that it changes the color of the records, the rows still remain empty
