Scenarios
Scenario 1: income vs sentiment
Median income joined with suburb tweet sentiment pooled to each Victorian SA2 (revival analysis). avg_* are NULL where an SA2 had no tweets.
page 13 of 19 CSV
| sa2_codeTEXT | sa2_nameTEXT | median_audREAL | mean_audREAL | vic_iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_incomeINTEGER | avg_incomeREAL |
|---|---|---|---|---|---|---|---|---|---|
| 212011287 | Beaconsfield - Officer | 47,375 | 51,603 | 1 | 1,546 | 5.4683053 | 2 | 72 | 5.2361111 |
| 212011288 | Bunyip - Garfield | 49,000 | 62,277 | 1 | 54 | 5.8148148 | 8 | 2 | 5 |
| 212011289 | Emerald - Cockatoo | 50,581 | 58,458 | 1 | 31 | 5.9032258 | 4 | 1 | 5 |
| 212011290 | Koo Wee Rup | 37,815 | 40,422 | 1 | 40 | 5.975 | 5 | 0 | null |
| 212011291 | Pakenham - North | 42,532 | 46,890 | 1 | 1,952 | 5.786373 | 1 | 66 | 5.9393939 |
| 212011292 | Pakenham - South | 49,513 | 68,147 | 1 | 0 | null | 0 | 0 | null |
| 212021293 | Berwick - North | 45,610 | 53,409 | 1 | 32 | 6.46875 | 1 | 0 | null |
| 212021294 | Berwick - South | 44,408 | 50,726 | 1 | 0 | null | 0 | 0 | null |
| 212021295 | Doveton | 46,429 | 51,830 | 1 | 17 | 5.4117647 | 2 | 0 | null |
| 212021297 | Hallam | 45,562 | 48,382 | 1 | 1 | 5 | 1 | 0 | null |
| 212021299 | Narre Warren North | 44,122 | 47,212 | 1 | 1 | 5 | 1 | 0 | null |
| 212021453 | Endeavour Hills - North | 49,991 | 53,035 | 1 | 1 | 3 | 1 | 0 | null |
| 212021454 | Endeavour Hills - South | 47,344 | 50,871 | 1 | 0 | null | 0 | 0 | null |
| 212021455 | Narre Warren - North East | 49,156 | 59,079 | 1 | 0 | null | 0 | 0 | null |
| 212021456 | Narre Warren - South West | 48,301 | 50,282 | 1 | 0 | null | 0 | 0 | null |
| 212031300 | Cranbourne | 43,352 | 45,537 | 1 | 73 | 6.5753425 | 1 | 3 | 6.3333333 |
| 212031301 | Cranbourne East | 49,927 | 54,456 | 1 | 2 | 8 | 1 | 1 | 8 |
| 212031302 | Cranbourne North | 46,393 | 54,312 | 1 | 0 | null | 0 | 0 | null |
| 212031303 | Cranbourne South | 47,372 | 56,948 | 1 | 22 | 6.2272727 | 2 | 0 | null |
| 212031304 | Cranbourne West | 46,568 | 51,744 | 1 | 0 | null | 0 | 0 | null |
| 212031305 | Hampton Park - Lynbrook | 44,289 | 50,894 | 1 | 0 | null | 0 | 0 | null |
| 212031306 | Lynbrook - Lyndhurst | 40,003 | 44,841 | 1 | 0 | null | 0 | 0 | null |
| 212031308 | Pearcedale - Tooradin | 36,587 | 41,195 | 1 | 89 | 5.2134831 | 5 | 2 | 9 |
| 212031457 | Narre Warren South (East) | 40,885 | 45,530 | 1 | 0 | null | 0 | 0 | null |
| 212031458 | Narre Warren South (West) | 47,779 | 57,114 | 1 | 0 | null | 0 | 0 | null |