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…Feb 8, 2023Feb 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…Dec 23, 2022Dec 23, 2022
Borut FlisinDev GeniusCustom Math operations on Regex MatchesUse Python Regex to calculate numbers inside textNov 16, 20221Nov 16, 20221
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…Nov 5, 2022Nov 5, 2022
Borut FlisBitCoin price change in custom intervalsUse pandas to calculate BitCoin price change in custom time-intervalsJun 29, 20221Jun 29, 20221
Borut FlisinDev GeniusFourier Transform on Bitcoin pricesLearn about the Fourier Transform and financial Time-SeriesJan 11, 20222Jan 11, 20222
Borut FlisinDev GeniusStreaks in Pandas Time-SeriesLearn how to find streaks of growth in Time-Series dataDec 15, 20212Dec 15, 20212
Borut FlisinDev GeniusMust-know functions for Pandas Time-Series DataLearn how to select rows from Pandas Time-Series dataNov 24, 2021Nov 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…Feb 26, 2021Feb 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…Feb 12, 2021Feb 12, 2021