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