Hot answers tagged

5

Try Tabernacle. Seems to be exactly what you search. The downloaded resultset is in TSV format, and can be imported in Excel. You'll need to have a Wikimedia account to work with Tabernacle and some other WMF wikis related tools.


2

DMOZ is a directory and naturally is great for tasks like this. You're going to have to do all of the leg work though: Search DMOZ for Australia + Hotel


2

I believe the limit is now 1000 with an API key. Try getting and adding an API key and changing the limit to 1000


2

You can also use OpenRefine for that. It can import roughly any tabular dataset and the latest version allows you to extend you data with Wikidata easily.


1

It's a bit strange that the same unique ID can be associated with more than one name. The database schema must have a design problem. One solution might be to clean up your 50,000 transactions one day by standardizing the names associated with the IDs. Software like Open Refine can help you to normalize your data.


1

You can do it using Wikidata SPARQL endpoint web UI. Paste the query below in the query form, press "Run", then press "Download". SELECT ?placeLabel ?coordinate ?countryLabel ?cityLabel WHERE { VALUES (?place) { (wd:Q243) (wd:Q41225) # ... } OPTIONAL { ?place wdt:P625 ?coordinate } OPTIONAL { ?place wdt:P17 ?country } OPTIONAL { ?...


1

I have personally found that using Perl and Spreadsheet::ParseExcel was relatively simple and useful for extracting data from Excel sheets. Another approach that may work is to upload into Google and use the Google APIs to extract the data.


1

Yes, it could be done but converting to CSV will not help you since data in your Excel files identified by coloring rows. I suggest to use software libraries that allow to parse Excel files and to write function that detects color of the row and extracts the data required. Or you could convert all files to CSV file and to use simple linux commands "sed/...


Only top voted, non community-wiki answers of a minimum length are eligible