Skip to content

Instantly share code, notes, and snippets.

View ls12styler's full-sized avatar

Ashley Broadley ls12styler

26 followers · 5 following
View GitHub Profile
@ls12styler
ls12styler / docker-compose.yml
Created April 21, 2020 15:43 — forked from brunosimioni/docker-compose.yml
Docker Compose to Prometheus, PushGateway and Grafana setup
version: '2.1'
networks:
monitor-net:
driver: bridge
volumes:
prometheus_data: {}
grafana_data: {}
@ls12styler
ls12styler / gist:6abffccad402741cda3f6586dbc2053b
Last active September 6, 2019 16:13
+-----------------------------------------+-------------+-----+
|Supplier |total |count|
+-----------------------------------------+-------------+-----+
|EUROPEAN SPACE AGENCY |56,098,583.99|3 |
|SCIENCE AND TECHNOLOGY FACILITIES COUNCIL|4,511,225.33 |4 |
|ECOMETRICA LTD |1,044,096.22 |2 |
+-----------------------------------------+-------------+-----+
@ls12styler
ls12styler / gist:3a59da3c863a23a51ecdf76027f80a93
Last active September 6, 2019 16:20
...
val supplierSpends = data.groupBy("Supplier")
.agg(
sum("Amount").as("total"),
count("Supplier").as("count")
)
.orderBy(desc("total"))
.limit(3)
.withColumn("total", format_number($"total", 2))
supplierSpends.show(false)
@ls12styler
ls12styler / gist:a63253c2b4639d504191231e0a4ca25f
Last active September 6, 2019 16:14
+-----------------------------------------+-------------+
|Supplier |total |
+-----------------------------------------+-------------+
|EUROPEAN SPACE AGENCY |56,098,583.99|
|SCIENCE AND TECHNOLOGY FACILITIES COUNCIL|4,511,225.33 |
|ECOMETRICA LTD |1,044,096.22 |
+-----------------------------------------+-------------+
@ls12styler
ls12styler / gist:5b55de2cb1cef83b2d6940e0ddba48d1
Last active September 6, 2019 16:16
...
val supplierSpends = data
.groupBy("Supplier")
.agg(sum("Amount").as("total"))
.orderBy(desc("total"))
.limit(3)
.withColumn("total", format_number($"total", 2))
supplierSpends.show(false)
...
@ls12styler
ls12styler / gist:47e7a269c6211296bc404dced5272a9d
Last active October 25, 2019 11:50
...
val expenses = data
.groupBy("Expense Type")
.agg(sum("Amount").as("total"))
.withColumn("total", format_number($"total", 2))
expenses.show(false)
...
@ls12styler
ls12styler / gist:ea5cad8df4f2d8ce638b013a32e999ed
Created August 29, 2019 11:22
+-------------+
| total|
+-------------+
|67,366,632.28|
+-------------+
@ls12styler
ls12styler / gist:906e14d0de38a7e04b581998c6772d38
Last active August 29, 2019 11:34
...
val totalSpend = data.agg(sum("Amount").as("total"))
.withColumn("total", format_number($"total", 2))
totalSpend.show(false)
...
@ls12styler
ls12styler / gist:5fb54573266b1cfe7822ac2cb068a011
Created August 29, 2019 11:21
+-------------------+
| total|
+-------------------+
|6.736663227999993E7|
+-------------------+
@ls12styler
ls12styler / gist:500641c7b695806d431b68e039b6e6dc
Last active August 29, 2019 11:33
...
val totalSpend = data.agg(sum("Amount").as("total"))
totalSpend.show(false)
...