Skip to content

Instantly share code, notes, and snippets.

View emkor's full-sized avatar

Mateusz Korzeniowski emkor

15 followers · 51 following
View GitHub Profile
@emkor
emkor / spotify_to_muspy.sh
Last active February 1, 2020 20:24
Semi-automated script for importing all artists from your Spotify playlists into muspy.com so you can follow their releases
#!/usr/bin/env bash
# use https://github.com/watsonbox/exportify to choose and download playlists as CSV into specific directory
# execute in that directory
# merge all downloaded playlist CSVs into one
for f in $(ls . | grep csv); do tail -n+2 $f >> ~/all_tracks.csv; done
# select only artists (starting and ending with quote characters)
cat ~/all_tracks.csv | awk -F "," '{print $3}' | sort | grep "^\".*\"$" > ~/all_artists.csv
@emkor
emkor / prefix_exiftool.py
Created February 22, 2020 14:41
Python script prefixing images/videos with UTC date and time parsed from their metadata (requires exiftool on PATH)
#!/usr/bin/env python3
"""Usage: prefix_exiftool.py <DIR WITH VIDEOS OR IMAGES>"""
import os
import sys
from datetime import datetime
from os import path, listdir
from typing import Collection, List, Any, Dict, Optional
import exiftool
@emkor
emkor / daily_price_avg.csv
Last active April 25, 2021 05:57
Map of Wroclaw-centric isochrones together with average price per square meter markers per village
Date PricePerM2 OfferCount
2020-04-18 88.0 130
2020-04-20 85.0 154
2020-04-29 85.0 149
2020-05-01 196.0 389
2020-05-03 193.0 386
2020-05-04 191.0 384
2020-05-06 130.0 623
2020-05-07 131.0 614
2020-05-08 131.0 608
@emkor
emkor / latest_offers.csv
Last active April 25, 2021 05:57
Map of property offers created in last 10 days
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 6.
Age,City,Location,PricePerSqM,Area,CheaperThanCityAvg,PriceDrop,ID,URL,Lat,Lon,TimeToWroclawMin,NetApCount,NetBwMin,NetBwAvg,NetBwMax
313,,"wielkopolskie, Nowe Miasto nad Wartą, Kruczyn",24.0,42.0,,0.0,morizon-9190067,https://www.morizon.pl/oferta/sprzedaz-dzialka-sredzki-nowe-miasto-nad-warta-kruczyn-4200m2-mzn2029327270,,,,,,,
86,,"dolnośląskie, Dobroszyce, Białe Błoto, Dobroszyce Holendry, Holendry",43.0,30.0,,0.0,morizon-39850/3877/OGS,https://www.morizon.pl/oferta/sprzedaz-dzialka-olesnicki-dobroszyce-holendry-3028m2-mzn2038082906,,,,,,,
86,,"dolnośląskie, Dobroszyce, Białe Błoto, Dobroszyce Holendry, Holendry",43.0,30.0,,0.0,morizon-39849/3877/OGS,https://www.morizon.pl/oferta/sprzedaz-dzialka-olesnicki-dobroszyce-holendry-3028m2-mzn2038337450,,,,,,,
86,,"dolnośląskie, Dobroszyce, Białe Błoto, Dobroszyce Holendry, Holendry",50.0,32.0,,0.0,morizon-39848/3877/OGS,https://www.morizon.pl/oferta/sprzedaz-dzialka-olesnicki-dobroszyce-holendry-3260m2-mzn2035411168,,,,,,,
219,,"wielkopolskie, Środa Wielkopolska