🔬 Dentro i TAG Italiani 🔪🔨 by alexzicky

View this thread on steempeak.com
· @alexzicky · (edited)
$5.51
🔬 Dentro i TAG Italiani 🔪🔨
![people-219985_640.jpg](https://steemitimages.com/DQmSSikTgnKi55vSTAjWgMBktP1jA6pnCWDZ549Vb71vtep/people-219985_640.jpg)|<center><h2>Dissezione dei TAG utilizzati negli articoli italiani</h2></center>
-|-

Qalche giorno fa @marcodobrovich scriveva sotto un mio [post:](https://busy.org/ita/@alexzicky/umytm-ita-steemit-evolution)

[![](https://steemitimages.com/DQmXrghT7BGHfT3JB7AXbGDYZb5Pw4Ao2gMpZrCP4W3iU6J/image.png)](https://busy.org/ita/@alexzicky/ita-steemit-evolution#@marcodobrovich/re-alexzicky-ita-steemit-evolution-20171031t223659947z)

e poi oggi:

[![](https://steemitimages.com/DQmZdcov6X3mgX446QqZP63JmzydGG87DCXYdLPRUEXxEnA/image.png)](https://busy.org/ita/@alexzicky/la-distribuzione-monetaria-dei-post#@marcodobrovich/re-alexzicky-la-distribuzione-monetaria-dei-post-20171110t075111322z)

Si! @marcodobrovich ci ho lavorato un pò su e queste sono le conclusioni alle quali sono arrivato!


## Che cosa vogliamo fare?
Vogliamo capire quali TAG sono più utilizzati nei post scritti in lingua italiana e quale sia la loro corrispondente retribuzione.

## Come raccogliere e rappresentare i dati?
Su Steemit sono permessi  **5 TAG** per articolo, iI primo è considerato il principale e prende anche il nome di **categoria**. Ora visto che siamo interessati solo agli articoli scritti nella nostra lingua uno di questi deve per forza essere **ITA**, ma quale?

A seconda di come estraiamo i dati otteniamo risultati differenti, quindi o deciso di eseguire un'interrogazione del **DB** per ogni posizione possibile.

Cosi ho raccolto in una tabella tutte le voci della **prima** posizione a condizione che uno degli altri fosse **ITA**, poi quelle della **seconda** posizione sempre a condizione che una delle altre corrispondesse a **ITA** e cosi fino alla **quinta** ottenendo tante voci come in tabella.

<center>[![](https://steemitimages.com/DQmdwGtZgYixxLnbRQ5mzzkvRCFRpZqD5oCSLXByCLpp8UU/image.png)](https://steemitimages.com/DQmdwGtZgYixxLnbRQ5mzzkvRCFRpZqD5oCSLXByCLpp8UU/image.png)</center>

Ordinando per le ricompense ricevute si ottiene:
<center>[![](https://steemitimages.com/DQmbXvnX13G2NN5xsHPtqfyx2ZdrSMRdCurY67TRVA5gJ3M/image.png)](https://steemitimages.com/DQmbXvnX13G2NN5xsHPtqfyx2ZdrSMRdCurY67TRVA5gJ3M/image.png)</center>

Mi fermo alle prime 23 selezioni dato che il primo Tag ne contiene quella quantità e per non complicare eccessivamente i grafici.

Mentre ordinando per utilizzo abbiamo:
<center>[![](https://steemitimages.com/DQmda3DKZeipLvAmyejENQQpkxBxw3P5z7y6d9om5rXz6c3/image.png)](https://steemitimages.com/DQmda3DKZeipLvAmyejENQQpkxBxw3P5z7y6d9om5rXz6c3/image.png)</center>

Mi incuriosisce la quasi totale assenza di parole italiane per descrivere gli articoli. Si utilizzano principalmente parole inglesi anche se l'articolo è di natura italiana. Che sia un'esca per acchiappare qualche balena anglofona?

## I grafici
#### 1° TAG
[![](https://steemitimages.com/DQmTBZBjeFsNTeLur7BLYRHk2Q1NfHPsaJA5whH8naeUXD6/image.png)](https://steemitimages.com/DQmTBZBjeFsNTeLur7BLYRHk2Q1NfHPsaJA5whH8naeUXD6/image.png)|[![](https://steemitimages.com/DQmdpraijA8XeybuRmrKdySkcYT6bKnmeuJYvnwf77956DH/image.png)](https://steemitimages.com/DQmdpraijA8XeybuRmrKdySkcYT6bKnmeuJYvnwf77956DH/image.png)
-|-
#### 2° TAG
[![](https://steemitimages.com/DQmS4McxAE8Y7hVzWm1HYWWF6tAVEQKjBqHytpkoLcStRKu/image.png)](https://steemitimages.com/DQmS4McxAE8Y7hVzWm1HYWWF6tAVEQKjBqHytpkoLcStRKu/image.png)|[![](https://steemitimages.com/DQmUS451SGu8kWaPj4qBE15cRcsX4ZohmEf5F7VNX48a2NH/image.png)](https://steemitimages.com/DQmUS451SGu8kWaPj4qBE15cRcsX4ZohmEf5F7VNX48a2NH/image.png)
-|-
#### 3° TAG
[![](https://steemitimages.com/DQmNMrzRsRPQbna7UV4zNygFbZ5cAev5Mh1hLhCjDDWu3AL/image.png)](https://steemitimages.com/DQmNMrzRsRPQbna7UV4zNygFbZ5cAev5Mh1hLhCjDDWu3AL/image.png)|[![](https://steemitimages.com/DQmYtqBCqPZwbi9M6K1suhGZ3h9yM9ZB1zQ1v6mvj8J62em/image.png)](https://steemitimages.com/DQmYtqBCqPZwbi9M6K1suhGZ3h9yM9ZB1zQ1v6mvj8J62em/image.png)
-|-
#### 4° TAG
[![](https://steemitimages.com/DQmTKorKHmxQA5qCmH5j1vYKwPZKEjXqUUwXJfzsEPvYWNL/image.png)](https://steemitimages.com/DQmTKorKHmxQA5qCmH5j1vYKwPZKEjXqUUwXJfzsEPvYWNL/image.png)|[![](https://steemitimages.com/DQmY3puGQ5xTkGneYVxCsosFNeWzQF7ohPPqsoLc5BDWfFy/image.png)](https://steemitimages.com/DQmY3puGQ5xTkGneYVxCsosFNeWzQF7ohPPqsoLc5BDWfFy/image.png)
-|-
#### 5° TAG

[![](https://steemitimages.com/DQmYH6Zm6weJ5rzCHf9BAbdESe1DtZhPKYh5dBkSP9DBHHM/image.png)](https://steemitimages.com/DQmYH6Zm6weJ5rzCHf9BAbdESe1DtZhPKYh5dBkSP9DBHHM/image.png)|[![](https://steemitimages.com/DQmWYPUQWMR31fZyiNMZ7bXpFCEUiKQAF16mycSDEZoyfib/image.png)](https://steemitimages.com/DQmWYPUQWMR31fZyiNMZ7bXpFCEUiKQAF16mycSDEZoyfib/image.png)
-|-

## Le Torte
A conclusione pubblico in formato torta il riassunto delle prime 10 voci della categoria maggiore la prima, che fanno sempre bella figura!

[![](https://steemitimages.com/DQmbsd4wh4LYHD1wuaMjhVPX7vNKw5sMhruWEVnXZvKhVXd/image.png)](https://steemitimages.com/DQmbsd4wh4LYHD1wuaMjhVPX7vNKw5sMhruWEVnXZvKhVXd/image.png)|[![](https://steemitimages.com/DQmUsdCJTMYvNWvpKT8yACxJ8DQzV1pwe9qUTmdrmqDHcVS/image.png)](https://steemitimages.com/DQmUsdCJTMYvNWvpKT8yACxJ8DQzV1pwe9qUTmdrmqDHcVS/image.png)
-|-

Per quanto riguarda i post premiati da @steempostitalia con l'iniziativa *'Podium'* vederei più opportuno che gli stessi curatori compilassero volta per volta una tabella con inserite le categorie ed i relativi premi in modo da avere la situazione aggiornata e non dover procedere manualmente alla ricerca dei premi vinti *(se non per quelli già passati)*. Se non erro @irikefee ha già trattato in modo eccellente l'argomento in [questo post](https://busy.org/podium/@irikefee/steem-postitalia-e-le-classifiche-nerd-dei-podium-di-ottobre-2017) che vi consiglio di leggere se non lo avete ancora fatto.

Altresì per l'estrazione automatica da **DB** non so se ho affrontato il problema nel modo opportuno, probabilmente ci sono alternative migliori. Mi sono limitato al solo mese di **luglio** di quest'anno in modo da analizzare le variazioni mese per mese ed eventualmente cambiare approccio se si rendesse necessario o se qualcuno ha suggerimenti per operare query più indicate.

#### Vi ringrazio per l'attenzione che mi avete concesso!

##### P.S.
Ho pensato che fosse interessante sommare tutte e 5 le ricorrenze delle singole voci e ho riportato il grafico risultante qui sotto.

[![](https://steemitimages.com/DQmR6QoWsB9ffDvkkSaejsqJrQ1Ct44D5jYLk7fVgTF91z4/image.png)](https://steemitimages.com/DQmR6QoWsB9ffDvkkSaejsqJrQ1Ct44D5jYLk7fVgTF91z4/image.png)
___

<center>

Scrivi nei commenti le tue osservazioni!
[![steemit_bar.png](https://steemitimages.com/DQmXnWeEUFhNgRoanPWZ7o1sqWfUyZhjEn2NPcBXg4KFc9t/steemit_bar.png)](https://steemit.com/@alexzicky)
Se ti è piaciuto il mio post  votami, seguimi e condividi!
___
-:¦:--:¦:--:¦:-<sub>first image from pixabay.com - CC0 Creative Commons</sub>-:¦:--:¦:--:¦:-
___
@AlexZicky - Upvote - Follow - Comment - Restreem

</center>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 84 others
properties (23)
post_id17,358,941
authoralexzicky
permlink-dentro-i-tag-italiani--1510336040-7295656
categoryita
json_metadata"{"format": "markdown", "links": ["https://busy.org/ita/@alexzicky/umytm-ita-steemit-evolution", "https://busy.org/ita/@alexzicky/ita-steemit-evolution#@marcodobrovich/re-alexzicky-ita-steemit-evolution-20171031t223659947z", "https://busy.org/ita/@alexzicky/la-distribuzione-monetaria-dei-post#@marcodobrovich/re-alexzicky-la-distribuzione-monetaria-dei-post-20171110t075111322z", "https://steemitimages.com/DQmdwGtZgYixxLnbRQ5mzzkvRCFRpZqD5oCSLXByCLpp8UU/image.png", "https://steemitimages.com/DQmbXvnX13G2NN5xsHPtqfyx2ZdrSMRdCurY67TRVA5gJ3M/image.png", "https://steemitimages.com/DQmda3DKZeipLvAmyejENQQpkxBxw3P5z7y6d9om5rXz6c3/image.png", "https://steemitimages.com/DQmTBZBjeFsNTeLur7BLYRHk2Q1NfHPsaJA5whH8naeUXD6/image.png", "https://steemitimages.com/DQmdpraijA8XeybuRmrKdySkcYT6bKnmeuJYvnwf77956DH/image.png", "https://steemitimages.com/DQmS4McxAE8Y7hVzWm1HYWWF6tAVEQKjBqHytpkoLcStRKu/image.png", "https://steemitimages.com/DQmUS451SGu8kWaPj4qBE15cRcsX4ZohmEf5F7VNX48a2NH/image.png", "https://steemitimages.com/DQmNMrzRsRPQbna7UV4zNygFbZ5cAev5Mh1hLhCjDDWu3AL/image.png", "https://steemitimages.com/DQmYtqBCqPZwbi9M6K1suhGZ3h9yM9ZB1zQ1v6mvj8J62em/image.png", "https://steemitimages.com/DQmTKorKHmxQA5qCmH5j1vYKwPZKEjXqUUwXJfzsEPvYWNL/image.png", "https://steemitimages.com/DQmY3puGQ5xTkGneYVxCsosFNeWzQF7ohPPqsoLc5BDWfFy/image.png", "https://steemitimages.com/DQmYH6Zm6weJ5rzCHf9BAbdESe1DtZhPKYh5dBkSP9DBHHM/image.png", "https://steemitimages.com/DQmWYPUQWMR31fZyiNMZ7bXpFCEUiKQAF16mycSDEZoyfib/image.png", "https://steemitimages.com/DQmbsd4wh4LYHD1wuaMjhVPX7vNKw5sMhruWEVnXZvKhVXd/image.png", "https://steemitimages.com/DQmUsdCJTMYvNWvpKT8yACxJ8DQzV1pwe9qUTmdrmqDHcVS/image.png", "https://busy.org/podium/@irikefee/steem-postitalia-e-le-classifiche-nerd-dei-podium-di-ottobre-2017", "https://steemitimages.com/DQmR6QoWsB9ffDvkkSaejsqJrQ1Ct44D5jYLk7fVgTF91z4/image.png", "https://steemit.com/@alexzicky"], "tags": ["ita", "steemit", "data", "progress", "stats"], "app": "steemit/0.1", "users": ["marcodobrovich", "steempostitalia", "irikefee", "alexzicky"], "image": ["https://steemitimages.com/DQmSSikTgnKi55vSTAjWgMBktP1jA6pnCWDZ549Vb71vtep/people-219985_640.jpg"]}"
created2017-11-11 00:03:00
last_update2017-11-11 14:38:18
depth0
children4
net_rshares2,622,194,097,324
last_payout2017-11-18 00:03:00
cashout_time1969-12-31 23:59:59
total_payout_value4.375 SBD
curator_payout_value1.130 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length7,002
author_reputation9,598,916,685,984
root_title"🔬 Dentro i TAG Italiani 🔪🔨"
beneficiaries[]
max_accepted_payout1,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (148)
@steemitboard ·
Congratulations @alexzicky! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png)](http://steemitboard.com/@alexzicky) Award for the number of upvotes received

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click [here](https://steemit.com/@steemitboard)

If you no longer want to receive notifications, reply to this comment with the word `STOP`

> By upvoting this notification, you can help all Steemit users. Learn how [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!
properties (22)
post_id17,368,860
authorsteemitboard
permlinksteemitboard-notify-alexzicky-20171111t033656000z
categoryita
json_metadata"{"image": ["https://steemitboard.com/img/notifications.png"]}"
created2017-11-11 03:36:54
last_update2017-11-11 03:36:54
depth1
children0
net_rshares0
last_payout2017-11-18 03:36:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length697
author_reputation38,705,954,145,809
root_title"🔬 Dentro i TAG Italiani 🔪🔨"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@screenname ·
Re: 🔬 Dentro i TAG Italiani 🔪🔨
<p>This post has been ranked within the top 25 most undervalued posts in the first half of Nov 11. We estimate that this post is undervalued by $19.14 as compared to a scenario in which every voter had an equal say.</p> 
<p>See the full rankings and details in <a href="https://steemit.com/curation/@screenname/the-daily-tribune-most-undervalued-posts-of-nov-11---part-i">The Daily Tribune: Nov 11 - Part I</a>. You can also read about some of our methodology, data analysis and technical details in <a href="https://steemit.com/curation/@screenname/introducing-the-daily-tribune-most-undervalued-posts-of-nov-04---part-i">our initial post</a>.</p>
<p>If you are the author and would prefer not to receive these comments, simply reply "Stop" to this comment.</p>
properties (22)
post_id17,401,625
authorscreenname
permlinkre--dentro-i-tag-italiani--1510336040-7295656-20171111t134122
categoryita
json_metadata"{"replyto": "@alexzicky/-dentro-i-tag-italiani--1510336040-7295656"}"
created2017-11-11 13:41:24
last_update2017-11-11 13:41:24
depth1
children0
net_rshares0
last_payout2017-11-18 13:41:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length763
author_reputation46,297,288,412,649
root_title"🔬 Dentro i TAG Italiani 🔪🔨"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@charlesx ·
Molto utile, grazie :)
properties (22)
post_id17,407,425
authorcharlesx
permlinkre-alexzicky--dentro-i-tag-italiani--1510336040-7295656-20171111t150258766z
categoryita
json_metadata"{"app": "steemit/0.1", "tags": ["ita"]}"
created2017-11-11 15:02:54
last_update2017-11-11 15:02:54
depth1
children0
net_rshares0
last_payout2017-11-18 15:02:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length22
author_reputation21,765,957,547,111
root_title"🔬 Dentro i TAG Italiani 🔪🔨"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@john-gpr ·
Molto interessante. 👍
properties (22)
post_id17,409,856
authorjohn-gpr
permlinkre-alexzicky--dentro-i-tag-italiani--1510336040-7295656-20171111t153648263z
categoryita
json_metadata"{"app": "steemit/0.1", "tags": ["ita"]}"
created2017-11-11 15:36:54
last_update2017-11-11 15:36:54
depth1
children0
net_rshares0
last_payout2017-11-18 15:36:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length21
author_reputation7,079,457,843,841
root_title"🔬 Dentro i TAG Italiani 🔪🔨"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000