query-8bb97c8b12a0dea91e0cb7faecf0ab7d
Missing Tamil Descriptions wikpedia article available in the Tamil Wikipedia 07:25, 11 September 2023 (UTC)) talk (SriveenkatI want to add missing American actress Tamil descriptions for Available Tamil Wikipedia Articles. Thank you 08:36, 19 September 2023 (UTC)) talk (Pere prlpz: I think I've never done that with Excel because I usually use R or sometimes Python for tasks like this one. If Excel worked for you, you can do the tutorial. However, there are already pages and videos on how to use QuiciStatements with Excel or Google Spreadsheets. Googling for it yields a handful of interesting resources.--Sriveenkat@ 03:45, 19 September 2023 (UTC)) talk (Sriveenkat. It's possible to create a tutorial video or article about Adding labels and descriptions using Spreadsheets and QuickStatements as your workflow? That's really useful for Beginners. Thanks again Done Thank you so much. Now America actresses Adding Tamil Description Adding is Pere prlpz@ 18:42, 17 September 2023 (UTC)) talk (Sriveenkat Thanks. I am very much obliged to you. Thanks again Pere prlpz@ 17:58, 17 September 2023 (UTC)) talk (Pere prlpzJust in case it may be useful, I leave here a query to get American actresses and their Tamil description.-- I wouldn't restrict that to only actresses with article in Tamil Wikipedia because it's not a lot of additional work to upload some thousands of descriptions instead of some hundreds. Paste the instructions to QuickStatements and run them. instructions to add the Tamil description to the remaining ones. I would do this part using R or Python instead of Excel because I'm used to them and have scripts for similar jobs, but a spreadsheet can have the work done quite easily.QuickStatementsImport the data to an spreadsheet (like Excel or LibreCalc), filter out actresses with Tamil description and create Using a query to get all American actresses, with their Tamil description if it exists, and export results in a csv file (or any other format).: PetScan (with SPARQL) can add properties but I think it can't add descriptions. Therefore I suggest: Sriveenkat@ 03:44, 17 September 2023 (UTC)) talk (Sriveenkat I want put automatically put the same tamil description Example: "American Actress" translate "அமெரிக்க நடிகை" Thanks. Pere prlpz@ 15:41, 16 September 2023 (UTC)) talk (Pere prlpzDo you need a query of all American actresses with Tamil Wikipedia article without Tamil language description to find those articles and write descriptions by hand? Or do you want to learn how to automatically put the same Tamil description (e.g. "American actress" in Tamil) in all those items?--
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?nameen ?nameta ?descr
WHERE {
?item wdt:P31 wd:Q5.
?item wdt:P27 wd:Q30.
?item wdt:P106/wdt:P297* wd:Q33999.
?item wdt:P21 wd:Q6581072.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?nameen.
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "ta" .
?item rdfs:label ?nameta.
?item schema:description ?descr.
}
}