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 10 of 19 CSV
| sa2_codeTEXT | sa2_nameTEXT | median_audREAL | mean_audREAL | vic_iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_incomeINTEGER | avg_incomeREAL |
|---|---|---|---|---|---|---|---|---|---|
| 209041433 | Epping - West | 52,329 | 58,809 | 1 | 0 | null | 0 | 0 | null |
| 209041435 | South Morang (North) | 49,561 | 63,481 | 1 | 0 | null | 0 | 0 | null |
| 209041436 | South Morang (South) | 48,332 | 58,596 | 1 | 0 | null | 0 | 0 | null |
| 209041437 | Wollert | 54,618 | 66,537 | 1 | 13 | 4.9230769 | 1 | 0 | null |
| 210011226 | Airport West | 55,979 | 74,103 | 1 | 5 | 8.8 | 1 | 2 | 9 |
| 210011227 | Essendon Airport | 52,218 | 66,530 | 1 | 0 | null | 0 | 0 | null |
| 210011228 | Keilor | 53,235 | 75,926 | 1 | 18 | 6.8888889 | 1 | 2 | 8.5 |
| 210011229 | Keilor East | 50,967 | 61,048 | 1 | 1 | 9 | 1 | 0 | null |
| 210011230 | Niddrie - Essendon West | 47,303 | 58,012 | 1 | 2 | 7 | 1 | 0 | null |
| 210011231 | Strathmore | 46,853 | 55,706 | 1 | 0 | null | 0 | 0 | null |
| 210021232 | Gisborne | 38,676 | 46,888 | 1 | 410 | 5.6560976 | 2 | 26 | 6.6153846 |
| 210021233 | Macedon | 51,901 | 60,036 | 1 | 175 | 6.1028571 | 1 | 8 | 6.875 |
| 210021234 | Riddells Creek | 43,078 | 48,891 | 1 | 10 | 5.5 | 1 | 0 | null |
| 210021235 | Romsey | 55,660 | 63,903 | 1 | 182 | 5.5714286 | 5 | 7 | 7.2857143 |
| 210031236 | Coburg North | 44,034 | 50,759 | 1 | 0 | null | 0 | 0 | null |
| 210031237 | Fawkner | 50,417 | 59,327 | 1 | 8 | 5.875 | 1 | 0 | null |
| 210031239 | Pascoe Vale | 50,267 | 57,266 | 1 | 8 | 5 | 1 | 0 | null |
| 210031438 | Glenroy | 35,954 | 39,778 | 1 | 0 | null | 0 | 0 | null |
| 210031439 | Gowanbrae | 35,759 | 40,884 | 1 | 0 | null | 0 | 0 | null |
| 210031440 | Hadfield | 46,951 | 52,529 | 1 | 0 | null | 0 | 0 | null |
| 210041240 | Sunbury | 49,193 | 59,687 | 1 | 2,399 | 5.4714464 | 2 | 55 | 6.2545455 |
| 210041241 | Sunbury - South | 36,400 | 40,621 | 1 | 120 | 5.7 | 1 | 2 | 6.5 |
| 210051242 | Broadmeadows | 41,216 | 54,253 | 1 | 1 | 4 | 1 | 0 | null |
| 210051243 | Campbellfield - Coolaroo | 40,691 | 46,364 | 1 | 331 | 5.4350453 | 2 | 4 | 6.25 |
| 210051245 | Gladstone Park - Westmeadows | 49,066 | 52,443 | 1 | 2 | 5 | 1 | 0 | null |