Last active
November 22, 2015 19:24
-
-
Save andr3w321/c18f2c8b00dbd76484b4 to your computer and use it in GitHub Desktop.
This file contains 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
import pandas as pd | |
import numpy as np | |
df = pd.read_csv('2005-srs.csv') | |
df_x = df.drop(['avg_mov'], axis=1) | |
df_srs = pd.DataFrame(np.linalg.solve(df_x.values, df['avg_mov'].values * -1.0), index=df_x.columns) | |
print df_srs |
This file contains 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
avg_mov | ARI | ATL | BAL | BUF | CAR | CHI | CIN | CLE | DAL | DEN | DET | GB | HOU | IND | JAC | KC | MIA | MIN | NE | NO | NYG | NYJ | OAK | PHI | PIT | SD | SEA | SF | STL | TB | TEN | WAS | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
-4.75 | -1.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.125 | 0.125 | 0.0 | 0.0625 | 0.0625 | |
0.63 | 0.0 | -1.0 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0 | |
-2.13 | 0.0 | 0.0 | -1.0 | 0.0 | 0.0 | 0.0625 | 0.125 | 0.125 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | |
-6.0 | 0.0 | 0.0625 | 0.0 | -1.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | |
8.25 | 0.0625 | 0.125 | 0.0 | 0.0625 | -1.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0 | |
3.63 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0625 | -1.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | |
4.44 | 0.0 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0625 | -1.0 | 0.125 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | |
-4.31 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0625 | 0.125 | -1.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | |
1.06 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | -1.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.125 | |
8.56 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | -1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | |
-5.69 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0625 | 0.0625 | 0.0 | -1.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | |
-2.88 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.125 | -1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | |
-10.69 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 | 0.125 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.125 | 0.0 | |
12.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | -1.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.125 | 0.0 | |
5.75 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.125 | -1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.125 | 0.0 | |
4.88 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | -1.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | |
0.06 | 0.0 | 0.0625 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | -1.0 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | |
-2.38 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | |
2.56 | 0.0 | 0.0625 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.125 | 0.0 | -1.0 | 0.0625 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | |
-10.19 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | -1.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.0 | |
6.75 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | -1.0 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.125 | |
-7.19 | 0.0 | 0.0625 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.125 | 0.0 | 0.125 | 0.0625 | 0.0 | -1.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | |
-5.81 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | -1.0 | 0.0625 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | |
-4.88 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0625 | -1.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.125 | |
8.19 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0 | 0.0625 | 0.125 | 0.125 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | |
6.63 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.125 | 0.0625 | 0.0625 | -1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | |
11.31 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | -1.0 | 0.125 | 0.125 | 0.0 | 0.0625 | 0.0625 | |
-11.81 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | -1.0 | 0.125 | 0.0625 | 0.0625 | 0.0625 | |
-4.13 | 0.125 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.125 | -1.0 | 0.0 | 0.0625 | 0.0625 | |
1.63 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | -1.0 | 0.0 | 0.0625 | |
-7.63 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.125 | 0.125 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0 | -1.0 | 0.0 | |
4.13 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.125 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0625 | 0.0 | 0.0 | 0.0 | 0.0 | 0.125 | 0.0 | 0.0625 | 0.125 | 0.0 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.0 | -1.0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment