Home
All courses
Data Science
Clustering Stock Industries

Introduction 1
- Lecture1.1
  
  Introduction
Getting the Data 3
- Lecture2.1
  
  Introduction
- Lecture2.2
  
  Getting Stock Data
- Lecture2.3
  
  Getting our Indicators
SP500 Webscrape 4
- Lecture3.1
  
  Introduction
- Lecture3.2
  
  Web Scraping
- Lecture3.3
  
  Web Scraping Part 2
- Lecture3.4
  
  Solution
Full Dataset 2
- Lecture4.1
  
  Introduction
- Lecture4.2
  
  The Full Dataset
Regressions 5
- Lecture5.1
  
  Introduction
- Lecture5.2
  
  Regression Into
- Lecture5.3
  
  Regression
- Lecture5.4
  
  Making the Beta Dataframe
- Lecture5.5
  
  Making the Beta Dataframe Part 2
Machine Learning 5
- Lecture6.1
  
  Introduction
- Lecture6.2
  
  Preparing the Data
- Lecture6.3
  
  Machine Learning
- Lecture6.4
  
  Updating the Dataframe
- Lecture6.5
  
  Updating the Dataframe Part 2
Machine Learning Function 2
- Lecture7.1
  
  Introduction
- Lecture7.2
  
  Solution
Visualize Data 2
- Lecture8.1
  
  Introduction
- Lecture8.2
  
  Visualization

Making the Beta Dataframe Part 2

Solution

df2 = pd.DataFrame()
for stock in df.columns[:-4]:
    frame = regress(stock)
    df2 = pd.concat([df2,frame], axis=1)
print(df2)

We do df.columns[:-4] so that we don’t run the regressions on our indicator variables (they’re the last four columns).

Save!

df2.to_csv("RegressionMatrix1.csv",encoding="UTF-8")

Source Code

Prev Making the Beta Dataframe

Next Introduction

Leave A Reply Cancel reply