Intro
1
R
1.1
Create template tables
1.1.1
Template tables
1.1.2
Creating list-columns
1.2
Import & Export
1.2.1
Import
1.2.2
Export
1.3
Tidy & Transform
1.3.1
Cleaning
1.3.2
Expand
1.3.3
Join and Merge
1.3.4
Transforming data with Apply etc
1.3.5
Tally-function
1.3.6
Mapping over multiple arguments
1.4
Working with strings and characters
1.5
Visualize
1.5.1
Ggplots
1.5.2
Different tables
1.6
Misc
1.6.1
Create moving average function
1.6.2
Convert comma to dot
1.6.3
Reference column name using !!sym
1.6.4
Create Spread between two variables
1.6.5
Convert Column to List Vector
1.6.6
Crossing
1.6.7
Moving average
1.6.8
Number rows within group
1.6.9
Date Formating
1.6.10
Loops
1.7
R Markdown
1.7.1
Render multiple reports
1.8
Web Scraping
1.8.1
Scrape all sub page
1.8.2
Scrape PL table
1.8.3
Scrape all tables
1.8.4
Scrape title
1.9
Useful functions / expressions
1.9.1
Sub / Gsub
1.9.2
slice
1.9.3
unique
1.9.4
Map (purrr)
2
Excel & VBA
2.1
Import
2.1.1
Standard way to import file
2.1.2
Import file with conditions
2.2
Loops
2.2.1
For loop
2.3
Misc
2.3.1
Misc
2.4
Useful excel formulas
2.5
Useful Bloomberg formulas
3
FI & FX
3.1
Fixed Income
3.1.1
Bond Calculator in R
3.2
Foreign Exchange
4
SQL
4.1
General
4.1.1
SELECT
4.1.2
WHERE
4.1.3
GROUP BY
4.1.4
CASE statements
4.1.5
JOIN
4.2
Setting up a database
4.2.1
Creating tables
4.2.2
Creating views
4.2.3
Populating database
4.2.4
Connecting to database from R
4.3
Useful expressions
4.4
SQL databases and R
4.4.1
Connecting to a database from R
4.4.2
Running SQL syntax in R
5
HTML, CSS and JavaScript
5.1
HTML
5.2
CSS
5.3
JavaScript
5.3.1
Operators
5.3.2
Keywords
5.3.3
Anatomy
5.3.4
Functions and classes
5.3.5
Misc
5.3.6
Working with HTML Elements
5.3.7
DOM and events of JS
6
Python
6.1
Basic
6.1.1
Regular Expressions
6.1.2
Create temp table Pandas
6.1.3
Working with Text and Strings
6.1.4
Case_when equivalent in Python
6.2
Scrapy
6.2.1
Shell commands
6.2.2
Scrape table
6.2.3
Scrape table json treasury scraper
6.2.4
Scrape table json auction results Riksbank
6.2.5
Scrape table RiksbankAuctionScraper
6.2.6
BeautifulSoup
6.3
Misc
6.3.1
Python in R Markdown
7
Git
7.1
Basics
Templates
7
Git
7.1
Basics