Analyzing data

In [3]:
PETITIONS_URL = 'https://javiertorres.eu/owncloud/index.php/s/JAtADYK5B8tpisX/download'
In [4]:
import pandas
In [5]:
all_petitions = pandas.read_csv(PETITIONS_URL)
all_petitions
Out[5]:
id action E14000530 E14000531 E14000532 E14000533 E14000534 E14000535 E14000536 E14000537 ... W07000071 W07000072 W07000073 W07000074 W07000075 W07000076 W07000077 W07000078 W07000079 W07000080
0 131215 EU Referendum Rules triggering a 2nd EU Refere... 5283.0 2329.0 10022.0 2843.0 8844.0 2463.0 6263.0 3069.0 ... 2182.0 1752.0 3855.0 2527.0 4130.0 3641.0 2433.0 5703.0 7994.0 8144.0
1 171928 Prevent Donald Trump from making a State Visit... 2134.0 897.0 3393.0 1228.0 3482.0 1176.0 2492.0 1397.0 ... 878.0 766.0 1454.0 1040.0 1670.0 1418.0 996.0 2383.0 3656.0 3948.0
2 108072 Give the Meningitis B vaccine to ALL children,... 1625.0 1576.0 1599.0 1432.0 1462.0 1483.0 2933.0 1130.0 ... 705.0 704.0 872.0 854.0 1018.0 1129.0 1017.0 1237.0 1055.0 1152.0
3 114003 Block Donald J Trump from UK entry 749.0 300.0 1060.0 343.0 970.0 345.0 741.0 497.0 ... 217.0 190.0 383.0 262.0 392.0 356.0 278.0 592.0 936.0 1100.0
4 107516 Stop all immigration and close the UK borders ... 1010.0 878.0 464.0 995.0 516.0 1047.0 999.0 1000.0 ... 752.0 610.0 525.0 637.0 533.0 746.0 760.0 623.0 403.0 583.0
5 105991 Accept more asylum seekers and increase suppor... 462.0 182.0 932.0 226.0 741.0 220.0 518.0 345.0 ... 170.0 137.0 356.0 228.0 393.0 319.0 275.0 485.0 910.0 882.0
6 121152 Consider a vote of No Confidence in Jeremy Hun... 494.0 236.0 808.0 284.0 574.0 306.0 481.0 359.0 ... 203.0 189.0 327.0 240.0 317.0 283.0 266.0 384.0 568.0 626.0
7 178844 Donald Trump should make a State Visit to the ... 578.0 435.0 528.0 483.0 629.0 660.0 758.0 495.0 ... 276.0 280.0 370.0 298.0 392.0 434.0 319.0 484.0 301.0 401.0
8 104349 Make the production, sale and use of cannabis ... 440.0 234.0 340.0 266.0 312.0 325.0 352.0 327.0 ... 215.0 230.0 340.0 278.0 244.0 323.0 310.0 473.0 388.0 495.0
9 125692 Stop spending a fixed 0.7 per cent slice of ou... 461.0 349.0 479.0 356.0 577.0 400.0 540.0 335.0 ... 195.0 166.0 346.0 184.0 273.0 269.0 245.0 438.0 258.0 351.0
10 104334 To debate a vote of no confidence in Health Se... 312.0 140.0 625.0 220.0 354.0 248.0 293.0 242.0 ... 151.0 165.0 307.0 202.0 255.0 220.0 179.0 297.0 507.0 508.0
11 113064 Vote no on military action in Syria against IS... 172.0 75.0 357.0 94.0 264.0 104.0 182.0 298.0 ... 77.0 65.0 123.0 76.0 136.0 126.0 87.0 215.0 461.0 507.0
12 190627 Make online abuse a specific criminal offence ... 450.0 307.0 301.0 315.0 403.0 408.0 456.0 482.0 ... 356.0 340.0 296.0 335.0 352.0 399.0 356.0 356.0 365.0 453.0
13 116762 STOP CAMERON spending British taxpayers’ money... 471.0 289.0 285.0 360.0 593.0 389.0 629.0 266.0 ... 180.0 166.0 271.0 213.0 189.0 280.0 247.0 319.0 207.0 239.0
14 180642 Another Scottish independence referendum shoul... 136.0 69.0 117.0 83.0 146.0 71.0 141.0 72.0 ... 36.0 47.0 75.0 35.0 51.0 83.0 51.0 112.0 58.0 82.0
15 106477 Stop allowing immigrants into the UK. 438.0 386.0 237.0 438.0 258.0 527.0 472.0 373.0 ... 199.0 243.0 229.0 189.0 174.0 285.0 242.0 236.0 163.0 234.0
16 173199 Repeal the new Surveillance laws (Investigator... 379.0 141.0 325.0 177.0 311.0 217.0 320.0 224.0 ... 150.0 146.0 242.0 188.0 245.0 230.0 188.0 277.0 331.0 451.0
17 129698 No more school penalty fines and bring back th... 427.0 403.0 406.0 546.0 329.0 762.0 344.0 752.0 ... 53.0 53.0 73.0 51.0 65.0 55.0 37.0 83.0 103.0 135.0
18 104471 Vote no confidence in David Cameron 267.0 152.0 232.0 231.0 244.0 285.0 310.0 327.0 ... 242.0 228.0 248.0 232.0 286.0 271.0 249.0 298.0 371.0 445.0
19 110776 Make fair transitional state pension arrangeme... 232.0 221.0 316.0 332.0 371.0 361.0 304.0 300.0 ... 144.0 131.0 259.0 162.0 224.0 259.0 186.0 300.0 247.0 270.0
20 113231 No UK airstrikes on Syria. 204.0 89.0 269.0 93.0 280.0 95.0 224.0 190.0 ... 76.0 71.0 130.0 100.0 136.0 116.0 95.0 197.0 365.0 456.0
21 166847 Put a max of £1200 on car insurance for 18-25 ... 320.0 261.0 354.0 238.0 192.0 268.0 243.0 517.0 ... 276.0 238.0 172.0 192.0 305.0 308.0 289.0 334.0 201.0 291.0
22 122946 Hold a General Election in 2016 230.0 140.0 258.0 209.0 232.0 234.0 231.0 282.0 ... 169.0 173.0 233.0 213.0 264.0 239.0 198.0 274.0 317.0 394.0
23 168663 Ban the sale of fireworks to the public and on... 200.0 194.0 167.0 246.0 221.0 294.0 372.0 210.0 ... 369.0 278.0 414.0 325.0 366.0 477.0 323.0 450.0 345.0 408.0
24 182953 Change the University fees from £9250 back to ... 160.0 175.0 366.0 115.0 138.0 76.0 175.0 215.0 ... 23.0 30.0 39.0 24.0 49.0 40.0 30.0 42.0 98.0 123.0
25 113491 Keep the NHS Bursary 263.0 171.0 242.0 154.0 201.0 165.0 283.0 284.0 ... 133.0 148.0 208.0 139.0 190.0 159.0 148.0 201.0 190.0 259.0
26 124747 Hold a public inquiry and a referendum over tu... 278.0 139.0 329.0 193.0 442.0 178.0 206.0 184.0 ... 29.0 30.0 57.0 46.0 76.0 65.0 45.0 94.0 131.0 165.0
27 106651 Introduce a tax on sugary drinks in the UK to ... 265.0 132.0 297.0 153.0 408.0 124.0 297.0 84.0 ... 61.0 45.0 133.0 84.0 103.0 113.0 66.0 205.0 235.0 243.0
28 126128 Call on David Cameron to act to protect our st... 145.0 117.0 207.0 162.0 209.0 180.0 154.0 207.0 ... 411.0 575.0 1310.0 911.0 489.0 545.0 646.0 548.0 699.0 746.0
29 129823 Make it illegal for a company to require women... 267.0 99.0 243.0 119.0 253.0 105.0 216.0 130.0 ... 68.0 77.0 117.0 82.0 122.0 120.0 87.0 160.0 241.0 267.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
31701 121256 That MPs salary should be a fixed at three tim... 1.0 1.0 1.0 1.0 NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31702 183871 All Referendums should be fought on the Parlia... 1.0 1.0 1.0 NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31703 179488 Welcome President Trump unconditionally to the... 0.0 2.0 NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31704 182443 Raise the Interest Rate as Inflation is gettin... 1.0 1.0 NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31705 162062 Ban Religious Schools & religion-based schooli... 1.0 1.0 NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31706 160959 Parliament should not get a Summer holiday for... 1.0 1.0 NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31707 160642 Hold a General Election before the end of 2016. 1.0 1.0 NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31708 151985 Ban Harry Kane, Raheem Sterling and Jordan Hen... 1.0 1.0 NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31709 148792 Give vote to EU citizens in referendums in the UK 2.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31710 130363 I want to start a petition to ban Azealia Bank... 2.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31711 179863 Close down the E-Petition website as it clearl... 0.0 1.0 0.0 NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31712 164298 Get our government to make Darts an Olympic Sport 1.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31713 160674 for parliament to be dissolved and a general e... 1.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31714 160655 Petition for an emergency General Election 1.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31715 147140 Change the Fixed-Term Parliaments Act, to hold... 1.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31716 141207 to block the 2nd eu referendum NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31717 132406 Please ban 'Business Energy Solutions' and all... 1.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31718 123965 Take down the disrespectnobody advert issued b... 1.0 NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31719 162558 Lessen the role of religion in Parliament and ... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31720 160676 Hold a general election upon the resignation o... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31721 155959 The Next England Football Manager Has To Be En... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31722 147385 Activate Article 50 of the Lisbon Treaty NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31723 146514 Change the Fixed-Term Parliaments Act, to hold... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31724 136503 Repeat the EU Referendum with Lowering the Vot... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31725 133985 Call an immediate general election following t... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31726 133984 Call an immediate general election following t... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31727 130004 Block Azealia Banks from UK Entry NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31728 129111 Allow Ken Livingstone and Naz Shah back into t... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31729 109256 This is a test NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31730 105827 Close loop hole allowing Ltd companies to rip ... NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

31731 rows × 652 columns

In [6]:
# Add a new column, total of supporters
all_petitions['sum'] = all_petitions.loc[:,all_petitions.columns[2:]].sum(axis=1)

# Sort the dataset by that column, keep the top 100
top_petitions = all_petitions.sort_values('sum', ascending=False)[:100]
top_petitions
Out[6]:
id action E14000530 E14000531 E14000532 E14000533 E14000534 E14000535 E14000536 E14000537 ... W07000072 W07000073 W07000074 W07000075 W07000076 W07000077 W07000078 W07000079 W07000080 sum
0 131215 EU Referendum Rules triggering a 2nd EU Refere... 5283.0 2329.0 10022.0 2843.0 8844.0 2463.0 6263.0 3069.0 ... 1752.0 3855.0 2527.0 4130.0 3641.0 2433.0 5703.0 7994.0 8144.0 3909222.0
1 171928 Prevent Donald Trump from making a State Visit... 2134.0 897.0 3393.0 1228.0 3482.0 1176.0 2492.0 1397.0 ... 766.0 1454.0 1040.0 1670.0 1418.0 996.0 2383.0 3656.0 3948.0 1791600.0
2 108072 Give the Meningitis B vaccine to ALL children,... 1625.0 1576.0 1599.0 1432.0 1462.0 1483.0 2933.0 1130.0 ... 704.0 872.0 854.0 1018.0 1129.0 1017.0 1237.0 1055.0 1152.0 801922.0
3 114003 Block Donald J Trump from UK entry 749.0 300.0 1060.0 343.0 970.0 345.0 741.0 497.0 ... 190.0 383.0 262.0 392.0 356.0 278.0 592.0 936.0 1100.0 561192.0
4 107516 Stop all immigration and close the UK borders ... 1010.0 878.0 464.0 995.0 516.0 1047.0 999.0 1000.0 ... 610.0 525.0 637.0 533.0 746.0 760.0 623.0 403.0 583.0 449944.0
5 105991 Accept more asylum seekers and increase suppor... 462.0 182.0 932.0 226.0 741.0 220.0 518.0 345.0 ... 137.0 356.0 228.0 393.0 319.0 275.0 485.0 910.0 882.0 435561.0
6 121152 Consider a vote of No Confidence in Jeremy Hun... 494.0 236.0 808.0 284.0 574.0 306.0 481.0 359.0 ... 189.0 327.0 240.0 317.0 283.0 266.0 384.0 568.0 626.0 331194.0
7 178844 Donald Trump should make a State Visit to the ... 578.0 435.0 528.0 483.0 629.0 660.0 758.0 495.0 ... 280.0 370.0 298.0 392.0 434.0 319.0 484.0 301.0 401.0 309427.0
8 104349 Make the production, sale and use of cannabis ... 440.0 234.0 340.0 266.0 312.0 325.0 352.0 327.0 ... 230.0 340.0 278.0 244.0 323.0 310.0 473.0 388.0 495.0 230962.0
9 125692 Stop spending a fixed 0.7 per cent slice of ou... 461.0 349.0 479.0 356.0 577.0 400.0 540.0 335.0 ... 166.0 346.0 184.0 273.0 269.0 245.0 438.0 258.0 351.0 229374.0
10 104334 To debate a vote of no confidence in Health Se... 312.0 140.0 625.0 220.0 354.0 248.0 293.0 242.0 ... 165.0 307.0 202.0 255.0 220.0 179.0 297.0 507.0 508.0 225944.0
11 113064 Vote no on military action in Syria against IS... 172.0 75.0 357.0 94.0 264.0 104.0 182.0 298.0 ... 65.0 123.0 76.0 136.0 126.0 87.0 215.0 461.0 507.0 222648.0
12 190627 Make online abuse a specific criminal offence ... 450.0 307.0 301.0 315.0 403.0 408.0 456.0 482.0 ... 340.0 296.0 335.0 352.0 399.0 356.0 356.0 365.0 453.0 217706.0
13 116762 STOP CAMERON spending British taxpayers’ money... 471.0 289.0 285.0 360.0 593.0 389.0 629.0 266.0 ... 166.0 271.0 213.0 189.0 280.0 247.0 319.0 207.0 239.0 216847.0
14 180642 Another Scottish independence referendum shoul... 136.0 69.0 117.0 83.0 146.0 71.0 141.0 72.0 ... 47.0 75.0 35.0 51.0 83.0 51.0 112.0 58.0 82.0 214510.0
16 173199 Repeal the new Surveillance laws (Investigator... 379.0 141.0 325.0 177.0 311.0 217.0 320.0 224.0 ... 146.0 242.0 188.0 245.0 230.0 188.0 277.0 331.0 451.0 208284.0
17 129698 No more school penalty fines and bring back th... 427.0 403.0 406.0 546.0 329.0 762.0 344.0 752.0 ... 53.0 73.0 51.0 65.0 55.0 37.0 83.0 103.0 135.0 200688.0
15 106477 Stop allowing immigrants into the UK. 438.0 386.0 237.0 438.0 258.0 527.0 472.0 373.0 ... 243.0 229.0 189.0 174.0 285.0 242.0 236.0 163.0 234.0 199130.0
18 104471 Vote no confidence in David Cameron 267.0 152.0 232.0 231.0 244.0 285.0 310.0 327.0 ... 228.0 248.0 232.0 286.0 271.0 249.0 298.0 371.0 445.0 194372.0
19 110776 Make fair transitional state pension arrangeme... 232.0 221.0 316.0 332.0 371.0 361.0 304.0 300.0 ... 131.0 259.0 162.0 224.0 259.0 186.0 300.0 247.0 270.0 187351.0
20 113231 No UK airstrikes on Syria. 204.0 89.0 269.0 93.0 280.0 95.0 224.0 190.0 ... 71.0 130.0 100.0 136.0 116.0 95.0 197.0 365.0 456.0 185510.0
21 166847 Put a max of £1200 on car insurance for 18-25 ... 320.0 261.0 354.0 238.0 192.0 268.0 243.0 517.0 ... 238.0 172.0 192.0 305.0 308.0 289.0 334.0 201.0 291.0 183960.0
22 122946 Hold a General Election in 2016 230.0 140.0 258.0 209.0 232.0 234.0 231.0 282.0 ... 173.0 233.0 213.0 264.0 239.0 198.0 274.0 317.0 394.0 172859.0
24 182953 Change the University fees from £9250 back to ... 160.0 175.0 366.0 115.0 138.0 76.0 175.0 215.0 ... 30.0 39.0 24.0 49.0 40.0 30.0 42.0 98.0 123.0 162254.0
23 168663 Ban the sale of fireworks to the public and on... 200.0 194.0 167.0 246.0 221.0 294.0 372.0 210.0 ... 278.0 414.0 325.0 366.0 477.0 323.0 450.0 345.0 408.0 161294.0
25 113491 Keep the NHS Bursary 263.0 171.0 242.0 154.0 201.0 165.0 283.0 284.0 ... 148.0 208.0 139.0 190.0 159.0 148.0 201.0 190.0 259.0 158870.0
26 124747 Hold a public inquiry and a referendum over tu... 278.0 139.0 329.0 193.0 442.0 178.0 206.0 184.0 ... 30.0 57.0 46.0 76.0 65.0 45.0 94.0 131.0 165.0 152558.0
28 126128 Call on David Cameron to act to protect our st... 145.0 117.0 207.0 162.0 209.0 180.0 154.0 207.0 ... 575.0 1310.0 911.0 489.0 545.0 646.0 548.0 699.0 746.0 150719.0
27 106651 Introduce a tax on sugary drinks in the UK to ... 265.0 132.0 297.0 153.0 408.0 124.0 297.0 84.0 ... 45.0 133.0 84.0 103.0 113.0 66.0 205.0 235.0 243.0 148056.0
30 124702 Scrap plans to force state schools to become a... 244.0 145.0 330.0 220.0 386.0 180.0 188.0 208.0 ... 29.0 55.0 46.0 58.0 53.0 49.0 86.0 134.0 108.0 147496.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
70 125604 Save the Human Rights Act 119.0 32.0 109.0 73.0 135.0 68.0 86.0 96.0 ... 45.0 72.0 62.0 94.0 92.0 56.0 101.0 191.0 203.0 79035.0
71 119416 Make it illegal for any UK political figure to... 94.0 39.0 161.0 65.0 148.0 52.0 127.0 71.0 ... 26.0 81.0 62.0 106.0 121.0 57.0 95.0 212.0 240.0 75273.0
72 128710 Lower university fees down to £3,000 104.0 86.0 69.0 49.0 70.0 46.0 140.0 83.0 ... 10.0 13.0 9.0 21.0 21.0 6.0 19.0 31.0 51.0 70941.0
73 170740 Suspend the Myanmar Ambassador for Genocide of... 30.0 21.0 164.0 4.0 6.0 6.0 19.0 137.0 ... 8.0 85.0 112.0 NaN NaN NaN NaN NaN NaN 70076.0
74 104379 Introduce Compulsory Scanning for microchips b... 133.0 111.0 70.0 109.0 195.0 153.0 164.0 78.0 ... 76.0 85.0 79.0 97.0 116.0 81.0 133.0 85.0 94.0 69301.0
75 122038 Cancel the end of Key Stage 2 SATs tests for 2016 90.0 116.0 128.0 126.0 172.0 144.0 87.0 103.0 ... 10.0 NaN NaN NaN NaN NaN NaN NaN NaN 69068.0
76 116943 Stop cuts to pharmacy funding and support phar... 85.0 75.0 178.0 84.0 107.0 67.0 112.0 84.0 ... 29.0 72.0 48.0 52.0 71.0 50.0 58.0 85.0 85.0 66612.0
78 120950 Stop car insurance companies ripping under 25s... 83.0 142.0 93.0 118.0 83.0 129.0 153.0 130.0 ... 150.0 83.0 90.0 121.0 150.0 122.0 171.0 100.0 156.0 63336.0
79 168391 Make tampons and sanitary towels free for females 125.0 59.0 80.0 63.0 90.0 76.0 91.0 74.0 ... 22.0 65.0 65.0 78.0 60.0 34.0 94.0 80.0 105.0 63218.0
77 117658 Start aid drops to the starving people of Syria 21.0 22.0 203.0 14.0 53.0 14.0 59.0 105.0 ... 9.0 30.0 9.0 22.0 23.0 14.0 35.0 119.0 204.0 63047.0
81 118690 Prevent the closure of Huddersfield A&E depart... 22.0 9.0 39.0 19.0 29.0 24.0 26.0 55.0 ... 13.0 15.0 12.0 10.0 12.0 6.0 17.0 13.0 15.0 62327.0
80 178330 Make the uk armed forces pensions for 22 years... 659.0 45.0 35.0 70.0 45.0 86.0 174.0 68.0 ... 50.0 108.0 104.0 56.0 91.0 71.0 215.0 48.0 70.0 61694.0
83 104880 Reverse the planned tax relief restriction on ... 106.0 32.0 160.0 25.0 137.0 31.0 104.0 31.0 ... 10.0 52.0 18.0 45.0 70.0 41.0 69.0 113.0 108.0 59432.0
82 123450 Cancel the planned referendum on Britain's con... 92.0 25.0 104.0 22.0 137.0 52.0 74.0 22.0 ... 14.0 38.0 23.0 51.0 47.0 34.0 75.0 131.0 133.0 58553.0
84 121888 Stop plans to make it a criminal offence to no... 89.0 92.0 78.0 65.0 73.0 69.0 164.0 84.0 ... 24.0 54.0 43.0 71.0 50.0 32.0 61.0 97.0 92.0 57372.0
86 105450 Introduce minimum prices that milk buyers purc... 51.0 22.0 68.0 61.0 134.0 54.0 86.0 33.0 ... 18.0 36.0 39.0 37.0 49.0 30.0 85.0 56.0 73.0 57068.0
85 106525 Reconsider the new Dividend Tax for small busi... 117.0 40.0 239.0 70.0 136.0 58.0 108.0 42.0 ... 10.0 45.0 26.0 41.0 36.0 11.0 51.0 81.0 66.0 57056.0
87 119876 Keep Performing Arts as an Option for GCSE/A L... 100.0 58.0 79.0 51.0 84.0 63.0 90.0 62.0 ... 22.0 82.0 27.0 46.0 60.0 35.0 73.0 69.0 85.0 56172.0
88 114073 Free childcare for 2 year olds to include pare... 103.0 102.0 143.0 73.0 36.0 165.0 68.0 240.0 ... 7.0 30.0 13.0 26.0 39.0 60.0 29.0 15.0 30.0 55803.0
89 185827 Ensure the British fishing waters are returned... 102.0 63.0 60.0 88.0 128.0 109.0 135.0 68.0 ... 56.0 81.0 73.0 63.0 79.0 53.0 104.0 42.0 63.0 55652.0
90 106992 David Cameron to take serious diplomatic actio... 82.0 40.0 77.0 75.0 180.0 56.0 77.0 48.0 ... 31.0 63.0 43.0 48.0 45.0 35.0 79.0 69.0 94.0 54353.0
92 117916 We demand GPs only decide who is fit to go bac... 65.0 38.0 47.0 74.0 65.0 118.0 68.0 120.0 ... 80.0 86.0 81.0 37.0 85.0 84.0 86.0 86.0 96.0 53775.0
91 160883 Close sharia courts set up in the uk and make ... 129.0 67.0 98.0 78.0 75.0 102.0 122.0 97.0 ... 63.0 72.0 47.0 66.0 89.0 71.0 85.0 51.0 88.0 52921.0
94 130519 Drop the plans to INCREASE tuition fees furthe... 90.0 59.0 102.0 61.0 98.0 52.0 99.0 106.0 ... 31.0 33.0 24.0 27.0 39.0 56.0 42.0 NaN NaN 52695.0
93 178082 Ringfence the NHS from trade deals 66.0 32.0 82.0 48.0 99.0 41.0 67.0 58.0 ... 38.0 55.0 51.0 65.0 57.0 44.0 70.0 133.0 164.0 52634.0
95 150516 Make Eid a National Holiday 20.0 12.0 68.0 2.0 5.0 6.0 33.0 75.0 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN 51597.0
96 131348 Increase the maximum sentence for animal cruel... 74.0 70.0 57.0 919.0 72.0 325.0 98.0 83.0 ... 86.0 75.0 66.0 77.0 113.0 91.0 89.0 58.0 92.0 51128.0
98 104545 Introduce mental health education to the natio... 66.0 39.0 96.0 60.0 85.0 55.0 91.0 61.0 ... 38.0 54.0 30.0 48.0 73.0 61.0 72.0 71.0 83.0 50314.0
97 161635 Call on Andrea Leadsom to NOT hold a vote to r... 82.0 51.0 78.0 103.0 134.0 91.0 109.0 70.0 ... 56.0 79.0 71.0 84.0 76.0 49.0 99.0 75.0 80.0 49824.0
99 111441 Reform the rules on filibustering or 'talking ... 69.0 33.0 64.0 68.0 102.0 46.0 70.0 50.0 ... 28.0 49.0 30.0 48.0 37.0 46.0 59.0 90.0 102.0 49586.0

100 rows × 653 columns

In [7]:
# Find the correlation
top_petitions.corr()
Out[7]:
id E14000530 E14000531 E14000532 E14000533 E14000534 E14000535 E14000536 E14000537 E14000538 ... W07000072 W07000073 W07000074 W07000075 W07000076 W07000077 W07000078 W07000079 W07000080 sum
id 1.000000 0.013948 -0.024539 -0.014687 -0.052936 -0.000811 -0.036877 -0.004576 0.003326 0.012637 ... 0.031616 0.002837 0.014302 0.034120 0.020033 0.004546 0.027678 0.008651 0.025288 0.004666
E14000530 0.013948 1.000000 0.931184 0.968398 0.929153 0.974182 0.918663 0.982618 0.962297 0.984657 ... 0.914337 0.936510 0.928037 0.969006 0.961883 0.941685 0.977256 0.957791 0.960426 0.980940
E14000531 -0.024539 0.931184 1.000000 0.858044 0.951443 0.863379 0.975640 0.960092 0.951882 0.892590 ... 0.917551 0.863631 0.898084 0.898556 0.922351 0.937393 0.889773 0.833678 0.842046 0.883754
E14000532 -0.014687 0.968398 0.858044 1.000000 0.871815 0.993954 0.835821 0.949224 0.923148 0.990893 ... 0.866650 0.938632 0.902203 0.969287 0.945125 0.899418 0.980133 0.986963 0.982978 0.990123
E14000533 -0.052936 0.929153 0.951443 0.871815 1.000000 0.882370 0.970203 0.941067 0.940026 0.899479 ... 0.904805 0.871408 0.892290 0.902190 0.917251 0.921122 0.899972 0.857266 0.862399 0.897083
E14000534 -0.000811 0.974182 0.863379 0.993954 0.882370 1.000000 0.848720 0.956132 0.922732 0.993118 ... 0.873264 0.940338 0.905886 0.970672 0.947840 0.903750 0.984158 0.987823 0.985067 0.992872
E14000535 -0.036877 0.918663 0.975640 0.835821 0.970203 0.848720 1.000000 0.935250 0.955529 0.874226 ... 0.906483 0.849908 0.882895 0.878265 0.901319 0.919289 0.873246 0.819351 0.829739 0.870814
E14000536 -0.004576 0.982618 0.960092 0.949224 0.941067 0.956132 0.935250 1.000000 0.954276 0.973215 ... 0.915012 0.923668 0.924323 0.958563 0.957569 0.945028 0.961875 0.934162 0.936628 0.963189
E14000537 0.003326 0.962297 0.951882 0.923148 0.940026 0.922732 0.955529 0.954276 1.000000 0.943486 ... 0.922253 0.905723 0.917289 0.938538 0.941687 0.940064 0.937030 0.911520 0.919208 0.946545
E14000538 0.012637 0.984657 0.892590 0.990893 0.899479 0.993118 0.874226 0.973215 0.943486 1.000000 ... 0.889170 0.941725 0.917023 0.974891 0.956049 0.920036 0.985878 0.983703 0.983620 0.995250
E14000539 0.000272 0.984165 0.884226 0.992008 0.898709 0.996307 0.870444 0.969152 0.938331 0.996790 ... 0.891846 0.946273 0.920082 0.978396 0.958369 0.921099 0.989166 0.988017 0.987009 0.995879
E14000540 0.087984 0.909947 0.823355 0.926665 0.825052 0.917648 0.802795 0.885799 0.912821 0.933588 ... 0.820091 0.862792 0.841138 0.905085 0.884756 0.850053 0.922744 0.934849 0.938307 0.936733
E14000541 -0.032030 0.931314 0.966347 0.864167 0.940890 0.870996 0.960148 0.941012 0.955552 0.892646 ... 0.948044 0.891547 0.927357 0.919252 0.939446 0.956882 0.907017 0.858735 0.869965 0.896595
E14000542 -0.034740 0.870673 0.953447 0.771139 0.921539 0.781221 0.959423 0.889082 0.921238 0.812468 ... 0.923463 0.825320 0.882534 0.847479 0.883580 0.923750 0.830404 0.765308 0.779436 0.816716
E14000543 0.005301 0.978334 0.914363 0.956438 0.918731 0.965182 0.912653 0.963070 0.955496 0.971490 ... 0.931866 0.949849 0.942797 0.977010 0.972302 0.953294 0.981109 0.962595 0.967564 0.976890
E14000544 0.005477 0.961806 0.984413 0.900242 0.964055 0.908833 0.973669 0.976562 0.968427 0.931641 ... 0.924297 0.892207 0.913305 0.927204 0.940581 0.945056 0.925882 0.882720 0.889910 0.925596
E14000545 -0.011866 0.991184 0.916356 0.983504 0.923154 0.986397 0.904236 0.980489 0.956142 0.992428 ... 0.905104 0.943073 0.925824 0.975354 0.961636 0.933764 0.983321 0.972448 0.972536 0.988998
E14000546 -0.017788 0.951574 0.970041 0.886891 0.960290 0.897164 0.981200 0.951987 0.974936 0.914874 ... 0.935324 0.898396 0.920548 0.924329 0.939371 0.947836 0.919786 0.873988 0.881280 0.915141
E14000547 -0.015769 0.950203 0.810688 0.988690 0.838992 0.989428 0.794433 0.923699 0.892401 0.980507 ... 0.842240 0.925987 0.883557 0.957358 0.925063 0.874781 0.971826 0.992166 0.988574 0.985929
E14000548 0.014387 0.903684 0.850044 0.903462 0.846280 0.898079 0.841253 0.893938 0.927724 0.922491 ... 0.833032 0.853547 0.845707 0.895875 0.882553 0.860340 0.902834 0.908237 0.914897 0.926962
E14000549 -0.003014 0.943506 0.792943 0.989712 0.824209 0.987001 0.775877 0.911412 0.881917 0.976737 ... 0.828677 0.920299 0.872619 0.950602 0.917204 0.860061 0.966601 0.988254 0.983181 0.980535
E14000550 0.001606 0.972589 0.864313 0.995952 0.877202 0.995507 0.842710 0.953513 0.921167 0.991973 ... 0.868983 0.937178 0.901567 0.967455 0.945957 0.900228 0.980714 0.982402 0.979562 0.989091
E14000551 0.007608 0.975429 0.869576 0.994100 0.881354 0.996144 0.848146 0.959519 0.925439 0.994251 ... 0.873364 0.937987 0.905356 0.970107 0.947091 0.904479 0.983725 0.988071 0.985742 0.993245
E14000552 0.020545 0.970172 0.859576 0.988171 0.875264 0.988811 0.845299 0.948446 0.935333 0.992086 ... 0.873598 0.932045 0.902560 0.967023 0.942645 0.903710 0.980284 0.989423 0.989656 0.994697
E14000553 0.001055 0.937962 0.785093 0.980420 0.817311 0.979454 0.773123 0.902920 0.883342 0.971770 ... 0.825919 0.912719 0.867136 0.944466 0.909449 0.855477 0.960728 0.988437 0.985610 0.980493
E14000554 0.007103 0.976310 0.909429 0.961720 0.920546 0.974390 0.906767 0.967016 0.948999 0.977412 ... 0.916902 0.942946 0.930245 0.971661 0.965030 0.939912 0.980237 0.965056 0.966985 0.982629
E14000555 0.021964 0.883942 0.723004 0.936648 0.756564 0.932741 0.712386 0.847352 0.847229 0.934082 ... 0.767566 0.860587 0.814357 0.900692 0.860342 0.805035 0.919548 0.962694 0.962683 0.944623
E14000556 -0.011231 0.985948 0.929069 0.970677 0.935143 0.979797 0.924200 0.978755 0.960682 0.984065 ... 0.915451 0.943612 0.931109 0.972821 0.964968 0.941349 0.980018 0.963141 0.964024 0.983841
E14000557 -0.002896 0.984606 0.902571 0.984769 0.912210 0.994097 0.890181 0.975788 0.943330 0.993552 ... 0.896352 0.943698 0.919390 0.974068 0.958910 0.925758 0.985080 0.977090 0.976826 0.991556
E14000558 0.025933 0.969519 0.970529 0.924519 0.942843 0.930369 0.945160 0.984206 0.962169 0.951979 ... 0.916378 0.905017 0.914763 0.941105 0.945543 0.939844 0.944944 0.912077 0.916623 0.945257
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
W07000052 0.032252 0.916583 0.907431 0.874611 0.897601 0.877625 0.894460 0.908472 0.926533 0.892093 ... 0.990444 0.950829 0.980746 0.958818 0.976982 0.984172 0.939505 0.896449 0.909476 0.900437
W07000053 0.008441 0.946888 0.945993 0.901152 0.924992 0.907590 0.924203 0.958953 0.937682 0.927049 ... 0.984636 0.961640 0.983976 0.967267 0.982186 0.993487 0.956249 0.913551 0.920809 0.926174
W07000054 -0.001216 0.969777 0.860620 0.987841 0.881993 0.993445 0.847386 0.951570 0.920876 0.988715 ... 0.900804 0.961012 0.931806 0.983513 0.963734 0.925297 0.993096 0.995032 0.993683 0.992898
W07000055 0.014725 0.957277 0.917795 0.934641 0.911993 0.939707 0.901589 0.957325 0.944844 0.954426 ... 0.973972 0.979303 0.986254 0.983160 0.987286 0.984846 0.978074 0.952882 0.959566 0.956478
W07000056 0.004154 0.971705 0.899324 0.970634 0.903080 0.972885 0.881151 0.963486 0.940329 0.979194 ... 0.949746 0.983696 0.971124 0.993719 0.986719 0.967824 0.994810 0.981630 0.983990 0.981474
W07000057 0.001159 0.947415 0.820141 0.977217 0.842058 0.977501 0.803672 0.918433 0.901792 0.970940 ... 0.881956 0.942307 0.911896 0.974855 0.950144 0.903370 0.981114 0.991644 0.992105 0.980342
W07000058 0.016035 0.967770 0.871729 0.974871 0.886343 0.980421 0.857835 0.944961 0.928158 0.976827 ... 0.920980 0.959052 0.940961 0.989433 0.976855 0.939395 0.992718 0.983645 0.985758 0.982694
W07000059 0.013998 0.975417 0.896240 0.975516 0.904498 0.980389 0.879406 0.959732 0.939687 0.979901 ... 0.932938 0.962303 0.949312 0.993162 0.984811 0.951857 0.994819 0.979502 0.981515 0.983097
W07000060 0.007892 0.976068 0.927094 0.954110 0.924946 0.960849 0.913657 0.966146 0.955886 0.967378 ... 0.953836 0.957941 0.957677 0.987876 0.989186 0.969960 0.986094 0.959148 0.964726 0.971096
W07000061 0.023785 0.936915 0.842272 0.954113 0.851507 0.957561 0.818844 0.913402 0.896718 0.951224 ... 0.905788 0.943953 0.926818 0.978176 0.966547 0.920074 0.976838 0.969189 0.971810 0.959171
W07000062 0.011142 0.962870 0.922538 0.943199 0.913284 0.948699 0.901961 0.957638 0.944599 0.956158 ... 0.960255 0.957440 0.963910 0.987898 0.991451 0.973201 0.981119 0.954651 0.960669 0.961344
W07000063 0.016016 0.922386 0.831183 0.933032 0.844289 0.942548 0.814654 0.899278 0.884141 0.935799 ... 0.900288 0.930957 0.918374 0.966809 0.956456 0.911719 0.965898 0.958314 0.963225 0.947560
W07000064 0.003284 0.925627 0.803828 0.956477 0.827985 0.961551 0.787321 0.898018 0.878160 0.951758 ... 0.880008 0.938215 0.911560 0.969674 0.947831 0.898070 0.973226 0.981673 0.983892 0.964074
W07000065 0.012879 0.960563 0.870034 0.963982 0.884590 0.974262 0.856857 0.946180 0.919711 0.972017 ... 0.926048 0.961166 0.946646 0.987599 0.975852 0.942285 0.991299 0.983621 0.986707 0.978541
W07000066 0.020259 0.958269 0.864120 0.964322 0.877338 0.973597 0.852001 0.939929 0.918557 0.969094 ... 0.928795 0.967312 0.949649 0.988754 0.977290 0.944440 0.991699 0.982525 0.985541 0.976445
W07000067 0.014546 0.947046 0.858126 0.957108 0.873474 0.964138 0.846332 0.929672 0.910179 0.959462 ... 0.940492 0.980865 0.963613 0.987949 0.980288 0.951383 0.988647 0.977366 0.979565 0.967166
W07000068 0.007115 0.958280 0.846711 0.975634 0.868256 0.983492 0.835488 0.935087 0.911257 0.976064 ... 0.904252 0.960427 0.933151 0.981712 0.963629 0.923927 0.989703 0.991127 0.991059 0.984570
W07000069 0.014528 0.855127 0.814704 0.842841 0.814053 0.846643 0.802949 0.847178 0.846881 0.851770 ... 0.957702 0.973322 0.977622 0.919526 0.932079 0.949044 0.905842 0.878718 0.884169 0.860772
W07000070 0.046027 0.941147 0.900916 0.917189 0.898710 0.920717 0.887478 0.929595 0.934863 0.929072 ... 0.982681 0.967814 0.980195 0.981123 0.990360 0.984640 0.969946 0.936665 0.943860 0.936033
W07000071 0.028038 0.937720 0.922007 0.900016 0.917748 0.904063 0.908622 0.930657 0.938645 0.916988 ... 0.988252 0.956580 0.979766 0.970320 0.987340 0.988803 0.956631 0.915186 0.924201 0.923436
W07000072 0.031616 0.914337 0.917551 0.866650 0.904805 0.873264 0.906483 0.915012 0.922253 0.889170 ... 1.000000 0.958283 0.987216 0.951221 0.973742 0.992157 0.934842 0.888748 0.898743 0.896279
W07000073 0.002837 0.936510 0.863631 0.938632 0.871408 0.940338 0.849908 0.923668 0.905723 0.941725 ... 0.958283 1.000000 0.985994 0.975981 0.974842 0.966808 0.973109 0.955958 0.957397 0.945913
W07000074 0.014302 0.928037 0.898084 0.902203 0.892290 0.905886 0.882895 0.924323 0.917289 0.917023 ... 0.987216 0.985994 1.000000 0.968630 0.980676 0.988952 0.956984 0.923958 0.930382 0.921668
W07000075 0.034120 0.969006 0.898556 0.969287 0.902190 0.970672 0.878265 0.958563 0.938538 0.974891 ... 0.951221 0.975981 0.968630 1.000000 0.992518 0.966769 0.995541 0.978948 0.982154 0.977759
W07000076 0.020033 0.961883 0.922351 0.945125 0.917251 0.947840 0.901319 0.957569 0.941687 0.956049 ... 0.973742 0.974842 0.980676 0.992518 1.000000 0.984985 0.985178 0.954718 0.959717 0.958966
W07000077 0.004546 0.941685 0.937393 0.899418 0.921122 0.903750 0.919289 0.945028 0.940064 0.920036 ... 0.992157 0.966808 0.988952 0.966769 0.984985 1.000000 0.954606 0.912301 0.920169 0.923709
W07000078 0.027678 0.977256 0.889773 0.980133 0.899972 0.984158 0.873246 0.961875 0.937030 0.985878 ... 0.934842 0.973109 0.956984 0.995541 0.985178 0.954606 1.000000 0.987637 0.989099 0.988032
W07000079 0.008651 0.957791 0.833678 0.986963 0.857266 0.987823 0.819351 0.934162 0.911520 0.983703 ... 0.888748 0.955958 0.923958 0.978948 0.954718 0.912301 0.987637 1.000000 0.998730 0.990368
W07000080 0.025288 0.960426 0.842046 0.982978 0.862399 0.985067 0.829739 0.936628 0.919208 0.983620 ... 0.898743 0.957397 0.930382 0.982154 0.959717 0.920169 0.989099 0.998730 1.000000 0.990771
sum 0.004666 0.980940 0.883754 0.990123 0.897083 0.992872 0.870814 0.963189 0.946545 0.995250 ... 0.896279 0.945913 0.921668 0.977759 0.958966 0.923709 0.988032 0.990368 0.990771 1.000000

652 rows × 652 columns

In [8]:
# Whoops, it is per-column, and we wanted per-row
# Transpose the frame first (and use action as a header)
top_petitions.set_index('action').T.corr()
Out[8]:
action EU Referendum Rules triggering a 2nd EU Referendum Prevent Donald Trump from making a State Visit to the United Kingdom. Give the Meningitis B vaccine to ALL children, not just newborn babies. Block Donald J Trump from UK entry Stop all immigration and close the UK borders until ISIS is defeated. Accept more asylum seekers and increase support for refugee migrants in the UK. Consider a vote of No Confidence in Jeremy Hunt, Health Secretary Donald Trump should make a State Visit to the United Kingdom. Make the production, sale and use of cannabis legal. Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid ... David Cameron to take serious diplomatic action against commercial whaling We demand GPs only decide who is fit to go back to work, not the DWP! Close sharia courts set up in the uk and make sharia law illegal in britain Drop the plans to INCREASE tuition fees further and open more universities. Ringfence the NHS from trade deals Make Eid a National Holiday Increase the maximum sentence for animal cruelty charges Introduce mental health education to the national curriculum Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. Reform the rules on filibustering or 'talking a bill to death'.
action
EU Referendum Rules triggering a 2nd EU Referendum 1.000000 0.998019 0.994526 0.985981 0.979133 0.978829 0.949802 0.881105 0.923984 0.891616 ... 0.479894 0.442290 0.341028 0.402410 0.312458 0.352671 0.390746 0.460890 0.323351 0.434170
Prevent Donald Trump from making a State Visit to the United Kingdom. 0.998019 1.000000 0.998777 0.994467 0.989660 0.989711 0.967415 0.908701 0.945949 0.917913 ... 0.533499 0.497216 0.398793 0.458524 0.370935 0.410173 0.447197 0.515169 0.381546 0.489352
Give the Meningitis B vaccine to ALL children, not just newborn babies. 0.994526 0.998777 1.000000 0.997291 0.994798 0.993893 0.976192 0.924371 0.957760 0.932844 ... 0.565561 0.530235 0.433849 0.492265 0.406192 0.444811 0.481363 0.547698 0.416836 0.522386
Block Donald J Trump from UK entry 0.985981 0.994467 0.997291 1.000000 0.998767 0.999177 0.988528 0.947337 0.974650 0.954300 ... 0.619141 0.585359 0.492664 0.549084 0.466160 0.503459 0.538424 0.602104 0.476268 0.577992
Stop all immigration and close the UK borders until ISIS is defeated. 0.979133 0.989660 0.994798 0.998767 1.000000 0.999227 0.992796 0.958028 0.981772 0.964281 ... 0.645633 0.612919 0.522349 0.577313 0.496070 0.532687 0.567148 0.629081 0.506201 0.605512
Accept more asylum seekers and increase support for refugee migrants in the UK. 0.978829 0.989711 0.993893 0.999177 0.999227 1.000000 0.993572 0.958757 0.982415 0.964878 ... 0.648778 0.615998 0.525619 0.580693 0.499760 0.536113 0.570287 0.632260 0.509610 0.608865
Consider a vote of No Confidence in Jeremy Hunt, Health Secretary 0.949802 0.967415 0.976192 0.988528 0.992796 0.993572 1.000000 0.984647 0.997138 0.988298 ... 0.730059 0.700496 0.617775 0.668379 0.593723 0.627366 0.658881 0.715207 0.602934 0.694014
Donald Trump should make a State Visit to the United Kingdom. 0.881105 0.908701 0.924371 0.947337 0.958028 0.958757 0.984647 1.000000 0.994890 0.999717 ... 0.837334 0.813497 0.744679 0.787012 0.723974 0.752642 0.779246 0.825366 0.731996 0.808083
Make the production, sale and use of cannabis legal. 0.923984 0.945949 0.957760 0.974650 0.981772 0.982415 0.997138 0.994890 1.000000 0.996870 ... 0.778554 0.751380 0.674246 0.721476 0.651511 0.683167 0.712718 0.764886 0.660265 0.745270
Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid 0.891616 0.917913 0.932844 0.954300 0.964281 0.964878 0.988298 0.999717 0.996870 1.000000 ... 0.824600 0.799958 0.729206 0.772681 0.707983 0.737353 0.764694 0.812218 0.716216 0.794376
To debate a vote of no confidence in Health Secretary the Right Hon Jeremy Hunt 0.920929 0.943386 0.955176 0.972871 0.979903 0.981019 0.996610 0.995511 0.999827 0.997292 ... 0.783655 0.756692 0.680210 0.727156 0.657751 0.689122 0.718371 0.770140 0.666359 0.750746
Vote no on military action in Syria against IS in response to the Paris attacks 0.905396 0.930109 0.942878 0.963450 0.971286 0.972801 0.992344 0.997675 0.998351 0.998539 ... 0.805917 0.780219 0.706771 0.751944 0.685143 0.715683 0.743473 0.793034 0.693392 0.774539
Make online abuse a specific criminal offence and create a register of offenders 0.772344 0.810296 0.832509 0.867174 0.884083 0.885527 0.932149 0.980835 0.956484 0.976093 ... 0.927611 0.911096 0.860263 0.891927 0.844302 0.866240 0.886241 0.919391 0.850515 0.907191
STOP CAMERON spending British taxpayers’ money on Pro-EU Referendum leaflets 0.894941 0.920818 0.935468 0.956473 0.966194 0.966772 0.989390 0.999515 0.997400 0.999952 ... 0.820410 0.795499 0.724134 0.767976 0.702753 0.732359 0.759917 0.807889 0.711045 0.789877
Another Scottish independence referendum should not be allowed to happen 0.782258 0.819494 0.840725 0.874635 0.890637 0.892496 0.936415 0.981645 0.959616 0.977343 ... 0.917876 0.900810 0.847942 0.880527 0.831648 0.854088 0.874749 0.909243 0.837996 0.896553
Repeal the new Surveillance laws (Investigatory Powers Act) 0.788646 0.825376 0.846276 0.879958 0.895508 0.897508 0.941318 0.985374 0.963665 0.981189 ... 0.917798 0.900202 0.846852 0.880114 0.830385 0.853190 0.874019 0.909061 0.836740 0.896212
No more school penalty fines and bring back the 10 day authorised absence 0.856328 0.886681 0.904087 0.930156 0.942470 0.943300 0.974652 0.998594 0.988519 0.997167 ... 0.863353 0.841325 0.776897 0.816655 0.757312 0.784436 0.809405 0.852322 0.764901 0.836285
Stop allowing immigrants into the UK. 0.896129 0.921886 0.936482 0.957282 0.967051 0.967464 0.989757 0.999407 0.997617 0.999865 ... 0.818688 0.793764 0.722136 0.766079 0.700668 0.730419 0.758037 0.806157 0.708977 0.788069
Vote no confidence in David Cameron 0.895405 0.921383 0.935549 0.956937 0.966279 0.967334 0.989704 0.999313 0.997538 0.999705 ... 0.819962 0.795091 0.723537 0.767491 0.702297 0.731878 0.759351 0.807465 0.710468 0.789496
Make fair transitional state pension arrangements for 1950’s women 0.876278 0.904472 0.920474 0.944052 0.955093 0.955906 0.982854 0.999871 0.993823 0.999381 ... 0.842702 0.819246 0.751234 0.793056 0.730778 0.759088 0.785394 0.830909 0.738712 0.813881
No UK airstrikes on Syria. 0.869715 0.898800 0.914509 0.939775 0.950398 0.952134 0.980317 0.999257 0.992101 0.998354 ... 0.850050 0.827051 0.760215 0.801477 0.740293 0.768206 0.793788 0.838551 0.747915 0.821934
Put a max of £1200 on car insurance for 18-25 year olds 0.761102 0.799921 0.822588 0.858365 0.875682 0.877246 0.925629 0.977220 0.951175 0.972065 ... 0.933964 0.918129 0.869033 0.899704 0.853535 0.874911 0.894179 0.926107 0.859559 0.914386
Hold a General Election in 2016 0.832793 0.865624 0.884100 0.913246 0.926567 0.928176 0.964134 0.995352 0.981065 0.992881 ... 0.885142 0.864714 0.804222 0.841692 0.785869 0.811352 0.834792 0.874941 0.792941 0.860101
Change the University fees from £9250 back to the £3000 fee for the UK. 0.686267 0.730134 0.755551 0.797751 0.817500 0.819999 0.878940 0.948011 0.911722 0.940439 ... 0.966920 0.955345 0.917294 0.941566 0.904838 0.922115 0.937152 0.961280 0.909646 0.952649
Ban the sale of fireworks to the public and only approve organised displays. 0.712813 0.754980 0.779877 0.819432 0.838879 0.840704 0.896154 0.959445 0.926586 0.952776 ... 0.956821 0.943792 0.901836 0.928240 0.888242 0.906794 0.923565 0.950378 0.893570 0.940648
Keep the NHS Bursary 0.831573 0.864497 0.883211 0.912343 0.925885 0.927322 0.963535 0.995226 0.980690 0.992722 ... 0.886126 0.865793 0.805505 0.842831 0.787150 0.812575 0.835982 0.875979 0.794245 0.861161
Hold a public inquiry and a referendum over turning all schools into academies 0.793697 0.829972 0.850615 0.883747 0.899032 0.901030 0.944066 0.986678 0.965712 0.982699 ... 0.914422 0.896456 0.842346 0.876115 0.825688 0.848768 0.869896 0.905506 0.832109 0.892457
Call on David Cameron to act to protect our steel industry & recall Parliament 0.786383 0.823229 0.844394 0.878031 0.893929 0.895699 0.939950 0.984611 0.962526 0.980375 ... 0.918798 0.901358 0.848334 0.881382 0.831911 0.854625 0.875353 0.910127 0.838268 0.897354
Introduce a tax on sugary drinks in the UK to improve our children's health. 0.829568 0.862615 0.881344 0.910812 0.924211 0.925908 0.962467 0.994810 0.979834 0.992239 ... 0.887957 0.867644 0.807776 0.844934 0.789543 0.814792 0.838089 0.877831 0.796592 0.863115
Scrap plans to force state schools to become academies. 0.783558 0.820654 0.841877 0.875912 0.891757 0.893747 0.938505 0.983923 0.961329 0.979575 ... 0.920966 0.903645 0.851124 0.883946 0.834866 0.857367 0.877915 0.912380 0.841142 0.899767
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Save the Human Rights Act 0.558348 0.608886 0.638672 0.688601 0.712805 0.715923 0.789695 0.883803 0.832796 0.872835 ... 0.995734 0.990946 0.970216 0.984091 0.962512 0.972900 0.981718 0.993530 0.965532 0.989735
Make it illegal for any UK political figure to knowingly lie or mislead. 0.559059 0.609536 0.639289 0.689195 0.713327 0.716483 0.790190 0.884176 0.833221 0.873230 ... 0.995660 0.990807 0.970010 0.983957 0.962285 0.972701 0.981554 0.993435 0.965315 0.989613
Lower university fees down to £3,000 0.509268 0.561764 0.592935 0.645369 0.670878 0.674038 0.752594 0.855137 0.799169 0.843011 ... 0.999208 0.996863 0.982509 0.992626 0.976457 0.984548 0.990955 0.998266 0.978843 0.996162
Suspend the Myanmar Ambassador for Genocide of Rohingya Muslims. 0.407339 0.463321 0.496914 0.553593 0.581689 0.584960 0.672159 0.790057 0.724989 0.775802 ... 0.996081 0.998599 0.996798 0.999342 0.994152 0.997614 0.999155 0.997592 0.995261 0.998915
Introduce Compulsory Scanning for microchips by vets, rescues and authorities. 0.578241 0.627797 0.657460 0.705847 0.729929 0.732410 0.804268 0.895122 0.846054 0.884694 ... 0.993186 0.987392 0.964081 0.979436 0.955510 0.966962 0.976855 0.990443 0.958926 0.985874
Cancel the end of Key Stage 2 SATs tests for 2016 0.518791 0.570895 0.602133 0.653719 0.679385 0.682205 0.760024 0.861100 0.805963 0.849243 ... 0.998912 0.996100 0.980512 0.991307 0.974073 0.982558 0.989560 0.997716 0.976655 0.995276
Stop cuts to pharmacy funding and support pharmacy services that save NHS money 0.521226 0.573247 0.604333 0.655929 0.681403 0.684309 0.761845 0.862490 0.807641 0.850673 ... 0.998791 0.995873 0.979968 0.990963 0.973464 0.982080 0.989155 0.997546 0.976059 0.995016
Stop car insurance companies ripping under 25s off with sky high prices 0.490493 0.543709 0.575721 0.628640 0.655135 0.657902 0.738297 0.844026 0.786214 0.831513 ... 0.999823 0.998453 0.986421 0.995031 0.980923 0.988093 0.993739 0.999347 0.983151 0.997864
Make tampons and sanitary towels free for females 0.379686 0.436466 0.470732 0.528316 0.557133 0.560450 0.649829 0.771621 0.704246 0.756852 ... 0.993807 0.997603 0.999121 0.999656 0.997395 0.999252 0.999867 0.995970 0.998172 0.998192
Start aid drops to the starving people of Syria 0.499001 0.551961 0.583212 0.636346 0.661955 0.665286 0.744709 0.848794 0.791930 0.836419 ... 0.999429 0.997614 0.984510 0.993857 0.978852 0.986552 0.992322 0.998754 0.981075 0.997021
Prevent the closure of Huddersfield A&E department 0.484549 0.537030 0.568376 0.620669 0.646578 0.649484 0.728770 0.832643 0.775703 0.820315 ... 0.985576 0.984187 0.972191 0.980768 0.966799 0.973806 0.979435 0.985105 0.968951 0.983679
Make the uk armed forces pensions for 22 years service tax free. 0.355300 0.412698 0.447526 0.505827 0.535264 0.538486 0.629650 0.754732 0.685388 0.739541 ... 0.990490 0.995378 0.999789 0.998564 0.998812 0.999554 0.999128 0.993182 0.999328 0.996182
Reverse the planned tax relief restriction on ‘individual’ landlords 0.519476 0.571540 0.602515 0.654369 0.679654 0.682786 0.760408 0.861306 0.806291 0.849439 ... 0.998852 0.995975 0.980329 0.991209 0.973923 0.982424 0.989401 0.997636 0.976464 0.995175
Cancel the planned referendum on Britain's continued membership of the EU. 0.456094 0.510564 0.542817 0.597790 0.624468 0.628123 0.711327 0.822016 0.761169 0.808734 ... 0.999523 0.999703 0.991973 0.998124 0.987841 0.993223 0.997200 0.999859 0.989481 0.999621
Stop plans to make it a criminal offence to not pay back your student loan 0.453228 0.507769 0.540433 0.595212 0.622338 0.625544 0.709158 0.820448 0.759295 0.807131 ... 0.999491 0.999860 0.992475 0.998384 0.988333 0.993632 0.997541 0.999926 0.990018 0.999743
Introduce minimum prices that milk buyers purchase their milk for from Farmers 0.502374 0.555124 0.586768 0.639147 0.665243 0.668138 0.747407 0.851200 0.794503 0.838979 ... 0.999532 0.997502 0.983959 0.993483 0.978087 0.985733 0.991993 0.998685 0.980482 0.996815
Reconsider the new Dividend Tax for small businesses 0.498923 0.551796 0.583339 0.636141 0.662007 0.665172 0.744710 0.848965 0.791973 0.836641 ... 0.999672 0.997812 0.984765 0.994076 0.979066 0.986565 0.992588 0.998974 0.981344 0.997225
Keep Performing Arts as an Option for GCSE/A Levels 0.451656 0.506214 0.539019 0.593754 0.621009 0.624127 0.707884 0.819502 0.758149 0.806167 ... 0.999449 0.999880 0.992709 0.998479 0.988588 0.993806 0.997679 0.999910 0.990279 0.999765
Free childcare for 2 year olds to include parents who are both working full time 0.466354 0.520424 0.553035 0.606991 0.634139 0.636955 0.719507 0.828957 0.768915 0.815925 ... 0.999734 0.999554 0.990518 0.997322 0.985842 0.991839 0.996369 0.999853 0.987753 0.999204
Ensure the British fishing waters are returned to the UK post Brexit 0.315691 0.374058 0.409516 0.469145 0.499272 0.502626 0.596458 0.726503 0.654187 0.710590 ... 0.983940 0.990593 0.999625 0.995624 0.999936 0.998873 0.996725 0.987532 0.999952 0.991781
David Cameron to take serious diplomatic action against commercial whaling 0.479894 0.533499 0.565561 0.619141 0.645633 0.648778 0.730059 0.837334 0.778554 0.824600 ... 1.000000 0.999055 0.988361 0.996220 0.983309 0.989857 0.995028 0.999731 0.985357 0.998649
We demand GPs only decide who is fit to go back to work, not the DWP! 0.442290 0.497216 0.530235 0.585359 0.612919 0.615998 0.700496 0.813497 0.751380 0.799958 ... 0.999055 1.000000 0.993907 0.998945 0.990092 0.994881 0.998325 0.999735 0.991670 0.999909
Close sharia courts set up in the uk and make sharia law illegal in britain 0.341028 0.398793 0.433849 0.492664 0.522349 0.525619 0.617775 0.744679 0.674246 0.729206 ... 0.988361 0.993907 1.000000 0.997765 0.999489 0.999590 0.998531 0.991400 0.999812 0.994849
Drop the plans to INCREASE tuition fees further and open more universities. 0.402410 0.458524 0.492265 0.549084 0.577313 0.580693 0.668379 0.787012 0.721476 0.772681 ... 0.996220 0.998945 0.997765 1.000000 0.995319 0.998209 0.999827 0.997862 0.996362 0.999353
Ringfence the NHS from trade deals 0.312458 0.370935 0.406192 0.466160 0.496070 0.499760 0.593723 0.723974 0.651511 0.707983 ... 0.983309 0.990092 0.999489 0.995319 1.000000 0.998741 0.996402 0.986995 0.999902 0.991373
Make Eid a National Holiday 0.352671 0.410173 0.444811 0.503459 0.532687 0.536113 0.627366 0.752642 0.683167 0.737353 ... 0.989857 0.994881 0.999590 0.998209 0.998741 1.000000 0.998779 0.992632 0.999165 0.995729
Increase the maximum sentence for animal cruelty charges 0.390746 0.447197 0.481363 0.538424 0.567148 0.570287 0.658881 0.779246 0.712718 0.764694 ... 0.995028 0.998325 0.998531 0.999827 0.996402 0.998779 1.000000 0.996927 0.997346 0.998782
Introduce mental health education to the national curriculum 0.460890 0.515169 0.547698 0.602104 0.629081 0.632260 0.715207 0.825366 0.764886 0.812218 ... 0.999731 0.999735 0.991400 0.997862 0.986995 0.992632 0.996927 1.000000 0.988787 0.999530
Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. 0.323351 0.381546 0.416836 0.476268 0.506201 0.509610 0.602934 0.731996 0.660265 0.716216 ... 0.985357 0.991670 0.999812 0.996362 0.999902 0.999165 0.997346 0.988787 1.000000 0.992802
Reform the rules on filibustering or 'talking a bill to death'. 0.434170 0.489352 0.522386 0.577992 0.605512 0.608865 0.694014 0.808083 0.745270 0.794376 ... 0.998649 0.999909 0.994849 0.999353 0.991373 0.995729 0.998782 0.999530 0.992802 1.000000

100 rows × 100 columns

In [9]:
# Suspiciously high values of correlation
# Remove the id and total sum from the columns
geo_columns = top_petitions.columns.drop(['id', 'sum', 'action'])
top_petitions.set_index('action').loc[:, geo_columns].T.corr()
Out[9]:
action EU Referendum Rules triggering a 2nd EU Referendum Prevent Donald Trump from making a State Visit to the United Kingdom. Give the Meningitis B vaccine to ALL children, not just newborn babies. Block Donald J Trump from UK entry Stop all immigration and close the UK borders until ISIS is defeated. Accept more asylum seekers and increase support for refugee migrants in the UK. Consider a vote of No Confidence in Jeremy Hunt, Health Secretary Donald Trump should make a State Visit to the United Kingdom. Make the production, sale and use of cannabis legal. Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid ... David Cameron to take serious diplomatic action against commercial whaling We demand GPs only decide who is fit to go back to work, not the DWP! Close sharia courts set up in the uk and make sharia law illegal in britain Drop the plans to INCREASE tuition fees further and open more universities. Ringfence the NHS from trade deals Make Eid a National Holiday Increase the maximum sentence for animal cruelty charges Introduce mental health education to the national curriculum Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. Reform the rules on filibustering or 'talking a bill to death'.
action
EU Referendum Rules triggering a 2nd EU Referendum 1.000000 0.931366 -0.001472 0.882331 -0.592924 0.849318 0.816593 -0.012481 0.479872 -0.062981 ... 0.626116 -0.138837 -0.281359 0.612902 0.761876 0.104963 -0.091412 0.546637 0.087657 0.665693
Prevent Donald Trump from making a State Visit to the United Kingdom. 0.931366 1.000000 -0.131018 0.955483 -0.564216 0.961378 0.864308 -0.182204 0.575654 -0.236920 ... 0.605445 0.067479 -0.360614 0.537030 0.871368 0.154133 -0.122433 0.558500 0.048411 0.746018
Give the Meningitis B vaccine to ALL children, not just newborn babies. -0.001472 -0.131018 1.000000 -0.169793 0.394236 -0.176744 0.042348 0.646837 0.074567 0.658465 ... 0.144583 -0.055073 0.512299 0.120037 -0.069709 -0.094147 0.349459 0.217326 0.418368 0.047320
Block Donald J Trump from UK entry 0.882331 0.955483 -0.169793 1.000000 -0.538675 0.894932 0.758069 -0.215380 0.558347 -0.284373 ... 0.481823 0.018865 -0.379726 0.480562 0.744979 0.204371 -0.147041 0.477240 -0.078591 0.628789
Stop all immigration and close the UK borders until ISIS is defeated. -0.592924 -0.564216 0.394236 -0.538675 1.000000 -0.519311 -0.379656 0.409563 -0.032569 0.277103 ... -0.369008 0.324410 0.617548 -0.347938 -0.417922 -0.043841 0.340313 -0.220248 0.113388 -0.302117
Accept more asylum seekers and increase support for refugee migrants in the UK. 0.849318 0.961378 -0.176744 0.894932 -0.519311 1.000000 0.849263 -0.285344 0.604976 -0.324957 ... 0.550122 0.162215 -0.437897 0.446428 0.872606 0.099436 -0.158326 0.555253 0.009138 0.739426
Consider a vote of No Confidence in Jeremy Hunt, Health Secretary 0.816593 0.864308 0.042348 0.758069 -0.379656 0.849263 1.000000 -0.024259 0.619816 -0.053436 ... 0.631179 0.200106 -0.151848 0.667032 0.918423 0.090083 -0.009413 0.745127 0.287263 0.903941
Donald Trump should make a State Visit to the United Kingdom. -0.012481 -0.182204 0.646837 -0.215380 0.409563 -0.285344 -0.024259 1.000000 -0.094110 0.876402 ... 0.256251 -0.128221 0.735133 0.151690 -0.140106 -0.053903 0.344053 0.058672 0.505973 -0.017579
Make the production, sale and use of cannabis legal. 0.479872 0.575654 0.074567 0.558347 -0.032569 0.604976 0.619816 -0.094110 1.000000 -0.109889 ... 0.376418 0.439908 -0.123312 0.343262 0.624733 -0.010616 0.002824 0.531539 0.196834 0.625434
Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid -0.062981 -0.236920 0.658465 -0.284373 0.277103 -0.324957 -0.053436 0.876402 -0.109889 1.000000 ... 0.295393 -0.132705 0.652460 0.151288 -0.167385 -0.115219 0.298651 0.075208 0.598364 -0.026394
To debate a vote of no confidence in Health Secretary the Right Hon Jeremy Hunt 0.777335 0.836277 -0.053129 0.749298 -0.400151 0.837782 0.960877 -0.116803 0.591637 -0.142235 ... 0.527165 0.210913 -0.220395 0.621407 0.872311 0.088434 -0.056171 0.698019 0.188372 0.846901
Vote no on military action in Syria against IS in response to the Paris attacks 0.537622 0.683631 -0.324806 0.771689 -0.391272 0.604683 0.493553 -0.324262 0.345095 -0.401866 ... 0.201341 0.067692 -0.298694 0.315630 0.535735 0.375830 -0.156544 0.261664 -0.184029 0.431794
Make online abuse a specific criminal offence and create a register of offenders -0.433248 -0.416748 0.401372 -0.415412 0.774932 -0.363753 -0.207372 0.257046 0.132514 0.177109 ... -0.390473 0.401614 0.462569 -0.259902 -0.255856 -0.045527 0.222243 -0.114889 0.055934 -0.196207
STOP CAMERON spending British taxpayers’ money on Pro-EU Referendum leaflets 0.015693 -0.155878 0.636816 -0.213505 0.261659 -0.271704 0.021185 0.865908 -0.094783 0.891759 ... 0.410739 -0.117318 0.711823 0.213393 -0.081061 -0.059737 0.336257 0.129111 0.668605 0.075836
Another Scottish independence referendum should not be allowed to happen -0.178676 0.006602 -0.156335 0.070728 0.045999 0.160743 -0.141260 -0.361638 0.168238 -0.274605 ... -0.063811 0.347487 -0.387516 -0.396254 -0.070322 -0.099832 -0.180236 -0.119545 -0.178537 -0.108606
Repeal the new Surveillance laws (Investigatory Powers Act) 0.747345 0.864261 -0.091235 0.827955 -0.337827 0.881467 0.856305 -0.181547 0.772355 -0.234710 ... 0.519468 0.271875 -0.271417 0.498766 0.847339 0.099990 -0.081005 0.640417 0.138672 0.812350
No more school penalty fines and bring back the 10 day authorised absence -0.040370 -0.080872 0.349745 -0.031168 0.370994 -0.210129 0.014580 0.479956 -0.015128 0.396386 ... -0.037129 0.013506 0.580038 0.197809 -0.056909 0.129935 0.369478 0.026471 0.239045 0.011151
Stop allowing immigrants into the UK. -0.367042 -0.412059 0.537193 -0.393472 0.792577 -0.466677 -0.228012 0.677772 -0.109571 0.506160 ... -0.160731 0.090934 0.820675 -0.104837 -0.304059 0.036320 0.400489 -0.106766 0.245718 -0.180528
Vote no confidence in David Cameron 0.395385 0.571463 -0.119042 0.473855 -0.077926 0.603447 0.738371 -0.140723 0.652953 -0.178558 ... 0.469152 0.628868 -0.017992 0.362770 0.789606 0.096938 0.011632 0.509632 0.348302 0.796159
Make fair transitional state pension arrangements for 1950’s women -0.201174 -0.185199 0.314292 -0.280022 0.255206 -0.129331 0.010641 0.389464 -0.006968 0.509798 ... 0.242426 0.342545 0.270210 -0.058060 -0.010185 -0.136277 0.134824 0.060205 0.500927 0.087168
No UK airstrikes on Syria. 0.679012 0.844942 -0.308371 0.871734 -0.452246 0.820774 0.714195 -0.393246 0.592076 -0.456445 ... 0.352226 0.201293 -0.403637 0.422629 0.760649 0.266340 -0.167289 0.452961 -0.115173 0.653572
Put a max of £1200 on car insurance for 18-25 year olds -0.254612 -0.213361 -0.054973 -0.111209 0.316951 -0.265959 -0.223025 -0.023416 -0.084387 -0.166515 ... -0.494125 -0.000327 0.179540 -0.042205 -0.229997 0.241619 0.017984 -0.166954 -0.311991 -0.236222
Hold a General Election in 2016 0.555093 0.679957 -0.060357 0.574294 -0.173123 0.676683 0.848298 -0.084555 0.652242 -0.141527 ... 0.502104 0.479564 -0.026927 0.512892 0.866507 0.128202 0.028463 0.594961 0.326263 0.854142
Change the University fees from £9250 back to the £3000 fee for the UK. 0.422621 0.433682 -0.187312 0.570319 -0.327190 0.275003 0.220086 -0.143018 0.127734 -0.238313 ... -0.029921 -0.242007 -0.137629 0.369653 0.198101 0.285325 -0.100485 0.075562 -0.332768 0.101913
Ban the sale of fireworks to the public and only approve organised displays. -0.153606 -0.140430 0.143644 -0.145628 0.176218 -0.117449 -0.112803 0.096046 0.020097 0.175340 ... -0.030416 0.118855 0.121015 -0.098972 -0.111324 -0.068560 0.074356 -0.020654 0.115507 -0.082198
Keep the NHS Bursary 0.346548 0.479451 0.052314 0.415890 -0.029916 0.534060 0.729794 -0.073324 0.607975 -0.067601 ... 0.344965 0.469800 -0.030382 0.436660 0.660743 0.050083 0.008635 0.625042 0.299759 0.736154
Hold a public inquiry and a referendum over turning all schools into academies 0.680402 0.696199 0.163531 0.566691 -0.275352 0.633247 0.825334 0.141782 0.471063 0.106540 ... 0.613385 0.131959 0.028911 0.642211 0.809120 0.098073 0.069784 0.609926 0.356353 0.812878
Call on David Cameron to act to protect our steel industry & recall Parliament 0.181644 0.207173 -0.117708 0.111258 -0.148299 0.205850 0.302745 -0.135759 0.121961 -0.100598 ... 0.151650 0.152565 -0.047971 0.201081 0.345891 0.009633 0.009552 0.223544 0.135677 0.297774
Introduce a tax on sugary drinks in the UK to improve our children's health. 0.846268 0.725008 0.325142 0.658524 -0.407915 0.646336 0.699409 0.291286 0.431297 0.309215 ... 0.744047 -0.153640 -0.055954 0.576885 0.601587 -0.005053 0.064161 0.562805 0.367887 0.601120
Scrap plans to force state schools to become academies. 0.638246 0.643452 0.179022 0.516722 -0.239953 0.582183 0.796013 0.171919 0.425164 0.137438 ... 0.565043 0.123484 0.057611 0.649237 0.756672 0.104344 0.080362 0.592784 0.352389 0.772939
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Save the Human Rights Act 0.764693 0.885242 -0.119269 0.780443 -0.402591 0.882648 0.906521 -0.184345 0.667250 -0.225191 ... 0.633490 0.309553 -0.237989 0.511772 0.961492 0.108352 -0.051847 0.616844 0.235351 0.878679
Make it illegal for any UK political figure to knowingly lie or mislead. 0.875991 0.904678 -0.021995 0.803790 -0.475062 0.862328 0.912971 -0.056388 0.615500 -0.091662 ... 0.698398 0.109842 -0.210204 0.622893 0.916679 0.094905 -0.038242 0.656519 0.273753 0.862859
Lower university fees down to £3,000 0.521409 0.495703 -0.099780 0.579176 -0.345053 0.353243 0.298410 -0.071229 0.182235 -0.171305 ... 0.058951 -0.263506 -0.116505 0.415534 0.276178 0.213844 -0.061403 0.128939 -0.288571 0.157191
Suspend the Myanmar Ambassador for Genocide of Rohingya Muslims. 0.086034 0.127038 -0.063327 0.185916 -0.020016 0.075615 0.067123 -0.027741 0.017228 -0.083258 ... -0.014524 -0.057973 0.020476 0.093156 0.064883 0.353060 -0.013711 0.000079 -0.077930 0.038766
Introduce Compulsory Scanning for microchips by vets, rescues and authorities. -0.116013 -0.211124 0.480274 -0.277072 0.240123 -0.275230 -0.039359 0.567734 -0.075209 0.648082 ... 0.308660 0.015145 0.514883 0.089131 -0.080372 -0.092154 0.266095 0.077862 0.600772 0.051205
Cancel the end of Key Stage 2 SATs tests for 2016 0.199822 0.111694 0.386112 0.008125 0.075710 0.035685 0.359613 0.494280 0.058642 0.503556 ... 0.325493 -0.023846 0.411237 0.466724 0.270522 0.030119 0.225453 0.344932 0.466022 0.384991
Stop cuts to pharmacy funding and support pharmacy services that save NHS money 0.405264 0.339126 0.178913 0.359603 -0.193194 0.232259 0.418648 0.163589 0.224998 0.171079 ... 0.218133 -0.090516 0.070251 0.579018 0.297787 0.089597 0.006449 0.370116 0.100990 0.348630
Stop car insurance companies ripping under 25s off with sky high prices -0.371314 -0.335506 0.125810 -0.269356 0.441310 -0.390771 -0.286484 0.147861 -0.160262 0.081105 ... -0.355294 0.041640 0.348249 -0.099590 -0.280645 0.136188 0.159789 -0.125444 -0.009802 -0.217251
Make tampons and sanitary towels free for females 0.322913 0.362965 0.278480 0.335203 0.049752 0.328308 0.465944 0.147580 0.500371 0.128987 ... 0.370177 0.198129 0.159008 0.407062 0.413848 0.073191 0.082621 0.485164 0.311822 0.505514
Start aid drops to the starving people of Syria 0.437413 0.538144 -0.334951 0.675804 -0.355022 0.434758 0.321647 -0.305594 0.211983 -0.389864 ... 0.025241 -0.055022 -0.270847 0.269996 0.329536 0.382000 -0.162982 0.141840 -0.304979 0.233708
Prevent the closure of Huddersfield A&E department -0.006949 0.007821 -0.027146 0.008662 -0.013543 -0.000671 0.049159 0.022933 -0.018244 0.009105 ... -0.014578 0.014233 0.021953 0.006199 0.036517 -0.003768 -0.008240 0.013830 0.009709 0.050077
Make the uk armed forces pensions for 22 years service tax free. -0.130734 -0.163035 0.168146 -0.189090 0.171709 -0.172043 -0.072701 0.310728 -0.042237 0.379238 ... 0.137695 0.035964 0.305325 -0.004712 -0.092586 -0.039226 0.056110 -0.059031 0.338759 -0.020172
Reverse the planned tax relief restriction on ‘individual’ landlords 0.744878 0.612612 0.125359 0.652998 -0.424094 0.481700 0.463175 0.145888 0.291257 0.108771 ... 0.345054 -0.310280 -0.112535 0.496046 0.366626 0.055840 -0.047877 0.301344 -0.062485 0.292419
Cancel the planned referendum on Britain's continued membership of the EU. 0.902875 0.943572 -0.106130 0.854647 -0.501277 0.897386 0.844818 -0.099733 0.518743 -0.187853 ... 0.620086 0.053819 -0.254117 0.517552 0.877907 0.132570 -0.062595 0.508948 0.094773 0.738831
Stop plans to make it a criminal offence to not pay back your student loan 0.509295 0.528000 0.079079 0.486886 -0.164332 0.445326 0.694094 0.071446 0.530958 0.013127 ... 0.412959 0.138542 0.082458 0.681714 0.626220 0.113588 0.087367 0.598019 0.283061 0.700959
Introduce minimum prices that milk buyers purchase their milk for from Farmers -0.031046 -0.051017 -0.013654 -0.123570 -0.145243 -0.039052 -0.025323 0.147213 -0.084925 0.219202 ... 0.379926 0.025234 -0.030279 -0.018948 0.004001 -0.123087 -0.054624 -0.013306 0.385747 0.061700
Reconsider the new Dividend Tax for small businesses 0.717591 0.611395 0.246261 0.659750 -0.342929 0.496736 0.476246 0.183356 0.345698 0.169759 ... 0.353604 -0.256335 -0.084311 0.461787 0.384545 0.060464 0.030759 0.342593 0.036513 0.329323
Keep Performing Arts as an Option for GCSE/A Levels 0.454686 0.325389 0.386820 0.247123 -0.078851 0.237960 0.475656 0.437074 0.280205 0.410629 ... 0.416425 -0.137742 0.233491 0.595298 0.384616 -0.010649 0.127971 0.479580 0.367582 0.459841
Free childcare for 2 year olds to include parents who are both working full time -0.260270 -0.261691 0.167038 -0.275950 0.462711 -0.256087 -0.038851 0.239275 -0.059525 0.166277 ... -0.272253 0.320171 0.395818 -0.040636 -0.112849 0.080799 0.103940 -0.087393 0.075827 -0.050346
Ensure the British fishing waters are returned to the UK post Brexit -0.259599 -0.289544 0.242322 -0.335061 0.260000 -0.311270 -0.165045 0.486327 -0.184991 0.513038 ... 0.274935 0.136612 0.509101 -0.102958 -0.161229 -0.073780 0.209920 -0.100921 0.476157 -0.057473
David Cameron to take serious diplomatic action against commercial whaling 0.626116 0.605445 0.144583 0.481823 -0.369008 0.550122 0.631179 0.256251 0.376418 0.295393 ... 1.000000 0.112821 0.011691 0.443548 0.649228 -0.032723 0.049336 0.479472 0.613898 0.668429
We demand GPs only decide who is fit to go back to work, not the DWP! -0.138837 0.067479 -0.055073 0.018865 0.324410 0.162215 0.200106 -0.128221 0.439908 -0.132705 ... 0.112821 1.000000 0.110862 -0.120063 0.267972 -0.010296 0.056256 0.105424 0.278143 0.298574
Close sharia courts set up in the uk and make sharia law illegal in britain -0.281359 -0.360614 0.512299 -0.379726 0.617548 -0.437897 -0.151848 0.735133 -0.123312 0.652460 ... 0.011691 0.110862 1.000000 -0.020327 -0.226088 0.018787 0.389856 -0.082095 0.441467 -0.104566
Drop the plans to INCREASE tuition fees further and open more universities. 0.612902 0.537030 0.120037 0.480562 -0.347938 0.446428 0.667032 0.151690 0.343262 0.151288 ... 0.443548 -0.120063 -0.020327 1.000000 0.533453 0.049229 0.013033 0.608319 0.237998 0.613389
Ringfence the NHS from trade deals 0.761876 0.871368 -0.069709 0.744979 -0.417922 0.872606 0.918423 -0.140106 0.624733 -0.167385 ... 0.649228 0.267972 -0.226088 0.533453 1.000000 0.076313 -0.045980 0.645605 0.267122 0.884307
Make Eid a National Holiday 0.104963 0.154133 -0.094147 0.204371 -0.043841 0.099436 0.090083 -0.053903 -0.010616 -0.115219 ... -0.032723 -0.010296 0.018787 0.049229 0.076313 1.000000 -0.034888 -0.038817 -0.114140 0.041028
Increase the maximum sentence for animal cruelty charges -0.091412 -0.122433 0.349459 -0.147041 0.340313 -0.158326 -0.009413 0.344053 0.002824 0.298651 ... 0.049336 0.056256 0.389856 0.013033 -0.045980 -0.034888 1.000000 0.046854 0.285399 0.022937
Introduce mental health education to the national curriculum 0.546637 0.558500 0.217326 0.477240 -0.220248 0.555253 0.745127 0.058672 0.531539 0.075208 ... 0.479472 0.105424 -0.082095 0.608319 0.645605 -0.038817 0.046854 1.000000 0.320584 0.726025
Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. 0.087657 0.048411 0.418368 -0.078591 0.113388 0.009138 0.287263 0.505973 0.196834 0.598364 ... 0.613898 0.278143 0.441467 0.237998 0.267122 -0.114140 0.285399 0.320584 1.000000 0.406415
Reform the rules on filibustering or 'talking a bill to death'. 0.665693 0.746018 0.047320 0.628789 -0.302117 0.739426 0.903941 -0.017579 0.625434 -0.026394 ... 0.668429 0.298574 -0.104566 0.613389 0.884307 0.041028 0.022937 0.726025 0.406415 1.000000

100 rows × 100 columns

In [10]:
# Looks fine, let's sort by Trump support
correlation_matrix = top_petitions.set_index('action').loc[:, geo_columns].T.corr()
correlation_matrix.sort_values(correlation_matrix.columns[1], ascending=False)
Out[10]:
action EU Referendum Rules triggering a 2nd EU Referendum Prevent Donald Trump from making a State Visit to the United Kingdom. Give the Meningitis B vaccine to ALL children, not just newborn babies. Block Donald J Trump from UK entry Stop all immigration and close the UK borders until ISIS is defeated. Accept more asylum seekers and increase support for refugee migrants in the UK. Consider a vote of No Confidence in Jeremy Hunt, Health Secretary Donald Trump should make a State Visit to the United Kingdom. Make the production, sale and use of cannabis legal. Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid ... David Cameron to take serious diplomatic action against commercial whaling We demand GPs only decide who is fit to go back to work, not the DWP! Close sharia courts set up in the uk and make sharia law illegal in britain Drop the plans to INCREASE tuition fees further and open more universities. Ringfence the NHS from trade deals Make Eid a National Holiday Increase the maximum sentence for animal cruelty charges Introduce mental health education to the national curriculum Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. Reform the rules on filibustering or 'talking a bill to death'.
action
Prevent Donald Trump from making a State Visit to the United Kingdom. 0.931366 1.000000 -0.131018 0.955483 -0.564216 0.961378 0.864308 -0.182204 0.575654 -0.236920 ... 0.605445 0.067479 -0.360614 0.537030 0.871368 0.154133 -0.122433 0.558500 0.048411 0.746018
Accept more asylum seekers and increase support for refugee migrants in the UK. 0.849318 0.961378 -0.176744 0.894932 -0.519311 1.000000 0.849263 -0.285344 0.604976 -0.324957 ... 0.550122 0.162215 -0.437897 0.446428 0.872606 0.099436 -0.158326 0.555253 0.009138 0.739426
Make it illegal for a company to require women to wear high heels at work 0.935041 0.956393 -0.029944 0.902229 -0.494220 0.919059 0.851062 -0.078668 0.559986 -0.158817 ... 0.580267 -0.000764 -0.285145 0.560809 0.824293 0.102023 -0.062016 0.575660 0.050340 0.718681
Block Donald J Trump from UK entry 0.882331 0.955483 -0.169793 1.000000 -0.538675 0.894932 0.758069 -0.215380 0.558347 -0.284373 ... 0.481823 0.018865 -0.379726 0.480562 0.744979 0.204371 -0.147041 0.477240 -0.078591 0.628789
Cancel the planned referendum on Britain's continued membership of the EU. 0.902875 0.943572 -0.106130 0.854647 -0.501277 0.897386 0.844818 -0.099733 0.518743 -0.187853 ... 0.620086 0.053819 -0.254117 0.517552 0.877907 0.132570 -0.062595 0.508948 0.094773 0.738831
Britain must not turn its back on child refugees in Europe 0.850205 0.931836 -0.106712 0.821636 -0.517539 0.928787 0.884934 -0.158063 0.586254 -0.194643 ... 0.718748 0.157733 -0.316174 0.530620 0.928235 0.082355 -0.097940 0.594769 0.201129 0.837909
EU Referendum Rules triggering a 2nd EU Referendum 1.000000 0.931366 -0.001472 0.882331 -0.592924 0.849318 0.816593 -0.012481 0.479872 -0.062981 ... 0.626116 -0.138837 -0.281359 0.612902 0.761876 0.104963 -0.091412 0.546637 0.087657 0.665693
Scrap the £35k threshold for non-EU citizens settling in the UK 0.804991 0.923654 -0.230558 0.888652 -0.459485 0.919228 0.793758 -0.255342 0.544427 -0.357581 ... 0.445051 0.118708 -0.344460 0.430683 0.821198 0.156298 -0.118199 0.473944 -0.067904 0.678217
Make it illegal for any UK political figure to knowingly lie or mislead. 0.875991 0.904678 -0.021995 0.803790 -0.475062 0.862328 0.912971 -0.056388 0.615500 -0.091662 ... 0.698398 0.109842 -0.210204 0.622893 0.916679 0.094905 -0.038242 0.656519 0.273753 0.862859
Scrap plans forcing self employed & small business to do 4 tax returns yearly 0.865613 0.892541 0.047354 0.790864 -0.473697 0.842282 0.809146 0.038974 0.539052 -0.002397 ... 0.764320 0.057210 -0.177392 0.511954 0.859094 0.073903 -0.007318 0.523637 0.273494 0.745395
Save the Human Rights Act 0.764693 0.885242 -0.119269 0.780443 -0.402591 0.882648 0.906521 -0.184345 0.667250 -0.225191 ... 0.633490 0.309553 -0.237989 0.511772 0.961492 0.108352 -0.051847 0.616844 0.235351 0.878679
Jeremy Hunt to resume meaningful contract negotiations with the BMA. 0.849509 0.873082 0.015605 0.776858 -0.431809 0.847806 0.971918 -0.045507 0.572178 -0.082586 ... 0.592864 0.102823 -0.205392 0.691645 0.884819 0.084777 -0.033157 0.729352 0.205559 0.865034
Ringfence the NHS from trade deals 0.761876 0.871368 -0.069709 0.744979 -0.417922 0.872606 0.918423 -0.140106 0.624733 -0.167385 ... 0.649228 0.267972 -0.226088 0.533453 1.000000 0.076313 -0.045980 0.645605 0.267122 0.884307
Consider a vote of No Confidence in Jeremy Hunt, Health Secretary 0.816593 0.864308 0.042348 0.758069 -0.379656 0.849263 1.000000 -0.024259 0.619816 -0.053436 ... 0.631179 0.200106 -0.151848 0.667032 0.918423 0.090083 -0.009413 0.745127 0.287263 0.903941
Repeal the new Surveillance laws (Investigatory Powers Act) 0.747345 0.864261 -0.091235 0.827955 -0.337827 0.881467 0.856305 -0.181547 0.772355 -0.234710 ... 0.519468 0.271875 -0.271417 0.498766 0.847339 0.099990 -0.081005 0.640417 0.138672 0.812350
Ban all non-recyclable/non-compostable packaging in the UK 0.810730 0.858606 -0.052548 0.758625 -0.496359 0.833845 0.833144 -0.064959 0.580845 -0.080350 ... 0.788048 0.125538 -0.243242 0.500834 0.873871 0.047504 -0.065279 0.584384 0.316425 0.803648
No UK airstrikes on Syria. 0.679012 0.844942 -0.308371 0.871734 -0.452246 0.820774 0.714195 -0.393246 0.592076 -0.456445 ... 0.352226 0.201293 -0.403637 0.422629 0.760649 0.266340 -0.167289 0.452961 -0.115173 0.653572
The DDRB's proposals to change Junior Doctor's contracts CANNOT go ahead. 0.840368 0.841414 -0.080751 0.794018 -0.473387 0.810580 0.896530 -0.115952 0.528382 -0.165427 ... 0.470572 0.027069 -0.270193 0.650282 0.778174 0.102871 -0.089645 0.638756 0.048127 0.742002
To debate a vote of no confidence in Health Secretary the Right Hon Jeremy Hunt 0.777335 0.836277 -0.053129 0.749298 -0.400151 0.837782 0.960877 -0.116803 0.591637 -0.142235 ... 0.527165 0.210913 -0.220395 0.621407 0.872311 0.088434 -0.056171 0.698019 0.188372 0.846901
Parliament to sit on Saturdays which should be a "normal working day" for MPs. 0.807038 0.802555 0.131806 0.723108 -0.361854 0.761659 0.950874 0.075163 0.574365 0.050278 ... 0.592461 0.094031 -0.094746 0.700916 0.818935 0.078124 0.007945 0.752355 0.281322 0.852880
To make votes matter, adopt Proportional Representation for UK General Elections 0.726591 0.769159 0.079568 0.632449 -0.385933 0.738566 0.869801 0.086346 0.561006 0.087876 ... 0.838688 0.200753 -0.073126 0.618724 0.873960 0.029645 0.013657 0.698539 0.507928 0.904274
Include expressive arts subjects in the Ebacc 0.772641 0.753162 0.153579 0.632848 -0.365616 0.670429 0.834822 0.203352 0.481098 0.165856 ... 0.732301 0.032642 0.003268 0.702834 0.804579 0.090443 0.061069 0.631398 0.417663 0.801049
Reform the rules on filibustering or 'talking a bill to death'. 0.665693 0.746018 0.047320 0.628789 -0.302117 0.739426 0.903941 -0.017579 0.625434 -0.026394 ... 0.668429 0.298574 -0.104566 0.613389 0.884307 0.041028 0.022937 0.726025 0.406415 1.000000
Introduce a tax on sugary drinks in the UK to improve our children's health. 0.846268 0.725008 0.325142 0.658524 -0.407915 0.646336 0.699409 0.291286 0.431297 0.309215 ... 0.744047 -0.153640 -0.055954 0.576885 0.601587 -0.005053 0.064161 0.562805 0.367887 0.601120
Hold a public inquiry and a referendum over turning all schools into academies 0.680402 0.696199 0.163531 0.566691 -0.275352 0.633247 0.825334 0.141782 0.471063 0.106540 ... 0.613385 0.131959 0.028911 0.642211 0.809120 0.098073 0.069784 0.609926 0.356353 0.812878
Vote no on military action in Syria against IS in response to the Paris attacks 0.537622 0.683631 -0.324806 0.771689 -0.391272 0.604683 0.493553 -0.324262 0.345095 -0.401866 ... 0.201341 0.067692 -0.298694 0.315630 0.535735 0.375830 -0.156544 0.261664 -0.184029 0.431794
Hold a General Election in 2016 0.555093 0.679957 -0.060357 0.574294 -0.173123 0.676683 0.848298 -0.084555 0.652242 -0.141527 ... 0.502104 0.479564 -0.026927 0.512892 0.866507 0.128202 0.028463 0.594961 0.326263 0.854142
Enforce the Consumer Rights Act to protect music, arts and sport fans from touts 0.653390 0.677423 0.308168 0.645274 -0.055929 0.668521 0.720147 0.136803 0.670513 0.103023 ... 0.427661 0.208290 -0.022433 0.462319 0.638837 0.031668 0.109603 0.589269 0.226392 0.634985
Scrap plans to force state schools to become academies. 0.638246 0.643452 0.179022 0.516722 -0.239953 0.582183 0.796013 0.171919 0.425164 0.137438 ... 0.565043 0.123484 0.057611 0.649237 0.756672 0.104344 0.080362 0.592784 0.352389 0.772939
Stop retrospective changes to the student loans agreement 0.667388 0.635141 0.131312 0.574622 -0.316859 0.566796 0.810512 0.103236 0.521427 0.080059 ... 0.486874 -0.005716 -0.034017 0.809949 0.682693 0.068615 0.040254 0.740172 0.275837 0.780247
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Another Scottish independence referendum should not be allowed to happen -0.178676 0.006602 -0.156335 0.070728 0.045999 0.160743 -0.141260 -0.361638 0.168238 -0.274605 ... -0.063811 0.347487 -0.387516 -0.396254 -0.070322 -0.099832 -0.180236 -0.119545 -0.178537 -0.108606
Debate in the House the Local Government Pension Scheme Investment Regulations -0.088724 -0.044271 0.007882 -0.108946 0.096977 -0.052433 0.163168 0.115590 -0.029971 0.100412 ... 0.044514 0.219195 0.213636 0.151571 0.129476 0.046747 0.067184 0.157026 0.282212 0.226443
Introduce minimum prices that milk buyers purchase their milk for from Farmers -0.031046 -0.051017 -0.013654 -0.123570 -0.145243 -0.039052 -0.025323 0.147213 -0.084925 0.219202 ... 0.379926 0.025234 -0.030279 -0.018948 0.004001 -0.123087 -0.054624 -0.013306 0.385747 0.061700
No more school penalty fines and bring back the 10 day authorised absence -0.040370 -0.080872 0.349745 -0.031168 0.370994 -0.210129 0.014580 0.479956 -0.015128 0.396386 ... -0.037129 0.013506 0.580038 0.197809 -0.056909 0.129935 0.369478 0.026471 0.239045 0.011151
Increase the maximum sentence for animal cruelty charges -0.091412 -0.122433 0.349459 -0.147041 0.340313 -0.158326 -0.009413 0.344053 0.002824 0.298651 ... 0.049336 0.056256 0.389856 0.013033 -0.045980 -0.034888 1.000000 0.046854 0.285399 0.022937
Give the Meningitis B vaccine to ALL children, not just newborn babies. -0.001472 -0.131018 1.000000 -0.169793 0.394236 -0.176744 0.042348 0.646837 0.074567 0.658465 ... 0.144583 -0.055073 0.512299 0.120037 -0.069709 -0.094147 0.349459 0.217326 0.418368 0.047320
Ban the sale of fireworks to the public and only approve organised displays. -0.153606 -0.140430 0.143644 -0.145628 0.176218 -0.117449 -0.112803 0.096046 0.020097 0.175340 ... -0.030416 0.118855 0.121015 -0.098972 -0.111324 -0.068560 0.074356 -0.020654 0.115507 -0.082198
Make an allowance for up to 2 weeks term time leave from school for holiday. -0.060154 -0.143556 0.504027 -0.146480 0.452066 -0.272602 0.026899 0.615250 -0.046024 0.562289 ... 0.106556 0.005756 0.703540 0.177804 -0.050170 0.108282 0.451509 0.073535 0.437648 0.045935
STOP CAMERON spending British taxpayers’ money on Pro-EU Referendum leaflets 0.015693 -0.155878 0.636816 -0.213505 0.261659 -0.271704 0.021185 0.865908 -0.094783 0.891759 ... 0.410739 -0.117318 0.711823 0.213393 -0.081061 -0.059737 0.336257 0.129111 0.668605 0.075836
Give status to Police Dogs and Horses as 'Police Officers' -0.076578 -0.159809 0.488086 -0.181523 0.248215 -0.214189 -0.058930 0.485653 0.007687 0.524126 ... 0.139540 -0.028465 0.387690 0.098025 -0.119531 -0.089880 0.226172 0.128399 0.379910 0.001615
Force child cancer to the forefront of the NHS and government funding schemes. -0.153279 -0.160023 0.258034 -0.149116 0.285097 -0.153490 -0.092432 0.229907 -0.015280 0.203397 ... -0.106089 0.113584 0.191859 -0.080263 -0.130120 0.171179 0.077630 -0.026081 0.055392 -0.089250
Make the uk armed forces pensions for 22 years service tax free. -0.130734 -0.163035 0.168146 -0.189090 0.171709 -0.172043 -0.072701 0.310728 -0.042237 0.379238 ... 0.137695 0.035964 0.305325 -0.004712 -0.092586 -0.039226 0.056110 -0.059031 0.338759 -0.020172
Donald Trump should make a State Visit to the United Kingdom. -0.012481 -0.182204 0.646837 -0.215380 0.409563 -0.285344 -0.024259 1.000000 -0.094110 0.876402 ... 0.256251 -0.128221 0.735133 0.151690 -0.140106 -0.053903 0.344053 0.058672 0.505973 -0.017579
Make fair transitional state pension arrangements for 1950’s women -0.201174 -0.185199 0.314292 -0.280022 0.255206 -0.129331 0.010641 0.389464 -0.006968 0.509798 ... 0.242426 0.342545 0.270210 -0.058060 -0.010185 -0.136277 0.134824 0.060205 0.500927 0.087168
Close all retail on boxing day, retail isn't needed on boxing day! -0.192566 -0.199918 0.507670 -0.218412 0.557568 -0.197500 0.013928 0.300762 0.235748 0.276763 ... -0.084453 0.229131 0.476752 -0.009214 -0.037615 -0.073420 0.308553 0.135188 0.297179 0.066843
Introduce Compulsory Scanning for microchips by vets, rescues and authorities. -0.116013 -0.211124 0.480274 -0.277072 0.240123 -0.275230 -0.039359 0.567734 -0.075209 0.648082 ... 0.308660 0.015145 0.514883 0.089131 -0.080372 -0.092154 0.266095 0.077862 0.600772 0.051205
Put a max of £1200 on car insurance for 18-25 year olds -0.254612 -0.213361 -0.054973 -0.111209 0.316951 -0.265959 -0.223025 -0.023416 -0.084387 -0.166515 ... -0.494125 -0.000327 0.179540 -0.042205 -0.229997 0.241619 0.017984 -0.166954 -0.311991 -0.236222
Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid -0.062981 -0.236920 0.658465 -0.284373 0.277103 -0.324957 -0.053436 0.876402 -0.109889 1.000000 ... 0.295393 -0.132705 0.652460 0.151288 -0.167385 -0.115219 0.298651 0.075208 0.598364 -0.026394
Free childcare for 2 year olds to include parents who are both working full time -0.260270 -0.261691 0.167038 -0.275950 0.462711 -0.256087 -0.038851 0.239275 -0.059525 0.166277 ... -0.272253 0.320171 0.395818 -0.040636 -0.112849 0.080799 0.103940 -0.087393 0.075827 -0.050346
Ensure the British fishing waters are returned to the UK post Brexit -0.259599 -0.289544 0.242322 -0.335061 0.260000 -0.311270 -0.165045 0.486327 -0.184991 0.513038 ... 0.274935 0.136612 0.509101 -0.102958 -0.161229 -0.073780 0.209920 -0.100921 0.476157 -0.057473
Restrict the use of fireworks to reduce stress and fear in animals and pets -0.274594 -0.297514 0.511395 -0.339589 0.470038 -0.308845 -0.107265 0.518803 0.013278 0.605185 ... 0.180245 0.244180 0.517476 -0.065520 -0.143932 -0.107570 0.404340 0.091508 0.597833 -0.000519
April's Law -0.299277 -0.316032 0.005485 -0.366729 0.115635 -0.281569 -0.210997 -0.064722 -0.161430 0.014326 ... -0.141004 0.109553 0.055177 -0.225613 -0.153218 -0.099521 0.008209 -0.153356 0.083530 -0.159016
Invoke Article 50 of The Lisbon Treaty immediately. -0.226277 -0.326200 0.547994 -0.366188 0.557089 -0.422227 -0.111867 0.812685 -0.146023 0.731664 ... 0.111284 0.046458 0.888891 0.059311 -0.188436 0.018443 0.424965 -0.022999 0.528461 -0.051892
Stop car insurance companies ripping under 25s off with sky high prices -0.371314 -0.335506 0.125810 -0.269356 0.441310 -0.390771 -0.286484 0.147861 -0.160262 0.081105 ... -0.355294 0.041640 0.348249 -0.099590 -0.280645 0.136188 0.159789 -0.125444 -0.009802 -0.217251
Close sharia courts set up in the uk and make sharia law illegal in britain -0.281359 -0.360614 0.512299 -0.379726 0.617548 -0.437897 -0.151848 0.735133 -0.123312 0.652460 ... 0.011691 0.110862 1.000000 -0.020327 -0.226088 0.018787 0.389856 -0.082095 0.441467 -0.104566
Replace the unelected House of Lords with a publicly elected body -0.296461 -0.402536 0.556388 -0.456877 0.534411 -0.473514 -0.156833 0.830153 -0.205615 0.811365 ... 0.129074 0.047419 0.849320 0.014524 -0.236913 -0.040525 0.393859 -0.034112 0.592715 -0.083273
Stop allowing immigrants into the UK. -0.367042 -0.412059 0.537193 -0.393472 0.792577 -0.466677 -0.228012 0.677772 -0.109571 0.506160 ... -0.160731 0.090934 0.820675 -0.104837 -0.304059 0.036320 0.400489 -0.106766 0.245718 -0.180528
Make online abuse a specific criminal offence and create a register of offenders -0.433248 -0.416748 0.401372 -0.415412 0.774932 -0.363753 -0.207372 0.257046 0.132514 0.177109 ... -0.390473 0.401614 0.462569 -0.259902 -0.255856 -0.045527 0.222243 -0.114889 0.055934 -0.196207
Free childcare when both parents are working. Not just those who are on benefits -0.466488 -0.461408 0.402884 -0.470407 0.713887 -0.448016 -0.266152 0.357474 0.002439 0.285283 ... -0.280110 0.323700 0.560037 -0.217688 -0.297393 0.020571 0.198218 -0.140455 0.208006 -0.189341
Stop all immigration and close the UK borders until ISIS is defeated. -0.592924 -0.564216 0.394236 -0.538675 1.000000 -0.519311 -0.379656 0.409563 -0.032569 0.277103 ... -0.369008 0.324410 0.617548 -0.347938 -0.417922 -0.043841 0.340313 -0.220248 0.113388 -0.302117

100 rows × 100 columns

Download UK electoral borders

And join them in a single dataset

SELECT cartodb_id, pcon16cd as geoid, the_geom FROM javitonino.westminster_parliamentary_constituencies_december_2016_generali
UNION
SELECT cartodb_id + 1000 as cartodb_id, pc_id as geoid, the_geom FROM javitonino.osni_open_data_largescale_boundaries_westminster_parliamentary_
In [13]:
import cartoframes
from cartoframes.credentials import set_credentials
from cartoframes.credentials import credentials
import pandas as pd
import os

try:
    credentials()
    print('Getting the credentials from a previous session')
except Exception as e:
    print('Getting the credentials from your environment or here')
    BASEURL = os.environ.get('CARTO_API_URL','https://jsanz.carto.com') # <-- replace with your username or set up the envvar
    APIKEY = os.environ.get('CARTO_API_KEY',False) # <-- replace False with your CARTO API key or set up the envvar
    if BASEURL and APIKEY:
        set_credentials(base_url=BASEURL, api_key=APIKEY, overwrite=True)
    else:
        print('Set up your environment!')

if credentials():
    cc = cartoframes.CartoContext()
Getting the credentials from a previous session
In [17]:
boundaries = cc.query('''
SELECT cartodb_id, pcon16cd as geoid, the_geom FROM westminster_parliamentary_constituencies_december_2016_generali
UNION
SELECT cartodb_id + 1000 as cartodb_id, pc_id as geoid, the_geom FROM osni_open_data_largescale_boundaries_westminster_parliamentary_
''')
In [19]:
CF = cc
CF.write(boundaries, 'uk_boundaries', overwrite=True)
CF.map(layers=[
    cartoframes.BaseMap('light'),
    cartoframes.Layer('uk_boundaries'),
], interactive=True)
/home/jsanz/src/projects/geocampes17/env/lib/python3.5/site-packages/cartoframes/context.py:397: UserWarning: DataFrame written to CARTO but the table schema failed to update to match DataFrame. All columns in CARTO table have data type `text`. CARTO error: `['syntax error at end of input']`.
  query=alter_query))
Table successfully written to CARTO: https://jsanz.carto.com/dataset/uk_boundaries
Out[19]:
In [20]:
geopetitions = top_petitions.set_index('action').T.merge(boundaries, left_index=True, right_on='geoid')
geopetitions
Out[20]:
EU Referendum Rules triggering a 2nd EU Referendum Prevent Donald Trump from making a State Visit to the United Kingdom. Give the Meningitis B vaccine to ALL children, not just newborn babies. Block Donald J Trump from UK entry Stop all immigration and close the UK borders until ISIS is defeated. Accept more asylum seekers and increase support for refugee migrants in the UK. Consider a vote of No Confidence in Jeremy Hunt, Health Secretary Donald Trump should make a State Visit to the United Kingdom. Make the production, sale and use of cannabis legal. Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid ... Close sharia courts set up in the uk and make sharia law illegal in britain Drop the plans to INCREASE tuition fees further and open more universities. Ringfence the NHS from trade deals Make Eid a National Holiday Increase the maximum sentence for animal cruelty charges Introduce mental health education to the national curriculum Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. Reform the rules on filibustering or 'talking a bill to death'. geoid the_geom
cartodb_id
1 5283.0 2134.0 1625.0 749.0 1010.0 462.0 494.0 578.0 440.0 461.0 ... 129.0 90.0 66.0 20.0 74.0 66.0 82.0 69.0 E14000530 0106000020E610000001000000010300000001000000F3...
2 2329.0 897.0 1576.0 300.0 878.0 182.0 236.0 435.0 234.0 349.0 ... 67.0 59.0 32.0 12.0 70.0 39.0 51.0 33.0 E14000531 0106000020E61000000100000001030000000100000096...
3 10022.0 3393.0 1599.0 1060.0 464.0 932.0 808.0 528.0 340.0 479.0 ... 98.0 102.0 82.0 68.0 57.0 96.0 78.0 64.0 E14000532 0106000020E61000000100000001030000000100000012...
4 2843.0 1228.0 1432.0 343.0 995.0 226.0 284.0 483.0 266.0 356.0 ... 78.0 61.0 48.0 2.0 919.0 60.0 103.0 68.0 E14000533 0106000020E6100000010000000103000000010000009E...
5 8844.0 3482.0 1462.0 970.0 516.0 741.0 574.0 629.0 312.0 577.0 ... 75.0 98.0 99.0 5.0 72.0 85.0 134.0 102.0 E14000534 0106000020E610000003000000010300000002000000C3...
6 2463.0 1176.0 1483.0 345.0 1047.0 220.0 306.0 660.0 325.0 400.0 ... 102.0 52.0 41.0 6.0 325.0 55.0 91.0 46.0 E14000535 0106000020E61000000100000001030000000100000056...
7 6263.0 2492.0 2933.0 741.0 999.0 518.0 481.0 758.0 352.0 540.0 ... 122.0 99.0 67.0 33.0 98.0 91.0 109.0 70.0 E14000536 0106000020E610000001000000010300000001000000BB...
8 3069.0 1397.0 1130.0 497.0 1000.0 345.0 359.0 495.0 327.0 335.0 ... 97.0 106.0 58.0 75.0 83.0 61.0 70.0 50.0 E14000537 0106000020E610000001000000010300000001000000CE...
9 7206.0 3007.0 1747.0 1068.0 578.0 577.0 539.0 585.0 336.0 508.0 ... 78.0 98.0 73.0 140.0 82.0 87.0 85.0 94.0 E14000538 0106000020E61000000100000001030000000100000013...
11 8227.0 3358.0 1744.0 1021.0 637.0 757.0 621.0 590.0 482.0 480.0 ... 114.0 103.0 126.0 23.0 91.0 96.0 149.0 100.0 E14000539 0106000020E610000001000000010300000001000000F4...
14 5556.0 2556.0 905.0 1200.0 941.0 349.0 217.0 422.0 345.0 169.0 ... 117.0 72.0 44.0 593.0 93.0 39.0 31.0 21.0 E14000540 0106000020E61000000200000001030000000100000072...
15 2095.0 952.0 1116.0 257.0 874.0 224.0 325.0 444.0 235.0 245.0 ... 93.0 56.0 60.0 6.0 74.0 64.0 65.0 48.0 E14000541 0106000020E6100000010000000103000000010000003B...
16 1698.0 869.0 1166.0 232.0 1051.0 170.0 331.0 532.0 203.0 222.0 ... 117.0 51.0 37.0 3.0 104.0 46.0 51.0 44.0 E14000542 0106000020E6100000010000000103000000010000002B...
19 3293.0 1633.0 891.0 449.0 700.0 415.0 434.0 511.0 329.0 419.0 ... 73.0 56.0 61.0 5.0 53.0 86.0 72.0 68.0 E14000543 0106000020E610000004000000010300000001000000E8...
17 3657.0 1524.0 1893.0 520.0 1275.0 291.0 349.0 630.0 318.0 495.0 ... 113.0 46.0 44.0 19.0 217.0 74.0 52.0 37.0 E14000544 0106000020E61000000100000001030000000100000093...
20 6949.0 2671.0 1923.0 926.0 848.0 568.0 613.0 552.0 547.0 493.0 ... 133.0 123.0 78.0 35.0 89.0 106.0 105.0 85.0 E14000545 0106000020E610000001000000010300000001000000B1...
21 2942.0 1252.0 1287.0 382.0 1181.0 281.0 377.0 641.0 232.0 413.0 ... 126.0 64.0 53.0 7.0 90.0 41.0 78.0 49.0 E14000546 0106000020E6100000010000000103000000010000000C...
22 12595.0 5481.0 1311.0 1557.0 273.0 1391.0 1013.0 329.0 418.0 255.0 ... 43.0 288.0 175.0 30.0 59.0 132.0 109.0 159.0 E14000547 0106000020E610000001000000010300000001000000E1...
24 4202.0 2460.0 1290.0 968.0 893.0 478.0 370.0 591.0 214.0 316.0 ... 136.0 61.0 53.0 245.0 59.0 46.0 75.0 57.0 E14000548 0106000020E61000000100000001030000000100000002...
25 19290.0 7271.0 928.0 2346.0 219.0 1795.0 942.0 376.0 318.0 213.0 ... 43.0 67.0 123.0 137.0 66.0 80.0 42.0 112.0 E14000549 0106000020E6100000010000000103000000010000005F...
26 9101.0 3035.0 1401.0 1092.0 554.0 616.0 475.0 690.0 347.0 563.0 ... 82.0 104.0 58.0 31.0 66.0 66.0 66.0 62.0 E14000550 0106000020E610000001000000010300000001000000CB...
27 8350.0 3330.0 1579.0 989.0 464.0 735.0 559.0 532.0 342.0 460.0 ... 53.0 118.0 73.0 33.0 81.0 77.0 68.0 68.0 E14000551 0106000020E610000001000000010300000001000000C0...
23 5995.0 2758.0 1013.0 920.0 555.0 671.0 496.0 379.0 356.0 299.0 ... 66.0 61.0 64.0 126.0 68.0 113.0 66.0 63.0 E14000552 0106000020E61000000100000001030000000100000087...
12 17785.0 8525.0 842.0 2676.0 496.0 2098.0 1387.0 523.0 472.0 261.0 ... 64.0 172.0 210.0 228.0 77.0 110.0 44.0 148.0 E14000553 0106000020E61000000100000001030000000100000079...
13 3467.0 1774.0 951.0 455.0 565.0 402.0 385.0 484.0 206.0 405.0 ... 82.0 49.0 54.0 3.0 60.0 65.0 84.0 54.0 E14000554 0106000020E61000001B000000010300000001000000C8...
18 19041.0 11499.0 554.0 4194.0 230.0 2922.0 1388.0 297.0 569.0 146.0 ... 53.0 132.0 246.0 1354.0 49.0 108.0 48.0 143.0 E14000555 0106000020E61000000100000001030000000100000047...
28 4523.0 2004.0 1358.0 584.0 680.0 463.0 440.0 627.0 218.0 548.0 ... 127.0 57.0 58.0 4.0 64.0 58.0 110.0 76.0 E14000556 0106000020E610000003000000010300000001000000EF...
30 6328.0 2633.0 1563.0 791.0 615.0 520.0 489.0 690.0 314.0 661.0 ... 101.0 91.0 87.0 4.0 80.0 56.0 99.0 78.0 E14000557 0106000020E61000000100000001030000000100000041...
29 3723.0 1627.0 1849.0 513.0 868.0 313.0 313.0 614.0 276.0 426.0 ... 94.0 44.0 37.0 52.0 99.0 71.0 55.0 61.0 E14000558 0106000020E610000002000000010300000001000000BB...
31 4195.0 1860.0 1143.0 465.0 855.0 498.0 556.0 404.0 427.0 306.0 ... 95.0 54.0 84.0 33.0 66.0 51.0 105.0 66.0 E14000559 0106000020E61000000100000001030000000100000076...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
604 8047.0 3450.0 1283.0 875.0 354.0 854.0 686.0 393.0 370.0 375.0 ... 52.0 27.0 111.0 3.0 58.0 103.0 70.0 105.0 W07000051 0106000020E610000001000000010300000001000000D0...
605 1882.0 776.0 646.0 202.0 639.0 164.0 186.0 248.0 186.0 148.0 ... 51.0 53.0 42.0 6.0 77.0 26.0 56.0 37.0 W07000052 0106000020E610000001000000010300000001000000B4...
606 2600.0 1113.0 1246.0 278.0 673.0 230.0 220.0 309.0 312.0 250.0 ... 74.0 39.0 37.0 5.0 52.0 69.0 60.0 39.0 W07000053 0106000020E61000000100000001030000000100000084...
609 6040.0 2688.0 1030.0 641.0 419.0 649.0 439.0 467.0 296.0 375.0 ... 80.0 40.0 85.0 1.0 81.0 75.0 86.0 71.0 W07000054 0106000020E61000000100000001030000000100000064...
607 2994.0 1401.0 1049.0 400.0 601.0 278.0 233.0 322.0 361.0 254.0 ... 66.0 78.0 58.0 11.0 58.0 52.0 74.0 37.0 W07000055 0106000020E6100000020000000103000000010000007F...
612 4553.0 1909.0 1202.0 585.0 569.0 450.0 330.0 359.0 397.0 356.0 ... 67.0 20.0 88.0 3.0 72.0 83.0 70.0 55.0 W07000056 0106000020E6100000020000000103000000010000003B...
614 4520.0 1965.0 463.0 554.0 291.0 471.0 363.0 183.0 280.0 110.0 ... 29.0 28.0 99.0 1.0 30.0 62.0 57.0 58.0 W07000057 0106000020E61000000100000001030000000100000044...
616 3251.0 1328.0 502.0 362.0 458.0 315.0 256.0 309.0 214.0 276.0 ... 59.0 30.0 52.0 2.0 40.0 40.0 44.0 44.0 W07000058 0106000020E6100000010000000103000000010000008D...
617 3894.0 1522.0 804.0 379.0 596.0 312.0 297.0 367.0 247.0 311.0 ... 68.0 22.0 54.0 5.0 63.0 46.0 98.0 47.0 W07000059 0106000020E61000000100000001030000000100000011...
618 2823.0 1200.0 811.0 342.0 606.0 258.0 255.0 330.0 283.0 316.0 ... 70.0 48.0 44.0 1.0 59.0 43.0 71.0 36.0 W07000060 0106000020E61000000200000001030000000100000061...
619 3264.0 1339.0 457.0 346.0 369.0 290.0 205.0 255.0 163.0 196.0 ... 48.0 28.0 53.0 5.0 30.0 23.0 48.0 38.0 W07000061 0106000020E61000000E00000001030000000100000091...
621 2871.0 1289.0 930.0 351.0 612.0 295.0 246.0 338.0 211.0 210.0 ... 55.0 55.0 54.0 7.0 50.0 39.0 69.0 38.0 W07000062 0106000020E6100000010000000103000000010000005E...
622 3187.0 1610.0 499.0 393.0 388.0 377.0 241.0 319.0 246.0 211.0 ... 50.0 47.0 53.0 2.0 37.0 40.0 77.0 62.0 W07000063 0106000020E61000000100000001030000000100000090...
623 5352.0 2630.0 563.0 661.0 293.0 730.0 443.0 316.0 376.0 209.0 ... 50.0 32.0 117.0 1.0 71.0 58.0 84.0 129.0 W07000064 0106000020E61000000500000001030000000100000066...
624 3674.0 1813.0 807.0 387.0 365.0 350.0 289.0 352.0 292.0 271.0 ... 65.0 33.0 68.0 9.0 71.0 51.0 68.0 65.0 W07000065 0106000020E610000026000000010300000001000000AA...
625 3387.0 1561.0 605.0 399.0 387.0 349.0 241.0 376.0 273.0 303.0 ... 66.0 27.0 65.0 5.0 41.0 47.0 108.0 64.0 W07000066 0106000020E61000001200000001030000000100000018...
610 3454.0 1520.0 602.0 340.0 411.0 310.0 285.0 377.0 245.0 270.0 ... 87.0 25.0 61.0 1.0 68.0 52.0 88.0 49.0 W07000067 0106000020E61000000300000001030000000100000007...
611 4146.0 1965.0 622.0 461.0 327.0 538.0 323.0 401.0 229.0 253.0 ... 61.0 49.0 74.0 22.0 37.0 38.0 70.0 65.0 W07000068 0106000020E6100000010000000103000000010000003C...
615 2719.0 1154.0 753.0 283.0 626.0 251.0 281.0 326.0 251.0 267.0 ... 70.0 28.0 51.0 153.0 67.0 54.0 62.0 42.0 W07000069 0106000020E61000000100000001030000000100000024...
620 2218.0 906.0 617.0 186.0 548.0 185.0 179.0 251.0 213.0 161.0 ... 51.0 10.0 44.0 247.0 74.0 36.0 59.0 28.0 W07000070 0106000020E6100000010000000103000000010000005D...
596 2182.0 878.0 705.0 217.0 752.0 170.0 203.0 276.0 215.0 195.0 ... 64.0 33.0 27.0 NaN 130.0 32.0 63.0 28.0 W07000071 0106000020E61000000100000001030000000100000041...
608 1752.0 766.0 704.0 190.0 610.0 137.0 189.0 280.0 230.0 166.0 ... 63.0 31.0 38.0 NaN 86.0 38.0 56.0 28.0 W07000072 0106000020E610000001000000010300000001000000EC...
613 3855.0 1454.0 872.0 383.0 525.0 356.0 327.0 370.0 340.0 346.0 ... 72.0 33.0 55.0 NaN 75.0 54.0 79.0 49.0 W07000073 0106000020E6100000010000000103000000010000003A...
626 2527.0 1040.0 854.0 262.0 637.0 228.0 240.0 298.0 278.0 184.0 ... 47.0 24.0 51.0 NaN 66.0 30.0 71.0 30.0 W07000074 0106000020E61000000100000001030000000100000058...
627 4130.0 1670.0 1018.0 392.0 533.0 393.0 317.0 392.0 244.0 273.0 ... 66.0 27.0 65.0 NaN 77.0 48.0 84.0 48.0 W07000075 0106000020E61000000100000001030000000100000093...
628 3641.0 1418.0 1129.0 356.0 746.0 319.0 283.0 434.0 323.0 269.0 ... 89.0 39.0 57.0 NaN 113.0 73.0 76.0 37.0 W07000076 0106000020E61000000100000001030000000100000079...
629 2433.0 996.0 1017.0 278.0 760.0 275.0 266.0 319.0 310.0 245.0 ... 71.0 56.0 44.0 NaN 91.0 61.0 49.0 46.0 W07000077 0106000020E6100000010000000103000000010000002A...
630 5703.0 2383.0 1237.0 592.0 623.0 485.0 384.0 484.0 473.0 438.0 ... 85.0 42.0 70.0 NaN 89.0 72.0 99.0 59.0 W07000078 0106000020E610000001000000010300000001000000D8...
631 7994.0 3656.0 1055.0 936.0 403.0 910.0 568.0 301.0 388.0 258.0 ... 51.0 NaN 133.0 NaN 58.0 71.0 75.0 90.0 W07000079 0106000020E610000001000000010300000001000000B8...
632 8144.0 3948.0 1152.0 1100.0 583.0 882.0 626.0 401.0 495.0 351.0 ... 88.0 NaN 164.0 NaN 92.0 83.0 80.0 102.0 W07000080 0106000020E610000004000000010300000001000000BB...

650 rows × 102 columns

In [21]:
trump = geopetitions[['Prevent Donald Trump from making a State Visit to the United Kingdom.', 'the_geom', 'geoid']]
trump.columns = ['trump_haters', 'the_geom', 'geoid']
CF.write(trump, 'trump', overwrite=True)
Table successfully written to CARTO: https://jsanz.carto.com/dataset/trump
In [22]:
CF.map(layers=[
    cartoframes.BaseMap('light'),
    cartoframes.Layer('trump',
        color={'column': 'trump_haters',
               'scheme': cartoframes.styling.burg(5)}),
], interactive=True)
Out[22]:

Surprise! We have made a population map!

In [23]:
uk_pop = [{'numer_id': 'uk.ons.LC2102EW0001', 'normalization': 'prenormalized'}]
augmented = CF.data_augment('trump', uk_pop)
augmented
Out[23]:
geoid the_geom the_geom_webmercator total_pop_prenormalized_2011 trump_haters
cartodb_id
5 E14000534 0106000020E610000003000000010300000002000000C3... 0106000020110F000003000000010300000002000000C3... 97548.388368 3482
7 E14000536 0106000020E610000001000000010300000001000000BB... 0106000020110F000001000000010300000001000000BB... 112932.877706 2492
9 E14000538 0106000020E61000000100000001030000000100000013... 0106000020110F00000100000001030000000100000013... 107984.517415 3007
11 E14000539 0106000020E610000001000000010300000001000000F4... 0106000020110F000001000000010300000001000000F4... 117878.592352 3358
13 E14000554 0106000020E61000001B000000010300000001000000C8... 0106000020110F00001B000000010300000001000000C8... 75175.216114 1774
19 E14000543 0106000020E610000004000000010300000001000000E8... 0106000020110F000004000000010300000001000000E8... 88488.454196 1633
21 E14000546 0106000020E6100000010000000103000000010000000C... 0106000020110F0000010000000103000000010000000C... 103809.496298 1252
28 E14000556 0106000020E610000003000000010300000001000000EF... 0106000020110F000003000000010300000001000000EF... 99595.842745 2004
30 E14000557 0106000020E61000000100000001030000000100000041... 0106000020110F00000100000001030000000100000041... 100984.882537 2633
40 E14000569 0106000020E610000001000000010300000001000000CF... 0106000020110F000001000000010300000001000000CF... 87138.596992 1249
45 E14000573 0106000020E61000000100000001030000000100000057... 0106000020110F00000100000001030000000100000057... 81194.265802 963
51 E14000577 0106000020E6100000010000000103000000010000008E... 0106000020110F0000010000000103000000010000008E... 94466.888141 1029
54 E14000582 0106000020E6100000020000000103000000010000003A... 0106000020110F0000020000000103000000010000003A... 101557.412293 909
55 E14000583 0106000020E61000000100000001030000000100000006... 0106000020110F00000100000001030000000100000006... 98258.517758 1872
63 E14000590 0106000020E61000000100000001030000000100000014... 0106000020110F00000100000001030000000100000014... 97800.421399 1800
67 E14000595 0106000020E610000004000000010300000001000000AE... 0106000020110F000004000000010300000001000000AE... 106223.184144 2277
70 E14000596 0106000020E610000005000000010300000001000000D7... 0106000020110F000005000000010300000001000000D7... 86632.690852 1109
75 E14000603 0106000020E61000000100000001030000000100000052... 0106000020110F00000100000001030000000100000052... 95257.208433 2257
77 E14000605 0106000020E61000000100000001030000000100000046... 0106000020110F00000100000001030000000100000046... 94042.214050 2015
80 E14000608 0106000020E6100000010000000103000000010000008E... 0106000020110F0000010000000103000000010000008E... 98679.595447 3308
83 E14000610 0106000020E61000000100000001030000000100000064... 0106000020110F00000100000001030000000100000064... 102633.611044 1690
88 E14000615 0106000020E6100000010000000103000000010000006B... 0106000020110F0000010000000103000000010000006B... 125085.835946 9014
91 E14000616 0106000020E610000002000000010300000001000000BB... 0106000020110F000002000000010300000001000000BB... 85373.365793 2244
93 E14000619 0106000020E61000000200000001030000000100000003... 0106000020110F00000200000001030000000100000003... 109245.538050 4703
94 E14000620 0106000020E61000000200000001030000000100000000... 0106000020110F00000200000001030000000100000000... 85967.731170 1414
96 E14000623 0106000020E610000001000000010300000001000000E2... 0106000020110F000001000000010300000001000000E2... 88450.720649 3605
97 E14000625 0106000020E61000000100000001030000000100000060... 0106000020110F00000100000001030000000100000060... 94616.610564 1835
106 E14000633 0106000020E61000000500000001030000000100000022... 0106000020110F00000500000001030000000100000022... 104324.985789 3297
112 E14000637 0106000020E610000001000000010300000001000000F8... 0106000020110F000001000000010300000001000000F8... 94981.521990 1969
113 E14000638 0106000020E61000000400000001030000000100000047... 0106000020110F00000400000001030000000100000047... 83531.738886 1586
... ... ... ... ... ...
569 S14000030 0106000020E61000000100000001030000000100000093... 0106000020110F00000100000001030000000100000093... NaN 1314
570 S14000031 0106000020E6100000010000000103000000010000007E... 0106000020110F0000010000000103000000010000007E... NaN 5262
571 S14000032 0106000020E6100000010000000103000000010000007D... 0106000020110F0000010000000103000000010000007D... NaN 1851
572 S14000036 0106000020E61000000100000001030000000100000045... 0106000020110F00000100000001030000000100000045... NaN 1460
574 S14000038 0106000020E610000001000000010300000001000000D1... 0106000020110F000001000000010300000001000000D1... NaN 1540
581 S14000047 0106000020E610000001000000010300000001000000F6... 0106000020110F000001000000010300000001000000F6... NaN 1449
584 S14000044 0106000020E610000001000000010300000001000000B9... 0106000020110F000001000000010300000001000000B9... NaN 2523
588 S14000052 0106000020E610000001000000010300000001000000AD... 0106000020110F000001000000010300000001000000AD... NaN 2162
589 S14000053 0106000020E610000001000000010300000001000000BF... 0106000020110F000001000000010300000001000000BF... NaN 2062
592 S14000059 0106000020E610000001000000010300000001000000EF... 0106000020110F000001000000010300000001000000EF... NaN 1803
593 W07000041 0106000020E61000001F00000001030000000100000044... 0106000020110F00001F00000001030000000100000044... 68891.299673 1324
596 W07000071 0106000020E61000000100000001030000000100000041... 0106000020110F00000100000001030000000100000041... 75149.117508 878
597 W07000044 0106000020E610000001000000010300000001000000EE... 0106000020110F000001000000010300000001000000EE... 70724.400505 1151
600 W07000047 0106000020E610000001000000010300000001000000BB... 0106000020110F000001000000010300000001000000BB... 80601.306577 2441
601 W07000048 0106000020E610000001000000010300000001000000D0... 0106000020110F000001000000010300000001000000D0... 80553.347200 1128
602 W07000049 0106000020E61000000300000001030000000100000060... 0106000020110F00000300000001030000000100000060... 66126.041506 857
604 W07000051 0106000020E610000001000000010300000001000000D0... 0106000020110F000001000000010300000001000000D0... 88142.259990 3450
605 W07000052 0106000020E610000001000000010300000001000000B4... 0106000020110F000001000000010300000001000000B4... 69554.810204 776
606 W07000053 0106000020E61000000100000001030000000100000084... 0106000020110F00000100000001030000000100000084... 81160.067843 1113
607 W07000055 0106000020E6100000020000000103000000010000007F... 0106000020110F0000020000000103000000010000007F... 77758.819711 1401
608 W07000072 0106000020E610000001000000010300000001000000EC... 0106000020110F000001000000010300000001000000EC... 69776.205625 766
613 W07000073 0106000020E6100000010000000103000000010000003A... 0106000020110F0000010000000103000000010000003A... 79797.876583 1454
620 W07000070 0106000020E6100000010000000103000000010000005D... 0106000020110F0000010000000103000000010000005D... 68963.456604 906
626 W07000074 0106000020E61000000100000001030000000100000058... 0106000020110F00000100000001030000000100000058... 74790.374521 1040
627 W07000075 0106000020E61000000100000001030000000100000093... 0106000020110F00000100000001030000000100000093... 80441.140757 1670
628 W07000076 0106000020E61000000100000001030000000100000079... 0106000020110F00000100000001030000000100000079... 86926.264927 1418
629 W07000077 0106000020E6100000010000000103000000010000002A... 0106000020110F0000010000000103000000010000002A... 75489.186304 996
630 W07000078 0106000020E610000001000000010300000001000000D8... 0106000020110F000001000000010300000001000000D8... 97762.492924 2383
631 W07000079 0106000020E610000001000000010300000001000000B8... 0106000020110F000001000000010300000001000000B8... 90772.730506 3656
632 W07000080 0106000020E610000004000000010300000001000000BB... 0106000020110F000004000000010300000001000000BB... 107471.290627 3948

650 rows × 5 columns

In [24]:
augmented['trump_hater_percent'] = augmented['trump_haters'] / augmented['total_pop_prenormalized_2011']
augmented
Out[24]:
geoid the_geom the_geom_webmercator total_pop_prenormalized_2011 trump_haters trump_hater_percent
cartodb_id
5 E14000534 0106000020E610000003000000010300000002000000C3... 0106000020110F000003000000010300000002000000C3... 97548.388368 3482 0.035695
7 E14000536 0106000020E610000001000000010300000001000000BB... 0106000020110F000001000000010300000001000000BB... 112932.877706 2492 0.022066
9 E14000538 0106000020E61000000100000001030000000100000013... 0106000020110F00000100000001030000000100000013... 107984.517415 3007 0.027847
11 E14000539 0106000020E610000001000000010300000001000000F4... 0106000020110F000001000000010300000001000000F4... 117878.592352 3358 0.028487
13 E14000554 0106000020E61000001B000000010300000001000000C8... 0106000020110F00001B000000010300000001000000C8... 75175.216114 1774 0.023598
19 E14000543 0106000020E610000004000000010300000001000000E8... 0106000020110F000004000000010300000001000000E8... 88488.454196 1633 0.018454
21 E14000546 0106000020E6100000010000000103000000010000000C... 0106000020110F0000010000000103000000010000000C... 103809.496298 1252 0.012061
28 E14000556 0106000020E610000003000000010300000001000000EF... 0106000020110F000003000000010300000001000000EF... 99595.842745 2004 0.020121
30 E14000557 0106000020E61000000100000001030000000100000041... 0106000020110F00000100000001030000000100000041... 100984.882537 2633 0.026073
40 E14000569 0106000020E610000001000000010300000001000000CF... 0106000020110F000001000000010300000001000000CF... 87138.596992 1249 0.014333
45 E14000573 0106000020E61000000100000001030000000100000057... 0106000020110F00000100000001030000000100000057... 81194.265802 963 0.011860
51 E14000577 0106000020E6100000010000000103000000010000008E... 0106000020110F0000010000000103000000010000008E... 94466.888141 1029 0.010893
54 E14000582 0106000020E6100000020000000103000000010000003A... 0106000020110F0000020000000103000000010000003A... 101557.412293 909 0.008951
55 E14000583 0106000020E61000000100000001030000000100000006... 0106000020110F00000100000001030000000100000006... 98258.517758 1872 0.019052
63 E14000590 0106000020E61000000100000001030000000100000014... 0106000020110F00000100000001030000000100000014... 97800.421399 1800 0.018405
67 E14000595 0106000020E610000004000000010300000001000000AE... 0106000020110F000004000000010300000001000000AE... 106223.184144 2277 0.021436
70 E14000596 0106000020E610000005000000010300000001000000D7... 0106000020110F000005000000010300000001000000D7... 86632.690852 1109 0.012801
75 E14000603 0106000020E61000000100000001030000000100000052... 0106000020110F00000100000001030000000100000052... 95257.208433 2257 0.023694
77 E14000605 0106000020E61000000100000001030000000100000046... 0106000020110F00000100000001030000000100000046... 94042.214050 2015 0.021427
80 E14000608 0106000020E6100000010000000103000000010000008E... 0106000020110F0000010000000103000000010000008E... 98679.595447 3308 0.033523
83 E14000610 0106000020E61000000100000001030000000100000064... 0106000020110F00000100000001030000000100000064... 102633.611044 1690 0.016466
88 E14000615 0106000020E6100000010000000103000000010000006B... 0106000020110F0000010000000103000000010000006B... 125085.835946 9014 0.072063
91 E14000616 0106000020E610000002000000010300000001000000BB... 0106000020110F000002000000010300000001000000BB... 85373.365793 2244 0.026285
93 E14000619 0106000020E61000000200000001030000000100000003... 0106000020110F00000200000001030000000100000003... 109245.538050 4703 0.043050
94 E14000620 0106000020E61000000200000001030000000100000000... 0106000020110F00000200000001030000000100000000... 85967.731170 1414 0.016448
96 E14000623 0106000020E610000001000000010300000001000000E2... 0106000020110F000001000000010300000001000000E2... 88450.720649 3605 0.040757
97 E14000625 0106000020E61000000100000001030000000100000060... 0106000020110F00000100000001030000000100000060... 94616.610564 1835 0.019394
106 E14000633 0106000020E61000000500000001030000000100000022... 0106000020110F00000500000001030000000100000022... 104324.985789 3297 0.031603
112 E14000637 0106000020E610000001000000010300000001000000F8... 0106000020110F000001000000010300000001000000F8... 94981.521990 1969 0.020730
113 E14000638 0106000020E61000000400000001030000000100000047... 0106000020110F00000400000001030000000100000047... 83531.738886 1586 0.018987
... ... ... ... ... ... ...
569 S14000030 0106000020E61000000100000001030000000100000093... 0106000020110F00000100000001030000000100000093... NaN 1314 NaN
570 S14000031 0106000020E6100000010000000103000000010000007E... 0106000020110F0000010000000103000000010000007E... NaN 5262 NaN
571 S14000032 0106000020E6100000010000000103000000010000007D... 0106000020110F0000010000000103000000010000007D... NaN 1851 NaN
572 S14000036 0106000020E61000000100000001030000000100000045... 0106000020110F00000100000001030000000100000045... NaN 1460 NaN
574 S14000038 0106000020E610000001000000010300000001000000D1... 0106000020110F000001000000010300000001000000D1... NaN 1540 NaN
581 S14000047 0106000020E610000001000000010300000001000000F6... 0106000020110F000001000000010300000001000000F6... NaN 1449 NaN
584 S14000044 0106000020E610000001000000010300000001000000B9... 0106000020110F000001000000010300000001000000B9... NaN 2523 NaN
588 S14000052 0106000020E610000001000000010300000001000000AD... 0106000020110F000001000000010300000001000000AD... NaN 2162 NaN
589 S14000053 0106000020E610000001000000010300000001000000BF... 0106000020110F000001000000010300000001000000BF... NaN 2062 NaN
592 S14000059 0106000020E610000001000000010300000001000000EF... 0106000020110F000001000000010300000001000000EF... NaN 1803 NaN
593 W07000041 0106000020E61000001F00000001030000000100000044... 0106000020110F00001F00000001030000000100000044... 68891.299673 1324 0.019219
596 W07000071 0106000020E61000000100000001030000000100000041... 0106000020110F00000100000001030000000100000041... 75149.117508 878 0.011683
597 W07000044 0106000020E610000001000000010300000001000000EE... 0106000020110F000001000000010300000001000000EE... 70724.400505 1151 0.016274
600 W07000047 0106000020E610000001000000010300000001000000BB... 0106000020110F000001000000010300000001000000BB... 80601.306577 2441 0.030285
601 W07000048 0106000020E610000001000000010300000001000000D0... 0106000020110F000001000000010300000001000000D0... 80553.347200 1128 0.014003
602 W07000049 0106000020E61000000300000001030000000100000060... 0106000020110F00000300000001030000000100000060... 66126.041506 857 0.012960
604 W07000051 0106000020E610000001000000010300000001000000D0... 0106000020110F000001000000010300000001000000D0... 88142.259990 3450 0.039141
605 W07000052 0106000020E610000001000000010300000001000000B4... 0106000020110F000001000000010300000001000000B4... 69554.810204 776 0.011157
606 W07000053 0106000020E61000000100000001030000000100000084... 0106000020110F00000100000001030000000100000084... 81160.067843 1113 0.013714
607 W07000055 0106000020E6100000020000000103000000010000007F... 0106000020110F0000020000000103000000010000007F... 77758.819711 1401 0.018017
608 W07000072 0106000020E610000001000000010300000001000000EC... 0106000020110F000001000000010300000001000000EC... 69776.205625 766 0.010978
613 W07000073 0106000020E6100000010000000103000000010000003A... 0106000020110F0000010000000103000000010000003A... 79797.876583 1454 0.018221
620 W07000070 0106000020E6100000010000000103000000010000005D... 0106000020110F0000010000000103000000010000005D... 68963.456604 906 0.013137
626 W07000074 0106000020E61000000100000001030000000100000058... 0106000020110F00000100000001030000000100000058... 74790.374521 1040 0.013906
627 W07000075 0106000020E61000000100000001030000000100000093... 0106000020110F00000100000001030000000100000093... 80441.140757 1670 0.020761
628 W07000076 0106000020E61000000100000001030000000100000079... 0106000020110F00000100000001030000000100000079... 86926.264927 1418 0.016313
629 W07000077 0106000020E6100000010000000103000000010000002A... 0106000020110F0000010000000103000000010000002A... 75489.186304 996 0.013194
630 W07000078 0106000020E610000001000000010300000001000000D8... 0106000020110F000001000000010300000001000000D8... 97762.492924 2383 0.024375
631 W07000079 0106000020E610000001000000010300000001000000B8... 0106000020110F000001000000010300000001000000B8... 90772.730506 3656 0.040276
632 W07000080 0106000020E610000004000000010300000001000000BB... 0106000020110F000004000000010300000001000000BB... 107471.290627 3948 0.036735

650 rows × 6 columns

In [25]:
CF.write(augmented, 'trump_percent', overwrite=True)
CF.map(layers=[
    cartoframes.BaseMap('light'),
    cartoframes.Layer('trump_percent',
        color={'column': 'trump_hater_percent',
               'scheme': cartoframes.styling.burg(5)}),
], interactive=True)
Table successfully written to CARTO: https://jsanz.carto.com/dataset/trump_percent
Out[25]:
In [26]:
# Let's repeat the analysis, normalizing supporters by population before calculating correlation
# We did something silly, augment only the trump table. Let's fix that!
augmented_boundaries = boundaries.merge(augmented).set_index('geoid')
augmented_boundaries
Out[26]:
the_geom the_geom_webmercator total_pop_prenormalized_2011 trump_haters trump_hater_percent
geoid
E14000530 0106000020E610000001000000010300000001000000F3... 0106000020110F000001000000010300000001000000F3... 103906.766719 2134 0.020538
E14000531 0106000020E61000000100000001030000000100000096... 0106000020110F00000100000001030000000100000096... 76982.397326 897 0.011652
E14000532 0106000020E61000000100000001030000000100000012... 0106000020110F00000100000001030000000100000012... 96088.272831 3393 0.035311
E14000533 0106000020E6100000010000000103000000010000009E... 0106000020110F0000010000000103000000010000009E... 87938.049802 1228 0.013964
E14000534 0106000020E610000003000000010300000002000000C3... 0106000020110F000003000000010300000002000000C3... 97548.388368 3482 0.035695
E14000535 0106000020E61000000100000001030000000100000056... 0106000020110F00000100000001030000000100000056... 101888.620274 1176 0.011542
E14000536 0106000020E610000001000000010300000001000000BB... 0106000020110F000001000000010300000001000000BB... 112932.877706 2492 0.022066
E14000537 0106000020E610000001000000010300000001000000CE... 0106000020110F000001000000010300000001000000CE... 90202.012036 1397 0.015487
E14000538 0106000020E61000000100000001030000000100000013... 0106000020110F00000100000001030000000100000013... 107984.517415 3007 0.027847
E14000566 0106000020E6100000010000000103000000010000005C... 0106000020110F0000010000000103000000010000005C... 108144.175891 2087 0.019298
E14000539 0106000020E610000001000000010300000001000000F4... 0106000020110F000001000000010300000001000000F4... 117878.592352 3358 0.028487
E14000553 0106000020E61000000100000001030000000100000079... 0106000020110F00000100000001030000000100000079... 126345.942282 8525 0.067473
E14000554 0106000020E61000001B000000010300000001000000C8... 0106000020110F00001B000000010300000001000000C8... 75175.216114 1774 0.023598
E14000540 0106000020E61000000200000001030000000100000072... 0106000020110F00000200000001030000000100000072... 122390.655456 2556 0.020884
E14000541 0106000020E6100000010000000103000000010000003B... 0106000020110F0000010000000103000000010000003B... 85666.659951 952 0.011113
E14000542 0106000020E6100000010000000103000000010000002B... 0106000020110F0000010000000103000000010000002B... 89889.597027 869 0.009667
E14000544 0106000020E61000000100000001030000000100000093... 0106000020110F00000100000001030000000100000093... 89736.583829 1524 0.016983
E14000555 0106000020E61000000100000001030000000100000047... 0106000020110F00000100000001030000000100000047... 125430.816339 11499 0.091676
E14000543 0106000020E610000004000000010300000001000000E8... 0106000020110F000004000000010300000001000000E8... 88488.454196 1633 0.018454
E14000545 0106000020E610000001000000010300000001000000B1... 0106000020110F000001000000010300000001000000B1... 107739.226065 2671 0.024791
E14000546 0106000020E6100000010000000103000000010000000C... 0106000020110F0000010000000103000000010000000C... 103809.496298 1252 0.012061
E14000547 0106000020E610000001000000010300000001000000E1... 0106000020110F000001000000010300000001000000E1... 88744.297249 5481 0.061762
E14000552 0106000020E61000000100000001030000000100000087... 0106000020110F00000100000001030000000100000087... 101033.737861 2758 0.027298
E14000548 0106000020E61000000100000001030000000100000002... 0106000020110F00000100000001030000000100000002... 108324.750496 2460 0.022709
E14000549 0106000020E6100000010000000103000000010000005F... 0106000020110F0000010000000103000000010000005F... 106709.372614 7271 0.068138
E14000550 0106000020E610000001000000010300000001000000CB... 0106000020110F000001000000010300000001000000CB... 99586.051165 3035 0.030476
E14000551 0106000020E610000001000000010300000001000000C0... 0106000020110F000001000000010300000001000000C0... 87007.437585 3330 0.038273
E14000556 0106000020E610000003000000010300000001000000EF... 0106000020110F000003000000010300000001000000EF... 99595.842745 2004 0.020121
E14000558 0106000020E610000002000000010300000001000000BB... 0106000020110F000002000000010300000001000000BB... 87754.186722 1627 0.018540
E14000557 0106000020E61000000100000001030000000100000041... 0106000020110F00000100000001030000000100000041... 100984.882537 2633 0.026073
... ... ... ... ... ...
W07000062 0106000020E6100000010000000103000000010000005E... 0106000020110F0000010000000103000000010000005E... 71977.182047 1289 0.017908
W07000063 0106000020E61000000100000001030000000100000090... 0106000020110F00000100000001030000000100000090... 63719.815917 1610 0.025267
W07000064 0106000020E61000000500000001030000000100000066... 0106000020110F00000500000001030000000100000066... 75606.604497 2630 0.034785
W07000065 0106000020E610000026000000010300000001000000AA... 0106000020110F000026000000010300000001000000AA... 75909.203161 1813 0.023884
W07000066 0106000020E61000001200000001030000000100000018... 0106000020110F00001200000001030000000100000018... 76463.064960 1561 0.020415
W07000074 0106000020E61000000100000001030000000100000058... 0106000020110F00000100000001030000000100000058... 74790.374521 1040 0.013906
W07000075 0106000020E61000000100000001030000000100000093... 0106000020110F00000100000001030000000100000093... 80441.140757 1670 0.020761
W07000076 0106000020E61000000100000001030000000100000079... 0106000020110F00000100000001030000000100000079... 86926.264927 1418 0.016313
W07000077 0106000020E6100000010000000103000000010000002A... 0106000020110F0000010000000103000000010000002A... 75489.186304 996 0.013194
W07000078 0106000020E610000001000000010300000001000000D8... 0106000020110F000001000000010300000001000000D8... 97762.492924 2383 0.024375
W07000079 0106000020E610000001000000010300000001000000B8... 0106000020110F000001000000010300000001000000B8... 90772.730506 3656 0.040276
W07000080 0106000020E610000004000000010300000001000000BB... 0106000020110F000004000000010300000001000000BB... 107471.290627 3948 0.036735
N06000013 0106000020E61000001B00000001030000000100000006... 0106000020110F00001B00000001030000000100000006... NaN 1554 NaN
N06000017 0106000020E610000001000000010300000001000000FF... 0106000020110F000001000000010300000001000000FF... NaN 1031 NaN
N06000005 0106000020E6100000030000000103000000010000003C... 0106000020110F0000030000000103000000010000003C... NaN 1023 NaN
N06000012 0106000020E61000000600000001030000000100000061... 0106000020110F00000600000001030000000100000061... NaN 709 NaN
N06000015 0106000020E61000000B0000000103000000010000004D... 0106000020110F00000B0000000103000000010000004D... NaN 1281 NaN
N06000010 0106000020E61000000100000001030000000100000016... 0106000020110F00000100000001030000000100000016... NaN 585 NaN
N06000011 0106000020E610000001000000010300000001000000F8... 0106000020110F000001000000010300000001000000F8... NaN 852 NaN
N06000018 0106000020E6100000010000000103000000010000004D... 0106000020110F0000010000000103000000010000004D... NaN 631 NaN
N06000001 0106000020E610000001000000010300000001000000C8... 0106000020110F000001000000010300000001000000C8... NaN 1611 NaN
N06000003 0106000020E61000000100000001030000000100000091... 0106000020110F00000100000001030000000100000091... NaN 3333 NaN
N06000016 0106000020E61000000100000001030000000100000077... 0106000020110F00000100000001030000000100000077... NaN 871 NaN
N06000004 0106000020E61000000100000001030000000100000068... 0106000020110F00000100000001030000000100000068... NaN 945 NaN
N06000009 0106000020E610000001000000010300000001000000E8... 0106000020110F000001000000010300000001000000E8... NaN 1299 NaN
N06000014 0106000020E6100000010000000103000000010000005A... 0106000020110F0000010000000103000000010000005A... NaN 1017 NaN
N06000002 0106000020E6100000010000000103000000010000004F... 0106000020110F0000010000000103000000010000004F... NaN 1360 NaN
N06000006 0106000020E61000001500000001030000000100000010... 0106000020110F00001500000001030000000100000010... NaN 848 NaN
N06000007 0106000020E61000000100000001030000000100000072... 0106000020110F00000100000001030000000100000072... NaN 704 NaN
N06000008 0106000020E610000001000000010300000001000000A9... 0106000020110F000001000000010300000001000000A9... NaN 1346 NaN

650 rows × 5 columns

In [27]:
normalized_top_petitions = top_petitions.copy()
for col in geo_columns:
    normalized_top_petitions[col] /= max(min(augmented_boundaries.loc[col, 'total_pop_prenormalized_2011'],1),0)
normalized_top_petitions
Out[27]:
id action E14000530 E14000531 E14000532 E14000533 E14000534 E14000535 E14000536 E14000537 ... W07000072 W07000073 W07000074 W07000075 W07000076 W07000077 W07000078 W07000079 W07000080 sum
0 131215 EU Referendum Rules triggering a 2nd EU Refere... 5283.0 2329.0 10022.0 2843.0 8844.0 2463.0 6263.0 3069.0 ... 1752.0 3855.0 2527.0 4130.0 3641.0 2433.0 5703.0 7994.0 8144.0 3909222.0
1 171928 Prevent Donald Trump from making a State Visit... 2134.0 897.0 3393.0 1228.0 3482.0 1176.0 2492.0 1397.0 ... 766.0 1454.0 1040.0 1670.0 1418.0 996.0 2383.0 3656.0 3948.0 1791600.0
2 108072 Give the Meningitis B vaccine to ALL children,... 1625.0 1576.0 1599.0 1432.0 1462.0 1483.0 2933.0 1130.0 ... 704.0 872.0 854.0 1018.0 1129.0 1017.0 1237.0 1055.0 1152.0 801922.0
3 114003 Block Donald J Trump from UK entry 749.0 300.0 1060.0 343.0 970.0 345.0 741.0 497.0 ... 190.0 383.0 262.0 392.0 356.0 278.0 592.0 936.0 1100.0 561192.0
4 107516 Stop all immigration and close the UK borders ... 1010.0 878.0 464.0 995.0 516.0 1047.0 999.0 1000.0 ... 610.0 525.0 637.0 533.0 746.0 760.0 623.0 403.0 583.0 449944.0
5 105991 Accept more asylum seekers and increase suppor... 462.0 182.0 932.0 226.0 741.0 220.0 518.0 345.0 ... 137.0 356.0 228.0 393.0 319.0 275.0 485.0 910.0 882.0 435561.0
6 121152 Consider a vote of No Confidence in Jeremy Hun... 494.0 236.0 808.0 284.0 574.0 306.0 481.0 359.0 ... 189.0 327.0 240.0 317.0 283.0 266.0 384.0 568.0 626.0 331194.0
7 178844 Donald Trump should make a State Visit to the ... 578.0 435.0 528.0 483.0 629.0 660.0 758.0 495.0 ... 280.0 370.0 298.0 392.0 434.0 319.0 484.0 301.0 401.0 309427.0
8 104349 Make the production, sale and use of cannabis ... 440.0 234.0 340.0 266.0 312.0 325.0 352.0 327.0 ... 230.0 340.0 278.0 244.0 323.0 310.0 473.0 388.0 495.0 230962.0
9 125692 Stop spending a fixed 0.7 per cent slice of ou... 461.0 349.0 479.0 356.0 577.0 400.0 540.0 335.0 ... 166.0 346.0 184.0 273.0 269.0 245.0 438.0 258.0 351.0 229374.0
10 104334 To debate a vote of no confidence in Health Se... 312.0 140.0 625.0 220.0 354.0 248.0 293.0 242.0 ... 165.0 307.0 202.0 255.0 220.0 179.0 297.0 507.0 508.0 225944.0
11 113064 Vote no on military action in Syria against IS... 172.0 75.0 357.0 94.0 264.0 104.0 182.0 298.0 ... 65.0 123.0 76.0 136.0 126.0 87.0 215.0 461.0 507.0 222648.0
12 190627 Make online abuse a specific criminal offence ... 450.0 307.0 301.0 315.0 403.0 408.0 456.0 482.0 ... 340.0 296.0 335.0 352.0 399.0 356.0 356.0 365.0 453.0 217706.0
13 116762 STOP CAMERON spending British taxpayers’ money... 471.0 289.0 285.0 360.0 593.0 389.0 629.0 266.0 ... 166.0 271.0 213.0 189.0 280.0 247.0 319.0 207.0 239.0 216847.0
14 180642 Another Scottish independence referendum shoul... 136.0 69.0 117.0 83.0 146.0 71.0 141.0 72.0 ... 47.0 75.0 35.0 51.0 83.0 51.0 112.0 58.0 82.0 214510.0
16 173199 Repeal the new Surveillance laws (Investigator... 379.0 141.0 325.0 177.0 311.0 217.0 320.0 224.0 ... 146.0 242.0 188.0 245.0 230.0 188.0 277.0 331.0 451.0 208284.0
17 129698 No more school penalty fines and bring back th... 427.0 403.0 406.0 546.0 329.0 762.0 344.0 752.0 ... 53.0 73.0 51.0 65.0 55.0 37.0 83.0 103.0 135.0 200688.0
15 106477 Stop allowing immigrants into the UK. 438.0 386.0 237.0 438.0 258.0 527.0 472.0 373.0 ... 243.0 229.0 189.0 174.0 285.0 242.0 236.0 163.0 234.0 199130.0
18 104471 Vote no confidence in David Cameron 267.0 152.0 232.0 231.0 244.0 285.0 310.0 327.0 ... 228.0 248.0 232.0 286.0 271.0 249.0 298.0 371.0 445.0 194372.0
19 110776 Make fair transitional state pension arrangeme... 232.0 221.0 316.0 332.0 371.0 361.0 304.0 300.0 ... 131.0 259.0 162.0 224.0 259.0 186.0 300.0 247.0 270.0 187351.0
20 113231 No UK airstrikes on Syria. 204.0 89.0 269.0 93.0 280.0 95.0 224.0 190.0 ... 71.0 130.0 100.0 136.0 116.0 95.0 197.0 365.0 456.0 185510.0
21 166847 Put a max of £1200 on car insurance for 18-25 ... 320.0 261.0 354.0 238.0 192.0 268.0 243.0 517.0 ... 238.0 172.0 192.0 305.0 308.0 289.0 334.0 201.0 291.0 183960.0
22 122946 Hold a General Election in 2016 230.0 140.0 258.0 209.0 232.0 234.0 231.0 282.0 ... 173.0 233.0 213.0 264.0 239.0 198.0 274.0 317.0 394.0 172859.0
24 182953 Change the University fees from £9250 back to ... 160.0 175.0 366.0 115.0 138.0 76.0 175.0 215.0 ... 30.0 39.0 24.0 49.0 40.0 30.0 42.0 98.0 123.0 162254.0
23 168663 Ban the sale of fireworks to the public and on... 200.0 194.0 167.0 246.0 221.0 294.0 372.0 210.0 ... 278.0 414.0 325.0 366.0 477.0 323.0 450.0 345.0 408.0 161294.0
25 113491 Keep the NHS Bursary 263.0 171.0 242.0 154.0 201.0 165.0 283.0 284.0 ... 148.0 208.0 139.0 190.0 159.0 148.0 201.0 190.0 259.0 158870.0
26 124747 Hold a public inquiry and a referendum over tu... 278.0 139.0 329.0 193.0 442.0 178.0 206.0 184.0 ... 30.0 57.0 46.0 76.0 65.0 45.0 94.0 131.0 165.0 152558.0
28 126128 Call on David Cameron to act to protect our st... 145.0 117.0 207.0 162.0 209.0 180.0 154.0 207.0 ... 575.0 1310.0 911.0 489.0 545.0 646.0 548.0 699.0 746.0 150719.0
27 106651 Introduce a tax on sugary drinks in the UK to ... 265.0 132.0 297.0 153.0 408.0 124.0 297.0 84.0 ... 45.0 133.0 84.0 103.0 113.0 66.0 205.0 235.0 243.0 148056.0
30 124702 Scrap plans to force state schools to become a... 244.0 145.0 330.0 220.0 386.0 180.0 188.0 208.0 ... 29.0 55.0 46.0 58.0 53.0 49.0 86.0 134.0 108.0 147496.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
70 125604 Save the Human Rights Act 119.0 32.0 109.0 73.0 135.0 68.0 86.0 96.0 ... 45.0 72.0 62.0 94.0 92.0 56.0 101.0 191.0 203.0 79035.0
71 119416 Make it illegal for any UK political figure to... 94.0 39.0 161.0 65.0 148.0 52.0 127.0 71.0 ... 26.0 81.0 62.0 106.0 121.0 57.0 95.0 212.0 240.0 75273.0
72 128710 Lower university fees down to £3,000 104.0 86.0 69.0 49.0 70.0 46.0 140.0 83.0 ... 10.0 13.0 9.0 21.0 21.0 6.0 19.0 31.0 51.0 70941.0
73 170740 Suspend the Myanmar Ambassador for Genocide of... 30.0 21.0 164.0 4.0 6.0 6.0 19.0 137.0 ... 8.0 85.0 112.0 NaN NaN NaN NaN NaN NaN 70076.0
74 104379 Introduce Compulsory Scanning for microchips b... 133.0 111.0 70.0 109.0 195.0 153.0 164.0 78.0 ... 76.0 85.0 79.0 97.0 116.0 81.0 133.0 85.0 94.0 69301.0
75 122038 Cancel the end of Key Stage 2 SATs tests for 2016 90.0 116.0 128.0 126.0 172.0 144.0 87.0 103.0 ... 10.0 NaN NaN NaN NaN NaN NaN NaN NaN 69068.0
76 116943 Stop cuts to pharmacy funding and support phar... 85.0 75.0 178.0 84.0 107.0 67.0 112.0 84.0 ... 29.0 72.0 48.0 52.0 71.0 50.0 58.0 85.0 85.0 66612.0
78 120950 Stop car insurance companies ripping under 25s... 83.0 142.0 93.0 118.0 83.0 129.0 153.0 130.0 ... 150.0 83.0 90.0 121.0 150.0 122.0 171.0 100.0 156.0 63336.0
79 168391 Make tampons and sanitary towels free for females 125.0 59.0 80.0 63.0 90.0 76.0 91.0 74.0 ... 22.0 65.0 65.0 78.0 60.0 34.0 94.0 80.0 105.0 63218.0
77 117658 Start aid drops to the starving people of Syria 21.0 22.0 203.0 14.0 53.0 14.0 59.0 105.0 ... 9.0 30.0 9.0 22.0 23.0 14.0 35.0 119.0 204.0 63047.0
81 118690 Prevent the closure of Huddersfield A&E depart... 22.0 9.0 39.0 19.0 29.0 24.0 26.0 55.0 ... 13.0 15.0 12.0 10.0 12.0 6.0 17.0 13.0 15.0 62327.0
80 178330 Make the uk armed forces pensions for 22 years... 659.0 45.0 35.0 70.0 45.0 86.0 174.0 68.0 ... 50.0 108.0 104.0 56.0 91.0 71.0 215.0 48.0 70.0 61694.0
83 104880 Reverse the planned tax relief restriction on ... 106.0 32.0 160.0 25.0 137.0 31.0 104.0 31.0 ... 10.0 52.0 18.0 45.0 70.0 41.0 69.0 113.0 108.0 59432.0
82 123450 Cancel the planned referendum on Britain's con... 92.0 25.0 104.0 22.0 137.0 52.0 74.0 22.0 ... 14.0 38.0 23.0 51.0 47.0 34.0 75.0 131.0 133.0 58553.0
84 121888 Stop plans to make it a criminal offence to no... 89.0 92.0 78.0 65.0 73.0 69.0 164.0 84.0 ... 24.0 54.0 43.0 71.0 50.0 32.0 61.0 97.0 92.0 57372.0
86 105450 Introduce minimum prices that milk buyers purc... 51.0 22.0 68.0 61.0 134.0 54.0 86.0 33.0 ... 18.0 36.0 39.0 37.0 49.0 30.0 85.0 56.0 73.0 57068.0
85 106525 Reconsider the new Dividend Tax for small busi... 117.0 40.0 239.0 70.0 136.0 58.0 108.0 42.0 ... 10.0 45.0 26.0 41.0 36.0 11.0 51.0 81.0 66.0 57056.0
87 119876 Keep Performing Arts as an Option for GCSE/A L... 100.0 58.0 79.0 51.0 84.0 63.0 90.0 62.0 ... 22.0 82.0 27.0 46.0 60.0 35.0 73.0 69.0 85.0 56172.0
88 114073 Free childcare for 2 year olds to include pare... 103.0 102.0 143.0 73.0 36.0 165.0 68.0 240.0 ... 7.0 30.0 13.0 26.0 39.0 60.0 29.0 15.0 30.0 55803.0
89 185827 Ensure the British fishing waters are returned... 102.0 63.0 60.0 88.0 128.0 109.0 135.0 68.0 ... 56.0 81.0 73.0 63.0 79.0 53.0 104.0 42.0 63.0 55652.0
90 106992 David Cameron to take serious diplomatic actio... 82.0 40.0 77.0 75.0 180.0 56.0 77.0 48.0 ... 31.0 63.0 43.0 48.0 45.0 35.0 79.0 69.0 94.0 54353.0
92 117916 We demand GPs only decide who is fit to go bac... 65.0 38.0 47.0 74.0 65.0 118.0 68.0 120.0 ... 80.0 86.0 81.0 37.0 85.0 84.0 86.0 86.0 96.0 53775.0
91 160883 Close sharia courts set up in the uk and make ... 129.0 67.0 98.0 78.0 75.0 102.0 122.0 97.0 ... 63.0 72.0 47.0 66.0 89.0 71.0 85.0 51.0 88.0 52921.0
94 130519 Drop the plans to INCREASE tuition fees furthe... 90.0 59.0 102.0 61.0 98.0 52.0 99.0 106.0 ... 31.0 33.0 24.0 27.0 39.0 56.0 42.0 NaN NaN 52695.0
93 178082 Ringfence the NHS from trade deals 66.0 32.0 82.0 48.0 99.0 41.0 67.0 58.0 ... 38.0 55.0 51.0 65.0 57.0 44.0 70.0 133.0 164.0 52634.0
95 150516 Make Eid a National Holiday 20.0 12.0 68.0 2.0 5.0 6.0 33.0 75.0 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN 51597.0
96 131348 Increase the maximum sentence for animal cruel... 74.0 70.0 57.0 919.0 72.0 325.0 98.0 83.0 ... 86.0 75.0 66.0 77.0 113.0 91.0 89.0 58.0 92.0 51128.0
98 104545 Introduce mental health education to the natio... 66.0 39.0 96.0 60.0 85.0 55.0 91.0 61.0 ... 38.0 54.0 30.0 48.0 73.0 61.0 72.0 71.0 83.0 50314.0
97 161635 Call on Andrea Leadsom to NOT hold a vote to r... 82.0 51.0 78.0 103.0 134.0 91.0 109.0 70.0 ... 56.0 79.0 71.0 84.0 76.0 49.0 99.0 75.0 80.0 49824.0
99 111441 Reform the rules on filibustering or 'talking ... 69.0 33.0 64.0 68.0 102.0 46.0 70.0 50.0 ... 28.0 49.0 30.0 48.0 37.0 46.0 59.0 90.0 102.0 49586.0

100 rows × 653 columns

In [28]:
norm_correlation_matrix = normalized_top_petitions.set_index('action').loc[:, geo_columns].T.corr()
norm_correlation_matrix.sort_values(norm_correlation_matrix.columns[1], ascending=False)
Out[28]:
action EU Referendum Rules triggering a 2nd EU Referendum Prevent Donald Trump from making a State Visit to the United Kingdom. Give the Meningitis B vaccine to ALL children, not just newborn babies. Block Donald J Trump from UK entry Stop all immigration and close the UK borders until ISIS is defeated. Accept more asylum seekers and increase support for refugee migrants in the UK. Consider a vote of No Confidence in Jeremy Hunt, Health Secretary Donald Trump should make a State Visit to the United Kingdom. Make the production, sale and use of cannabis legal. Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid ... David Cameron to take serious diplomatic action against commercial whaling We demand GPs only decide who is fit to go back to work, not the DWP! Close sharia courts set up in the uk and make sharia law illegal in britain Drop the plans to INCREASE tuition fees further and open more universities. Ringfence the NHS from trade deals Make Eid a National Holiday Increase the maximum sentence for animal cruelty charges Introduce mental health education to the national curriculum Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. Reform the rules on filibustering or 'talking a bill to death'.
action
Prevent Donald Trump from making a State Visit to the United Kingdom. 0.953422 1.000000 -0.182156 0.957257 -0.602472 0.979369 0.867077 -0.270526 0.617536 -0.331255 ... 0.594356 0.045598 -0.484117 0.578997 0.865881 0.136223 -0.160865 0.542170 -0.020771 0.738238
Accept more asylum seekers and increase support for refugee migrants in the UK. 0.919662 0.979369 -0.176684 0.901611 -0.565361 1.000000 0.904141 -0.289005 0.617799 -0.342270 ... 0.583270 0.105171 -0.474580 0.580196 0.902503 0.103444 -0.153475 0.577646 0.003536 0.778223
Cancel the planned referendum on Britain's continued membership of the EU. 0.901647 0.960225 -0.179603 0.881035 -0.530820 0.961002 0.840650 -0.236672 0.597968 -0.321792 ... 0.609151 0.108730 -0.421292 0.489278 0.881214 0.104075 -0.120969 0.485864 0.014176 0.728285
Block Donald J Trump from UK entry 0.920327 0.957257 -0.213187 1.000000 -0.580478 0.901611 0.764441 -0.283524 0.585362 -0.368070 ... 0.463572 -0.043936 -0.479236 0.546636 0.738174 0.198136 -0.176622 0.465407 -0.154402 0.619179
Make it illegal for a company to require women to wear high heels at work 0.946935 0.956333 -0.078166 0.905592 -0.525652 0.946721 0.846320 -0.171322 0.610278 -0.256843 ... 0.564185 -0.006191 -0.418039 0.582508 0.813868 0.077309 -0.104817 0.555486 -0.026689 0.704480
EU Referendum Rules triggering a 2nd EU Referendum 1.000000 0.953422 -0.079873 0.920327 -0.631961 0.919662 0.809132 -0.156994 0.566050 -0.196695 ... 0.616874 -0.091853 -0.479081 0.587932 0.759787 0.069898 -0.160678 0.522928 -0.002720 0.653036
Britain must not turn its back on child refugees in Europe 0.863556 0.930941 -0.139269 0.818805 -0.536951 0.946399 0.895604 -0.229625 0.641427 -0.266142 ... 0.721826 0.185032 -0.416228 0.572839 0.931526 0.064596 -0.126460 0.584753 0.168034 0.844176
Scrap the £35k threshold for non-EU citizens settling in the UK 0.839931 0.927894 -0.257778 0.887746 -0.482433 0.928955 0.811494 -0.317183 0.579081 -0.431264 ... 0.435717 0.105363 -0.422862 0.496222 0.824957 0.150377 -0.136477 0.465114 -0.124190 0.680796
Make it illegal for any UK political figure to knowingly lie or mislead. 0.869343 0.918472 -0.105901 0.825512 -0.505629 0.929838 0.908758 -0.214459 0.715701 -0.238409 ... 0.685856 0.184577 -0.400281 0.597337 0.919878 0.058082 -0.109655 0.637779 0.193536 0.857382
Scrap plans forcing self employed & small business to do 4 tax returns yearly 0.866897 0.896278 -0.012464 0.798315 -0.498680 0.887313 0.797927 -0.066701 0.615950 -0.108834 ... 0.752000 0.087804 -0.328186 0.495221 0.852509 0.040751 -0.062928 0.498343 0.204466 0.730003
Jeremy Hunt to resume meaningful contract negotiations with the BMA. 0.842924 0.883202 -0.065935 0.793713 -0.458950 0.912450 0.971415 -0.202819 0.664489 -0.231325 ... 0.570912 0.165915 -0.399150 0.677763 0.885034 0.046514 -0.107043 0.715635 0.113266 0.857740
Save the Human Rights Act 0.766903 0.881141 -0.175738 0.774906 -0.424404 0.906908 0.909336 -0.290649 0.724066 -0.330243 ... 0.625069 0.356349 -0.356264 0.527683 0.963104 0.085259 -0.094157 0.603042 0.181495 0.877773
Repeal the new Surveillance laws (Investigatory Powers Act) 0.804150 0.877281 -0.094390 0.827484 -0.374663 0.883439 0.908472 -0.203890 0.803101 -0.267224 ... 0.548226 0.261612 -0.316530 0.626192 0.877399 0.097765 -0.088066 0.664730 0.131267 0.855648
Consider a vote of No Confidence in Jeremy Hunt, Health Secretary 0.809132 0.867077 -0.039845 0.764441 -0.405114 0.904141 1.000000 -0.175195 0.709927 -0.199283 ... 0.608954 0.265456 -0.332269 0.656735 0.917423 0.050362 -0.082602 0.732701 0.199885 0.898506
Ringfence the NHS from trade deals 0.759787 0.865881 -0.131988 0.738174 -0.439021 0.902503 0.917423 -0.261919 0.698026 -0.284387 ... 0.632006 0.323532 -0.367089 0.537980 1.000000 0.045913 -0.097990 0.629564 0.203590 0.880662
Ban all non-recyclable/non-compostable packaging in the UK 0.817692 0.852784 -0.097485 0.749615 -0.515571 0.857404 0.832000 -0.149983 0.652714 -0.164012 ... 0.781953 0.152893 -0.362684 0.518253 0.868108 0.020778 -0.106683 0.568895 0.273995 0.798269
No UK airstrikes on Syria. 0.715404 0.851935 -0.331401 0.878664 -0.480720 0.819994 0.738371 -0.444497 0.606339 -0.515533 ... 0.362586 0.173210 -0.463752 0.503616 0.772010 0.273594 -0.178085 0.455355 -0.151173 0.668445
The DDRB's proposals to change Junior Doctor's contracts CANNOT go ahead. 0.834316 0.848648 -0.148226 0.811055 -0.499177 0.859037 0.895548 -0.250592 0.598080 -0.290467 ... 0.450561 0.075541 -0.432824 0.651598 0.774056 0.075247 -0.147359 0.622777 -0.033609 0.732122
To debate a vote of no confidence in Health Secretary the Right Hon Jeremy Hunt 0.774858 0.830282 -0.121333 0.744260 -0.422727 0.867413 0.962161 -0.242674 0.655577 -0.263494 ... 0.507407 0.257501 -0.368403 0.636776 0.866512 0.057982 -0.113304 0.685949 0.113271 0.841908
Parliament to sit on Saturdays which should be a "normal working day" for MPs. 0.795937 0.811647 0.042917 0.740643 -0.389121 0.832262 0.947933 -0.091066 0.678961 -0.106537 ... 0.565916 0.163718 -0.302646 0.673632 0.815117 0.031535 -0.079708 0.741352 0.178600 0.845437
Include expressive arts subjects in the Ebacc 0.768454 0.810051 0.037064 0.702198 -0.412402 0.815690 0.843359 -0.004392 0.644995 -0.026660 ... 0.744426 0.162215 -0.266178 0.629216 0.838945 0.034351 -0.051902 0.624039 0.321360 0.814523
To make votes matter, adopt Proportional Representation for UK General Elections 0.709657 0.764121 0.002976 0.627056 -0.405584 0.787297 0.857168 -0.046513 0.661197 -0.036719 ... 0.831806 0.282258 -0.243436 0.596441 0.868661 -0.017302 -0.059041 0.683310 0.451797 0.899822
Hold a public inquiry and a referendum over turning all schools into academies 0.663009 0.746963 0.045129 0.628082 -0.307144 0.776779 0.833566 -0.090461 0.638032 -0.107169 ... 0.604831 0.295077 -0.240576 0.550063 0.846238 0.040744 -0.045397 0.600604 0.242796 0.830105
Reform the rules on filibustering or 'talking a bill to death'. 0.653036 0.738238 -0.021239 0.619179 -0.317944 0.778223 0.898506 -0.143646 0.706451 -0.148315 ... 0.649257 0.361310 -0.250548 0.607896 0.880662 0.004677 -0.038204 0.714232 0.345534 1.000000
Introduce a tax on sugary drinks in the UK to improve our children's health. 0.837284 0.724496 0.271865 0.664846 -0.434980 0.695973 0.673373 0.199456 0.508851 0.223689 ... 0.730791 -0.137998 -0.220155 0.544691 0.578435 -0.051540 -0.001186 0.537539 0.297089 0.573281
Scrap plans to force state schools to become academies. 0.615868 0.694241 0.055128 0.578471 -0.267661 0.731531 0.803733 -0.068726 0.597255 -0.084157 ... 0.549055 0.297497 -0.223263 0.551347 0.792419 0.044560 -0.041131 0.584129 0.230399 0.789111
Enforce the Consumer Rights Act to protect music, arts and sport fans from touts 0.693846 0.688701 0.278290 0.646849 -0.112619 0.701308 0.738680 0.104787 0.697057 0.042331 ... 0.425216 0.134827 -0.102209 0.504480 0.649994 0.010870 0.074893 0.600272 0.163851 0.638713
Vote no on military action in Syria against IS in response to the Paris attacks 0.531363 0.674926 -0.384775 0.774812 -0.411431 0.612129 0.472232 -0.436651 0.366856 -0.512319 ... 0.169056 0.060782 -0.408490 0.307490 0.516223 0.367769 -0.194470 0.232428 -0.265599 0.406783
Hold a General Election in 2016 0.529494 0.674626 -0.156437 0.571395 -0.191234 0.724825 0.837894 -0.251169 0.733070 -0.305178 ... 0.472487 0.590512 -0.187181 0.468859 0.867746 0.093479 -0.045446 0.571500 0.242580 0.846350
Stop retrospective changes to the student loans agreement 0.641544 0.672167 0.025048 0.633634 -0.345796 0.685625 0.815812 -0.115542 0.683731 -0.111476 ... 0.465846 0.131696 -0.291254 0.769793 0.697876 0.014295 -0.064354 0.748168 0.168849 0.793597
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Call on Andrea Leadsom to NOT hold a vote to repeal the Hunting Act 2004. -0.002720 -0.020771 0.352372 -0.154402 0.131322 0.003536 0.199885 0.427437 0.246406 0.531529 ... 0.581055 0.368501 0.341075 0.097314 0.203590 -0.182706 0.214645 0.264570 1.000000 0.345534
Introduce minimum prices that milk buyers purchase their milk for from Farmers -0.002187 -0.027350 0.014862 -0.115419 -0.179253 -0.028159 0.014100 0.221331 -0.076472 0.307589 ... 0.462966 0.049286 0.017610 0.034915 0.041357 -0.120414 -0.031255 0.022671 0.504640 0.110761
Debate in the House the Local Government Pension Scheme Investment Regulations -0.194261 -0.113980 -0.122057 -0.173688 0.127257 -0.055635 0.064738 -0.056266 0.004337 -0.074902 ... -0.067180 0.292081 0.062579 -0.008240 0.056747 -0.000595 -0.025367 0.088909 0.165281 0.145683
No more school penalty fines and bring back the 10 day authorised absence -0.205131 -0.158758 0.246323 -0.062990 0.483729 -0.200627 -0.148438 0.310071 0.071227 0.219706 ... -0.189572 0.174307 0.441707 -0.068417 -0.178088 0.069760 0.291049 -0.093763 0.070630 -0.127714
Increase the maximum sentence for animal cruelty charges -0.160678 -0.160865 0.299735 -0.176622 0.370009 -0.153475 -0.082602 0.267177 0.021874 0.215464 ... -0.009439 0.102407 0.318730 -0.118304 -0.097990 -0.070536 1.000000 -0.002832 0.214645 -0.038204
Force child cancer to the forefront of the NHS and government funding schemes. -0.163139 -0.167686 0.255513 -0.156424 0.279702 -0.157235 -0.105094 0.246860 -0.028160 0.208415 ... -0.116393 0.112653 0.201428 -0.105399 -0.138107 0.170547 0.068713 -0.031855 0.042164 -0.100271
Ban the sale of fireworks to the public and only approve organised displays. -0.149731 -0.170468 0.137507 -0.188724 0.149373 -0.156660 -0.133342 0.132303 -0.034971 0.200584 ... -0.047705 0.012433 0.157095 -0.090120 -0.133810 -0.069434 0.075880 -0.026958 0.105329 -0.106210
Make the uk armed forces pensions for 22 years service tax free. -0.153855 -0.180654 0.153748 -0.208136 0.184411 -0.173610 -0.096091 0.316076 -0.030964 0.384028 ... 0.114700 0.036717 0.313041 -0.041844 -0.112633 -0.049630 0.035418 -0.076888 0.340036 -0.039720
Give the Meningitis B vaccine to ALL children, not just newborn babies. -0.079873 -0.182156 1.000000 -0.213187 0.427341 -0.176684 -0.039845 0.615932 0.097243 0.616547 ... 0.085658 -0.038351 0.452992 -0.014428 -0.131988 -0.145954 0.299735 0.176016 0.352372 -0.021239
Give status to Police Dogs and Horses as 'Police Officers' -0.146241 -0.205442 0.443549 -0.220019 0.264774 -0.215634 -0.141219 0.432205 0.029822 0.469235 ... 0.078670 -0.013253 0.311440 -0.021086 -0.181663 -0.131988 0.169829 0.082562 0.313783 -0.066555
Put a max of £1200 on car insurance for 18-25 year olds -0.309098 -0.207026 -0.102415 -0.075713 0.334848 -0.239612 -0.251910 -0.113312 -0.067715 -0.254046 ... -0.535204 0.103104 0.129981 -0.132837 -0.242382 0.245644 -0.012554 -0.197573 -0.382894 -0.252559
Make fair transitional state pension arrangements for 1950’s women -0.221438 -0.245199 0.313833 -0.358947 0.263250 -0.197066 -0.014942 0.490648 -0.066703 0.585253 ... 0.234159 0.278352 0.344343 -0.050368 -0.039859 -0.150096 0.139626 0.049723 0.539155 0.067475
Close all retail on boxing day, retail isn't needed on boxing day! -0.266849 -0.246573 0.491240 -0.261753 0.595777 -0.218396 -0.041091 0.263967 0.235285 0.236978 ... -0.119659 0.291148 0.480218 -0.113395 -0.074881 -0.104980 0.286331 0.094772 0.268466 0.029091
STOP CAMERON spending British taxpayers’ money on Pro-EU Referendum leaflets -0.142673 -0.254431 0.607848 -0.292686 0.341228 -0.276037 -0.143806 0.826193 -0.030947 0.872636 ... 0.362538 0.001733 0.611641 -0.053291 -0.212367 -0.161351 0.248638 0.029809 0.624754 -0.050466
Make an allowance for up to 2 weeks term time leave from school for holiday. -0.268802 -0.260611 0.439519 -0.223077 0.626392 -0.287485 -0.167177 0.475322 0.047120 0.422474 ... -0.032459 0.198245 0.597712 -0.151514 -0.197577 0.034256 0.392756 -0.058417 0.311855 -0.111829
Donald Trump should make a State Visit to the United Kingdom. -0.156994 -0.270526 0.615932 -0.283524 0.480720 -0.289005 -0.175195 1.000000 -0.056371 0.851591 ... 0.182561 -0.022307 0.652457 -0.095916 -0.261919 -0.141246 0.267177 -0.044309 0.427437 -0.143646
Introduce Compulsory Scanning for microchips by vets, rescues and authorities. -0.238052 -0.297936 0.412509 -0.356670 0.273081 -0.293548 -0.172263 0.480424 -0.050765 0.576621 ... 0.238299 0.060432 0.407411 -0.111512 -0.180074 -0.162442 0.185406 -0.005632 0.532472 -0.053890
Free childcare for 2 year olds to include parents who are both working full time -0.339230 -0.299802 0.100970 -0.300032 0.497104 -0.252699 -0.104040 0.148524 -0.040828 0.070099 ... -0.344385 0.444974 0.335590 -0.179822 -0.159184 0.050649 0.045928 -0.141568 -0.006311 -0.104431
Stop spending a fixed 0.7 per cent slice of our national wealth on Foreign Aid -0.196695 -0.331255 0.616547 -0.368070 0.322788 -0.342270 -0.199283 0.851591 -0.081966 1.000000 ... 0.221680 -0.085471 0.560646 -0.063602 -0.284387 -0.200138 0.215464 -0.013322 0.531529 -0.148315
April's Law -0.339508 -0.343574 -0.049491 -0.398155 0.097990 -0.289234 -0.256238 -0.151774 -0.181228 -0.054621 ... -0.180041 0.123036 -0.008833 -0.316194 -0.180645 -0.116131 -0.025777 -0.183855 0.036712 -0.196515
Ensure the British fishing waters are returned to the UK post Brexit -0.343638 -0.361819 0.292667 -0.424420 0.386487 -0.353163 -0.237204 0.597164 -0.146814 0.616885 ... 0.265062 0.261943 0.633732 -0.214526 -0.226537 -0.107220 0.225318 -0.138332 0.564516 -0.112749
Stop car insurance companies ripping under 25s off with sky high prices -0.464032 -0.383768 0.040782 -0.301857 0.468604 -0.396993 -0.383358 0.022919 -0.163864 -0.051579 ... -0.460868 0.074504 0.265491 -0.256364 -0.348671 0.115703 0.099874 -0.184492 -0.124964 -0.297358
Restrict the use of fireworks to reduce stress and fear in animals and pets -0.346827 -0.385662 0.490883 -0.436999 0.487493 -0.370058 -0.198529 0.549202 -0.024093 0.617948 ... 0.126834 0.180327 0.536902 -0.169470 -0.222475 -0.149229 0.389750 0.049874 0.579710 -0.075005
Make online abuse a specific criminal offence and create a register of offenders -0.465404 -0.442228 0.429328 -0.439556 0.781666 -0.395999 -0.216569 0.318271 0.070352 0.218809 ... -0.392562 0.427374 0.563957 -0.305116 -0.262229 -0.043680 0.239350 -0.116774 0.070468 -0.199489
Invoke Article 50 of The Lisbon Treaty immediately. -0.463834 -0.473224 0.499497 -0.487341 0.728819 -0.465500 -0.322914 0.748227 -0.099922 0.659804 ... -0.011720 0.268761 0.855380 -0.289836 -0.354189 -0.069911 0.359780 -0.167652 0.447987 -0.216649
Free childcare when both parents are working. Not just those who are on benefits -0.517687 -0.479894 0.402360 -0.479135 0.732873 -0.453976 -0.291119 0.373985 -0.020672 0.294032 ... -0.292057 0.401988 0.622168 -0.302836 -0.308771 0.014900 0.189702 -0.155326 0.221598 -0.197354
Close sharia courts set up in the uk and make sharia law illegal in britain -0.479081 -0.484117 0.452992 -0.479236 0.745517 -0.474580 -0.332269 0.652457 -0.097155 0.560646 ... -0.114620 0.289265 1.000000 -0.325880 -0.367089 -0.052888 0.318730 -0.210562 0.341075 -0.250548
Stop allowing immigrants into the UK. -0.508554 -0.497598 0.492386 -0.460411 0.870583 -0.490558 -0.360545 0.614147 -0.113482 0.414546 ... -0.272582 0.186674 0.798957 -0.333093 -0.406323 -0.010239 0.347027 -0.199250 0.136162 -0.289684
Replace the unelected House of Lords with a publicly elected body -0.509182 -0.545874 0.501109 -0.585964 0.660620 -0.522406 -0.350569 0.775446 -0.190923 0.761999 ... 0.012766 0.208417 0.802428 -0.293787 -0.391805 -0.128624 0.320900 -0.161468 0.524815 -0.237712
Stop all immigration and close the UK borders until ISIS is defeated. -0.631961 -0.602472 0.427341 -0.580478 1.000000 -0.565361 -0.405114 0.480720 -0.121555 0.322788 ... -0.385541 0.320140 0.745517 -0.399613 -0.439021 -0.038543 0.370009 -0.236526 0.131322 -0.317944

100 rows × 100 columns

In [ ]: