create account

Visualising data for @photocontests - week 02/04/18-08/04/18 by rimicane

View this thread on: hive.blogpeakd.comecency.com
· @rimicane · (edited)
$2.29
Visualising data for @photocontests - week 02/04/18-08/04/18
<center>🔗 *click on visuals for full screen view*</center>

## <center>📉 `1597` Unique Participants all Week</center>
## <center> 📈 `3679` Entries all Week</center>

## <center>Number of Posts and Participants per Tag</center>

| <center>#tag </center>      | Number of Posts        | Number of Participants  | Weekly Changes, % |
| ------------- |:-------------:| :-----:|  -----:|
| #foodphotography    | <center>244</center> | <center>224</center> | <center>-12.2 %</center> |
|  #animalphotography   |   <center>265</center>    |  <center>242</center>  | <center>-15.6 %</center> |
| #landscapephotography |  <center>342</center>    |  <center>295</center>   | <center>-9.3 %</center> |
|  #cityscapephotography     | <center>179</center> | <center>161</center> | <center>-6.3 %</center> |
|  #architecturalphotography   | <center>225</center> | <center>205</center> | <center>-10.4 %</center> |
| #vehiclephotography    |   <center>179</center>    |  <center>167</center>  | <center>-17.5 %</center> |
| #macrophotography  |   <center>324</center>   |   <center>274</center>  | <center>`+8.4 %`</center> |
| #colourfulphotography      | <center>277</center> | <center>242</center> | <center>-7.4 %</center> |
| #streetphotography    |   <center>276</center>    |   <center>246</center> | <center>`+5.7 %`</center> |
| #portraitphotography |  <center>202</center>    |  <center>156</center>   | <center>-0.5 %</center> |
|  #sportsphotography   | <center>91</center> | <center>78</center> | <center>0 %</center> |
|  #smartphonephotography   |   <center>686</center>    |  <center>547</center>  | <center>-3.7 %</center> |
| #goldenhourphotography |   <center>309</center>   |  <center>276</center>   | <center>-24.1 %</center> |
| #longexposurephotography     | <center>80</center> | <center>76</center> | <center>-31.0 %</center> |

[![image.png](https://gateway.ipfs.io/ipfs/QmcwTsxvWLwXpSycGCK8Xycm3f5FwBFgJhb9rEbPw7mTCx)](https://gateway.ipfs.io/ipfs/QmcwTsxvWLwXpSycGCK8Xycm3f5FwBFgJhb9rEbPw7mTCx)


## <center> Number taking part in both Contests of the Day </center>
| <center>Day of the week </center>      |  Participants in both contests  |
| ------------- | -----:|
|<center> **Monday**</center>  | <center>53</center> | 
|  <center>**Tuesday**</center>   |   <center>66</center>    | 
|<center> **Wednesday**</center> |  <center>59</center>    |  
|  <center> **Thursday**</center>    | <center>67</center> | 
|   <center>**Friday**</center>    | <center>61</center> | 
|   <center>**Saturday**</center>    | <center>27</center> | 
|  <center>**Sunday**</center>    | <center>39</center> | 

[![image.png](https://gateway.ipfs.io/ipfs/QmREDgxcGBqUyvS47nfv55s3fUEfZ8kXLFXneFtYxs8pnV)](https://gateway.ipfs.io/ipfs/QmREDgxcGBqUyvS47nfv55s3fUEfZ8kXLFXneFtYxs8pnV)

## <center>Number of Participants each Day</center>
| <center>Day of the week </center>      |  Participants for the day  | Weekly Changes, % |
| ------------- | :-----:| -----:|
| <center>**Monday**</center>  | <center>413</center> | <center>-11.4 %</center> |
|  <center>**Tuesday**</center>   |   <center>390</center>    | <center>-9.3 %</center> |
| <center>**Wednesday**</center> |  <center>313</center>    |  <center>-13.5 %</center> |
|  <center> **Thursday**</center>    | <center>449</center> | <center>-2.8 %</center> |
|   <center>**Friday**</center>    | <center>341</center> | <center>-5.5 %</center> |
|  <center> **Saturday**</center>    | <center>598</center> | <center>0 %</center> |
|   <center>**Sunday**</center> | <center>313</center> | <center>-27.9 %</center> |

[![image.png](https://gateway.ipfs.io/ipfs/Qmc1o925xVEKpJBtXHZTC8Hq8DcCNGLM13UDvvqYgt3nK7)](https://gateway.ipfs.io/ipfs/Qmc1o925xVEKpJBtXHZTC8Hq8DcCNGLM13UDvvqYgt3nK7)

## <center>Histogram of Number of Posts every 15 minutes</center>

<hr>

The data represents the [CET (UTC+1)](https://www.timeanddate.com/worldclock/timezone/utc1), which is the official time for @photocontests!

<hr>

<center>**Monday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmRji77PbwsKz6utEJu5KhsnqPe78zsGEAKNpP3BrjD4R2)](https://gateway.ipfs.io/ipfs/QmRji77PbwsKz6utEJu5KhsnqPe78zsGEAKNpP3BrjD4R2)

<hr>

<center>**Tuesday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmP9vgjnEyp6pdGxYqgpbi4cN3sDAnMGTLSwzD5JyU46BF)](https://gateway.ipfs.io/ipfs/QmP9vgjnEyp6pdGxYqgpbi4cN3sDAnMGTLSwzD5JyU46BF)

<hr>

<center>**Wednesday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmYytsmEyFg52qbAXLnA2tT4nsDtq9NYgUK5KTrhyBMzKm)](https://gateway.ipfs.io/ipfs/QmYytsmEyFg52qbAXLnA2tT4nsDtq9NYgUK5KTrhyBMzKm)

<hr>

<center>**Thursday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmbDyQgKznnVHyFBa24iGYXbDeeyYVhybLGTg2AiM2oAcr)](https://gateway.ipfs.io/ipfs/QmbDyQgKznnVHyFBa24iGYXbDeeyYVhybLGTg2AiM2oAcr)

<hr>

<center>**Friday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmNnNEkt5Env3UEdc3VHm3ZcJKBiXJLg2n4WX6ALxLB3vx)](https://gateway.ipfs.io/ipfs/QmNnNEkt5Env3UEdc3VHm3ZcJKBiXJLg2n4WX6ALxLB3vx)

<hr>

<center>**Saturday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmbHisP9NSumKs3SmTobytheShNtoh1mAvo49oX27gea3J)](https://gateway.ipfs.io/ipfs/QmbHisP9NSumKs3SmTobytheShNtoh1mAvo49oX27gea3J)

<hr>

<center>**Sunday**</center>
[![image.png](https://gateway.ipfs.io/ipfs/QmQ2fvnpePLYw5oqmj7GZ3eBPoxQHihSv8kjvCXhHzU9xC)](https://gateway.ipfs.io/ipfs/QmQ2fvnpePLYw5oqmj7GZ3eBPoxQHihSv8kjvCXhHzU9xC)

<hr>

## <center>Background Info</center>
I have extracted the data using api.steemit.com and the following api call:
 
```python
payload = '{"id":4,"jsonrpc":"2.0","method":"call","params":["database_api","get_discussions_by_created", [{"tag":"' + tag + '","limit":100}]]}'
```
<br>
I am using **pandas library**. **Pandas** is an open source and is designed for **Python** users for data analysis and manipulation.
---
---
 
<center>
Monday: [**foodphotography**](https://steemit.com/created/foodphotography) and [**animalphotography**](https://steemit.com/created/animalphotography)
Tuesday: [**landscapephotography**](https://steemit.com/created/landscapephotography) and [**cityscapephotography**](https://steemit.com/created/cityscapephotography)
Wednesday: [**architecturalphotography**](https://steemit.com/created/architecturalphotography) and [**vehiclephotography**](https://steemit.com/created/vehiclephotography)
Thursday: [**macrophotography**](https://steemit.com/created/macrophotography) and [**colourfulphotography**](https://steemit.com/created/colourfulphotography)
Friday: [**streetphotography**](https://steemit.com/created/streetphotography) and [**portraitphotography**](https://steemit.com/created/portraitphotography)
Saturday: [**sportsphotography**](https://steemit.com/created/sportsphotography) and [**smartphonephotography**](https://steemit.com/created/smartphonephotography)
Sunday: [**goldenhourphotography**](https://steemit.com/created/goldenhourphotography) and [**longexposurephotography**](https://steemit.com/created/longexposurephotography)
</center>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authorrimicane
permlinkvisualising-data-for-photocontests-week-02-04-18-08-04-18
categorystats
json_metadata{"community":"busy","app":"steemit/0.1","format":"markdown","tags":["stats","photocontestsstats","mystats","python","busy"],"links":["https://gateway.ipfs.io/ipfs/QmcwTsxvWLwXpSycGCK8Xycm3f5FwBFgJhb9rEbPw7mTCx","https://gateway.ipfs.io/ipfs/QmREDgxcGBqUyvS47nfv55s3fUEfZ8kXLFXneFtYxs8pnV","https://gateway.ipfs.io/ipfs/Qmc1o925xVEKpJBtXHZTC8Hq8DcCNGLM13UDvvqYgt3nK7","https://www.timeanddate.com/worldclock/timezone/utc1","https://gateway.ipfs.io/ipfs/QmRji77PbwsKz6utEJu5KhsnqPe78zsGEAKNpP3BrjD4R2","https://gateway.ipfs.io/ipfs/QmP9vgjnEyp6pdGxYqgpbi4cN3sDAnMGTLSwzD5JyU46BF","https://gateway.ipfs.io/ipfs/QmYytsmEyFg52qbAXLnA2tT4nsDtq9NYgUK5KTrhyBMzKm","https://gateway.ipfs.io/ipfs/QmbDyQgKznnVHyFBa24iGYXbDeeyYVhybLGTg2AiM2oAcr","https://gateway.ipfs.io/ipfs/QmNnNEkt5Env3UEdc3VHm3ZcJKBiXJLg2n4WX6ALxLB3vx","https://gateway.ipfs.io/ipfs/QmbHisP9NSumKs3SmTobytheShNtoh1mAvo49oX27gea3J","https://gateway.ipfs.io/ipfs/QmQ2fvnpePLYw5oqmj7GZ3eBPoxQHihSv8kjvCXhHzU9xC","https://steemit.com/created/foodphotography","https://steemit.com/created/animalphotography","https://steemit.com/created/landscapephotography","https://steemit.com/created/cityscapephotography","https://steemit.com/created/architecturalphotography","https://steemit.com/created/vehiclephotography","https://steemit.com/created/macrophotography","https://steemit.com/created/colourfulphotography","https://steemit.com/created/streetphotography","https://steemit.com/created/portraitphotography","https://steemit.com/created/sportsphotography","https://steemit.com/created/smartphonephotography","https://steemit.com/created/goldenhourphotography","https://steemit.com/created/longexposurephotography"],"image":["https://gateway.ipfs.io/ipfs/QmcwTsxvWLwXpSycGCK8Xycm3f5FwBFgJhb9rEbPw7mTCx","https://gateway.ipfs.io/ipfs/QmREDgxcGBqUyvS47nfv55s3fUEfZ8kXLFXneFtYxs8pnV","https://gateway.ipfs.io/ipfs/Qmc1o925xVEKpJBtXHZTC8Hq8DcCNGLM13UDvvqYgt3nK7","https://gateway.ipfs.io/ipfs/QmRji77PbwsKz6utEJu5KhsnqPe78zsGEAKNpP3BrjD4R2","https://gateway.ipfs.io/ipfs/QmP9vgjnEyp6pdGxYqgpbi4cN3sDAnMGTLSwzD5JyU46BF","https://gateway.ipfs.io/ipfs/QmYytsmEyFg52qbAXLnA2tT4nsDtq9NYgUK5KTrhyBMzKm","https://gateway.ipfs.io/ipfs/QmbDyQgKznnVHyFBa24iGYXbDeeyYVhybLGTg2AiM2oAcr","https://gateway.ipfs.io/ipfs/QmNnNEkt5Env3UEdc3VHm3ZcJKBiXJLg2n4WX6ALxLB3vx","https://gateway.ipfs.io/ipfs/QmbHisP9NSumKs3SmTobytheShNtoh1mAvo49oX27gea3J","https://gateway.ipfs.io/ipfs/QmQ2fvnpePLYw5oqmj7GZ3eBPoxQHihSv8kjvCXhHzU9xC"],"users":["photocontests"]}
created2018-04-13 12:48:09
last_update2018-04-14 01:55:42
depth0
children6
last_payout2018-04-20 12:48:09
cashout_time1969-12-31 23:59:59
total_payout_value1.940 HBD
curator_payout_value0.347 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length6,976
author_reputation35,751,116,666,878
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id49,849,840
net_rshares477,086,483,728
author_curate_reward""
vote details (42)
@azyref ·
Great Post...and good record for Post Contest....thanks for sharing....
properties (22)
authorazyref
permlinkre-rimicane-visualising-data-for-photocontests-week-02-04-18-08-04-18-20180415t173301172z
categorystats
json_metadata{"tags":["stats"],"app":"steemit/0.1"}
created2018-04-15 17:33:51
last_update2018-04-15 17:33:51
depth1
children1
last_payout2018-04-22 17:33:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length71
author_reputation802,131,605,571
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id50,237,034
net_rshares0
@rimicane ·
You are welcome!
properties (22)
authorrimicane
permlinkre-azyref-re-rimicane-visualising-data-for-photocontests-week-02-04-18-08-04-18-20180416t215233099z
categorystats
json_metadata{"tags":["stats"],"app":"steemit/0.1"}
created2018-04-16 21:52:33
last_update2018-04-16 21:52:33
depth2
children0
last_payout2018-04-23 21:52:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length16
author_reputation35,751,116,666,878
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id50,453,307
net_rshares0
@hubbsteem ·
Nice .. thanks for the reports..
properties (22)
authorhubbsteem
permlinkre-rimicane-visualising-data-for-photocontests-week-02-04-18-08-04-18-20180413t141843448z
categorystats
json_metadata{"tags":["stats"],"app":"steemit/0.1"}
created2018-04-13 14:18:45
last_update2018-04-13 14:18:45
depth1
children1
last_payout2018-04-20 14:18:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length32
author_reputation131,218,704,515
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id49,863,280
net_rshares0
@rimicane ·
You are welcome!
properties (22)
authorrimicane
permlinkre-hubbsteem-re-rimicane-visualising-data-for-photocontests-week-02-04-18-08-04-18-20180414t015520489z
categorystats
json_metadata{"tags":["stats"],"app":"steemit/0.1"}
created2018-04-14 01:55:21
last_update2018-04-14 01:55:21
depth2
children0
last_payout2018-04-21 01:55:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length16
author_reputation35,751,116,666,878
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id49,944,126
net_rshares0
@minnowsupport ·
<p>Congratulations!  This post has been upvoted from the communal account, @minnowsupport, by rimicane from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows.  Please find us at the <a href="https://discord.gg/HYj4yvw"> Peace, Abundance, and Liberty Network (PALnet) Discord Channel</a>.  It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.</p> <p>If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: <a href="https://v2.steemconnect.com/sign/delegateVestingShares?delegator=&amp;delegatee=minnowsupport&amp;vesting_shares=102530.639667%20VESTS">50SP</a>, <a href="https://v2.steemconnect.com/sign/delegateVestingShares?delegator=&amp;delegatee=minnowsupport&amp;vesting_shares=205303.639667%20VESTS">100SP</a>, <a href="https://v2.steemconnect.com/sign/delegateVestingShares?delegator=&amp;delegatee=minnowsupport&amp;vesting_shares=514303.639667%20VESTS">250SP</a>, <a href="https://v2.steemconnect.com/sign/delegateVestingShares?delegator=&amp;delegatee=minnowsupport&amp;vesting_shares=1025303.639667%20VESTS">500SP</a>, <a href="https://v2.steemconnect.com/sign/delegateVestingShares?delegator=&amp;delegatee=minnowsupport&amp;vesting_shares=2053030.639667%20VESTS">1000SP</a>, <a href="https://v2.steemconnect.com/sign/delegateVestingShares?delegator=&amp;delegatee=minnowsupport&amp;vesting_shares=10253030.639667%20VESTS">5000SP</a>. <br><strong>Be sure to leave at least 50SP undelegated on your account.</strong></p>
properties (22)
authorminnowsupport
permlinkre-visualising-data-for-photocontests-week-02-04-18-08-04-18-20180414t015823
categorystats
json_metadata""
created2018-04-14 01:58:24
last_update2018-04-14 01:58:24
depth1
children0
last_payout2018-04-21 01:58:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,704
author_reputation148,902,805,319,183
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id49,944,435
net_rshares0
@rajskij-sad ·
Интересно наблюдать за графиками. 
properties (22)
authorrajskij-sad
permlinkre-rimicane-visualising-data-for-photocontests-week-02-04-18-08-04-18-20180414t182414440z
categorystats
json_metadata{"tags":["stats"],"community":"busy","app":"busy/2.4.0"}
created2018-04-14 18:24:27
last_update2018-04-14 18:24:27
depth1
children0
last_payout2018-04-21 18:24:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length34
author_reputation3,431,783,454,195
root_title"Visualising data for @photocontests - week 02/04/18-08/04/18"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id50,072,850
net_rshares0