Lecture 1: Introduction to Research — [📝Lecture Notebooks] [
Lecture 2: Introduction to Python — [📝Lecture Notebooks] [
Lecture 3: Introduction to NumPy — [📝Lecture Notebooks] [
Lecture 4: Introduction to pandas — [📝Lecture Notebooks] [
Lecture 5: Plotting Data — [📝Lecture Notebooks] [[
Anirudh anirudhXshetty
anirudhXshetty
/ list.md
Created
October 25, 2025 10:42
— forked from ih2502mk/list.md
Quantopian Lectures Saved
anirudhXshetty
/ Test.sql
Created
August 28, 2019 16:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --User list with their favourite stores ordered by rank based on number of visits. | |
| --Corresponding number for how often they visit on weekly basis for these 52 weeks. | |
| --How many days between next purchase in each store for a user. | |
| --Can be used out to filter and check users and stores for other features, | |
| --like total regular visitors, total visitors who have visited only once for a store etc.. | |
| WITH usr_str_visits AS ( | |
| SELECT | |
| user_id, | |
| store_id, |