kg
/
TypeScript-Test
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
TypeScript-Test/01 Einführung/Untitled1.ipynb

414 lines
12 KiB
Plaintext
Raw Permalink Blame History

{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "da1f2271-09ca-4665-9c88-d0e19defb876",
"metadata": {},
"outputs": [],
"source": [
"import pl from \"npm:nodejs-polars\";\n",
"import { display } from \"https://deno.land/x/display@v0.1.1/mod.ts\";"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "20c60624-0371-463e-98cf-42bc77377f5f",
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.dataresource+json": {
"data": [
{
"ActualExpenses": 216,
"ActualIncome": 255,
"BudgetExpenses": 217,
"BudgetIncome": 256,
"Consulting": 3,
"Date": "2022-03-22",
"DiffExpenses": 1,
"DiffIncome": 1,
"Equipment": 47,
"Expenses": 216,
"Hardware": 3,
"Income": 255,
"Marketing": 27,
"NetIncome": 39,
"Office Supplies": 3,
"R&D": 39,
"Rent": 41,
"Salaries": 20,
"Software": 3,
"Utilities": 30
},
{
"ActualExpenses": 225,
"ActualIncome": 317,
"BudgetExpenses": 226,
"BudgetIncome": 301,
"Consulting": 2,
"Date": "2022-01-24",
"DiffExpenses": 1,
"DiffIncome": -16,
"Equipment": 27,
"Expenses": 225,
"Hardware": 4,
"Income": 317,
"Marketing": 39,
"NetIncome": 92,
"Office Supplies": 3,
"R&D": 46,
"Rent": 34,
"Salaries": 32,
"Software": 4,
"Utilities": 34
},
{
"ActualExpenses": 239,
"ActualIncome": 287,
"BudgetExpenses": 237,
"BudgetIncome": 281,
"Consulting": 6,
"Date": "2022-07-17",
"DiffExpenses": -2,
"DiffIncome": -6,
"Equipment": 37,
"Expenses": 239,
"Hardware": 2,
"Income": 287,
"Marketing": 36,
"NetIncome": 48,
"Office Supplies": 5,
"R&D": 39,
"Rent": 46,
"Salaries": 38,
"Software": 6,
"Utilities": 24
},
{
"ActualExpenses": 227,
"ActualIncome": 264,
"BudgetExpenses": 229,
"BudgetIncome": 268,
"Consulting": 7,
"Date": "2022-03-06",
"DiffExpenses": 2,
"DiffIncome": 4,
"Equipment": 22,
"Expenses": 227,
"Hardware": 5,
"Income": 264,
"Marketing": 27,
"NetIncome": 37,
"Office Supplies": 2,
"R&D": 47,
"Rent": 32,
"Salaries": 45,
"Software": 3,
"Utilities": 37
},
{
"ActualExpenses": 212,
"ActualIncome": 276,
"BudgetExpenses": 206,
"BudgetIncome": 283,
"Consulting": 8,
"Date": "2022-03-18",
"DiffExpenses": -6,
"DiffIncome": 7,
"Equipment": 43,
"Expenses": 212,
"Hardware": 2,
"Income": 276,
"Marketing": 28,
"NetIncome": 64,
"Office Supplies": 2,
"R&D": 29,
"Rent": 27,
"Salaries": 29,
"Software": 2,
"Utilities": 42
},
{
"ActualExpenses": 259,
"ActualIncome": 294,
"BudgetExpenses": 257,
"BudgetIncome": 281,
"Consulting": 8,
"Date": "2022-06-10",
"DiffExpenses": -2,
"DiffIncome": -13,
"Equipment": 47,
"Expenses": 259,
"Hardware": 8,
"Income": 294,
"Marketing": 24,
"NetIncome": 35,
"Office Supplies": 6,
"R&D": 49,
"Rent": 48,
"Salaries": 40,
"Software": 4,
"Utilities": 25
},
{
"ActualExpenses": 216,
"ActualIncome": 317,
"BudgetExpenses": 210,
"BudgetIncome": 312,
"Consulting": 3,
"Date": "2022-02-04",
"DiffExpenses": -6,
"DiffIncome": -5,
"Equipment": 26,
"Expenses": 216,
"Hardware": 6,
"Income": 317,
"Marketing": 21,
"NetIncome": 101,
"Office Supplies": 6,
"R&D": 34,
"Rent": 27,
"Salaries": 44,
"Software": 7,
"Utilities": 42
},
{
"ActualExpenses": 213,
"ActualIncome": 233,
"BudgetExpenses": 212,
"BudgetIncome": 221,
"Consulting": 3,
"Date": "2022-06-13",
"DiffExpenses": -1,
"DiffIncome": -12,
"Equipment": 41,
"Expenses": 213,
"Hardware": 1,
"Income": 233,
"Marketing": 46,
"NetIncome": 20,
"Office Supplies": 1,
"R&D": 25,
"Rent": 44,
"Salaries": 20,
"Software": 9,
"Utilities": 23
},
{
"ActualExpenses": 242,
"ActualIncome": 305,
"BudgetExpenses": 240,
"BudgetIncome": 310,
"Consulting": 3,
"Date": "2022-03-11",
"DiffExpenses": -2,
"DiffIncome": 5,
"Equipment": 26,
"Expenses": 242,
"Hardware": 3,
"Income": 305,
"Marketing": 23,
"NetIncome": 63,
"Office Supplies": 9,
"R&D": 48,
"Rent": 34,
"Salaries": 39,
"Software": 8,
"Utilities": 49
},
{
"ActualExpenses": 205,
"ActualIncome": 248,
"BudgetExpenses": 199,
"BudgetIncome": 248,
"Consulting": 4,
"Date": "2022-01-28",
"DiffExpenses": -6,
"DiffIncome": 0,
"Equipment": 30,
"Expenses": 205,
"Hardware": 8,
"Income": 248,
"Marketing": 37,
"NetIncome": 43,
"Office Supplies": 5,
"R&D": 42,
"Rent": 25,
"Salaries": 26,
"Software": 4,
"Utilities": 24
}
],
"schema": {
"fields": [
{
"name": "Date",
"type": "string"
},
{
"name": "Income",
"type": "integer"
},
{
"name": "Expenses",
"type": "integer"
},
{
"name": "NetIncome",
"type": "integer"
},
{
"name": "BudgetIncome",
"type": "integer"
},
{
"name": "ActualIncome",
"type": "integer"
},
{
"name": "BudgetExpenses",
"type": "integer"
},
{
"name": "ActualExpenses",
"type": "integer"
},
{
"name": "Salaries",
"type": "integer"
},
{
"name": "R&D",
"type": "integer"
},
{
"name": "Marketing",
"type": "integer"
},
{
"name": "Utilities",
"type": "integer"
},
{
"name": "Rent",
"type": "integer"
},
{
"name": "Equipment",
"type": "integer"
},
{
"name": "Software",
"type": "integer"
},
{
"name": "Hardware",
"type": "integer"
},
{
"name": "Consulting",
"type": "integer"
},
{
"name": "Office Supplies",
"type": "integer"
},
{
"name": "DiffIncome",
"type": "integer"
},
{
"name": "DiffExpenses",
"type": "integer"
}
]
}
},
"text/html": [
"<table><thead><tr><th>Date</th><th>Income</th><th>Expenses</th><th>NetIncome</th><th>BudgetIncome</th><th>ActualIncome</th><th>BudgetExpenses</th><th>ActualExpenses</th><th>Salaries</th><th>R&amp;D</th><th>Marketing</th><th>Utilities</th><th>Rent</th><th>Equipment</th><th>Software</th><th>Hardware</th><th>Consulting</th><th>Office Supplies</th><th>DiffIncome</th><th>DiffExpenses</th></tr></thead><tbody><tr><td>2022-03-22</td><td>255</td><td>216</td><td>39</td><td>256</td><td>255</td><td>217</td><td>216</td><td>20</td><td>39</td><td>27</td><td>30</td><td>41</td><td>47</td><td>3</td><td>3</td><td>3</td><td>3</td><td>1</td><td>1</td></tr><tr><td>2022-01-24</td><td>317</td><td>225</td><td>92</td><td>301</td><td>317</td><td>226</td><td>225</td><td>32</td><td>46</td><td>39</td><td>34</td><td>34</td><td>27</td><td>4</td><td>4</td><td>2</td><td>3</td><td>-16</td><td>1</td></tr><tr><td>2022-07-17</td><td>287</td><td>239</td><td>48</td><td>281</td><td>287</td><td>237</td><td>239</td><td>38</td><td>39</td><td>36</td><td>24</td><td>46</td><td>37</td><td>6</td><td>2</td><td>6</td><td>5</td><td>-6</td><td>-2</td></tr><tr><td>2022-03-06</td><td>264</td><td>227</td><td>37</td><td>268</td><td>264</td><td>229</td><td>227</td><td>45</td><td>47</td><td>27</td><td>37</td><td>32</td><td>22</td><td>3</td><td>5</td><td>7</td><td>2</td><td>4</td><td>2</td></tr><tr><td>2022-03-18</td><td>276</td><td>212</td><td>64</td><td>283</td><td>276</td><td>206</td><td>212</td><td>29</td><td>29</td><td>28</td><td>42</td><td>27</td><td>43</td><td>2</td><td>2</td><td>8</td><td>2</td><td>7</td><td>-6</td></tr><tr><td>2022-06-10</td><td>294</td><td>259</td><td>35</td><td>281</td><td>294</td><td>257</td><td>259</td><td>40</td><td>49</td><td>24</td><td>25</td><td>48</td><td>47</td><td>4</td><td>8</td><td>8</td><td>6</td><td>-13</td><td>-2</td></tr><tr><td>2022-02-04</td><td>317</td><td>216</td><td>101</td><td>312</td><td>317</td><td>210</td><td>216</td><td>44</td><td>34</td><td>21</td><td>42</td><td>27</td><td>26</td><td>7</td><td>6</td><td>3</td><td>6</td><td>-5</td><td>-6</td></tr><tr><td>2022-06-13</td><td>233</td><td>213</td><td>20</td><td>221</td><td>233</td><td>212</td><td>213</td><td>20</td><td>25</td><td>46</td><td>23</td><td>44</td><td>41</td><td>9</td><td>1</td><td>3</td><td>1</td><td>-12</td><td>-1</td></tr><tr><td>2022-03-11</td><td>305</td><td>242</td><td>63</td><td>310</td><td>305</td><td>240</td><td>242</td><td>39</td><td>48</td><td>23</td><td>49</td><td>34</td><td>26</td><td>8</td><td>3</td><td>3</td><td>9</td><td>5</td><td>-2</td></tr><tr><td>2022-01-28</td><td>248</td><td>205</td><td>43</td><td>248</td><td>248</td><td>199</td><td>205</td><td>26</td><td>42</td><td>37</td><td>24</td><td>25</td><td>30</td><td>4</td><td>8</td><td>4</td><td>5</td><td>0</td><td>-6</td></tr></tbody></table>"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"let response = await fetch(\n",
" \"https://gist.githubusercontent.com/agustinustheo/195f32a4a6c68c493056c883d959ca35/raw/c7363d8b916ab00a2d1747adb89fca120da29f42/mock_financial_data.csv\",\n",
");\n",
"\n",
"let data = await response.text();\n",
"\n",
"let df = pl.readCSV(data, { sep: \",\" });\n",
"\n",
"await display(df.sample(10));"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "18396e24-7e98-40d8-8a2b-9ed9e2dd7e67",
"metadata": {
"editable": true,
"slideshow": {
"slide_type": ""
},
"tags": []
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"0\n",
"1\n",
"2\n",
"3\n",
"4\n",
"5\n",
"6\n",
"7\n",
"8\n",
"9\n"
]
}
],
"source": [
"for (let i = 0; i < 10; i++) {\n",
" console.log(i)\n",
"}"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "c5fd29b9-3704-4b9f-b26a-00a09c43dd27",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Deno",
"language": "typescript",
"name": "deno"
},
"language_info": {
"codemirror_mode": "typescript",
"file_extension": ".ts",
"mimetype": "text/x.typescript",
"name": "typescript",
"nbconvert_exporter": "script",
"pygments_lexer": "typescript",
"version": "5.8.3"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Reference in New Issue View Git Blame Copy Permalink