Borut FlisData Discretization in SQLThe story describes how to use SQL to segment a continuous column into different categories. The process is analogous to the pandas…·2 min read·Feb 8, 2023----
Borut FlisinDev GeniusSQL Window Functions translated into pandasWe will first describe the abstract logic of window functions and then look at how they are implemented in SQL and in pandas. The article…·3 min read·Dec 23, 2022----
Borut FlisinDev GeniusCustom Math operations on Regex MatchesUse Python Regex to calculate numbers inside text·3 min read·Nov 16, 2022--1--1
Borut FlisinDev GeniusBacktesting Trading Strategy with PandasBacktesting is the process of evaluating the performance of a trading strategy on historical data. There will be a series of stories…·3 min read·Nov 5, 2022----
Borut FlisBitCoin price change in custom intervalsUse pandas to calculate BitCoin price change in custom time-intervals·2 min read·Jun 29, 2022--1--1
Borut FlisinDev GeniusFourier Transform on Bitcoin pricesLearn about the Fourier Transform and financial Time-Series·4 min read·Jan 11, 2022--2--2
Borut FlisinDev GeniusStreaks in Pandas Time-SeriesLearn how to find streaks of growth in Time-Series data·3 min read·Dec 15, 2021--2--2
Borut FlisinDev GeniusMust-know functions for Pandas Time-Series DataLearn how to select rows from Pandas Time-Series data·3 min read·Nov 24, 2021----
Borut FlisinDev GeniusImport Excel spreadsheets to Database with PandasThis tutorial shows how to insert data from an excel spreadsheet to a relational database. We use the pandas library, so this tutorial…·3 min read·Feb 26, 2021----
Borut FlisinDev GeniusPandas and DatesPandas is the most used Python library for data-analysis and manipulation. The basic Pandas entity is a Data-Frame. This post examines how…·2 min read·Feb 12, 2021----