In [1]:
from data.finance.LoadDataYahoo import (
LoadDataFromSQL,
LoadDataFromYahoo,
ClassificationStocks
)
In [12]:
'''
Main routines to update and maintain the company statistics.
Update S&p index
update stocks data:
query latestUpload, add one day, store to datetime object, provide as start Date,
set end date as current date
update company statistics, add date
Load information into dataFrame and timeseries
Make correlation and comparison
'''
runStockData = False
runCompanyStat = False
runGigsClassifier = False
engine = LoadDataFromSQL.sql
conn = engine.connect()
start = conn.execute(LoadDataFromYahoo.latestUpload).fetchone()
print ("Last updated: {}".format(start))
conn.close()
yahoo = LoadDataFromYahoo()
if runStockData:
yahoo.getDataFromYahoo(load_csv = False, reload = False, tableNameA = "SandP500_index_data", start = start)
print ("company data laoded")
if runCompanyStat:
'''
handle error records
'''
errorRecords = yahoo.loadAllCompanyDetailsToSQL()
print (errorRecords)
print ("company Stocks loaded")
if runGigsClassifier:
ClassificationStocks.storeGigsClassifier(reload = True)
print ("Gigs classifier reinitiated")
Last updated: (datetime.datetime(2017, 2, 16, 0, 0),)
In [5]:
'''
Companies at S&P500 index split based on sector.
'''
def testClassifier():
companies = ClassificationStocks.createDataSetsBasedOnGigs()
for count, item in enumerate(companies):
df = companies.get(item)
print ("\n\nDataset for {0} \n\n".format(item), df)
print ("\n\nDone")
testClassifier()
loading stocks to shared dataframe, recordset based on query:
SELECT distinct [GICS_Sector] FROM [finance].[dbo].[SandP500Index]
Dataset for Consumer Discretionary
symbol security SEC \
0 AAP Advance Auto Parts reports
1 BBBY Bed Bath & Beyond reports
2 BBY Best Buy Co. Inc. reports
3 BWA BorgWarner reports
4 CBS CBS Corp. reports
5 CCL Carnival Corp. reports
6 CMCSA Comcast A Corp reports
7 COH Coach Inc. reports
8 DG Dollar General reports
9 DHI D. R. Horton reports
10 DIS The Walt Disney Company reports
11 DLPH Delphi Automotive reports
12 DRI Darden Restaurants reports
13 EXPE Expedia Inc. reports
14 F Ford Motor reports
15 FL Foot Locker Inc reports
16 FOX Twenty-First Century Fox Class B reports
17 FOXA Twenty-First Century Fox Class A reports
18 GM General Motors reports
19 GPC Genuine Parts reports
20 GPS Gap (The) reports
21 GRMN Garmin Ltd. reports
22 GT Goodyear Tire & Rubber reports
23 HAR Harman Int'l Industries reports
24 HAS Hasbro Inc. reports
25 HBI Hanesbrands Inc reports
26 HD Home Depot reports
27 HOG Harley-Davidson reports
28 IPG Interpublic Group reports
29 JWN Nordstrom reports
30 KSS Kohl's Corp. reports
31 LEN Lennar Corp. reports
32 LOW Lowe's Cos. reports
33 M Macy's Inc. reports
34 MAR Marriott Int'l. reports
35 MAT Mattel Inc. reports
36 NKE Nike reports
37 NWL Newell Brands reports
38 OMC Omnicom Group reports
39 PHM Pulte Homes Inc. reports
40 PVH PVH Corp. reports
41 RCL Royal Caribbean Cruises Ltd reports
42 RL Polo Ralph Lauren Corp. reports
43 ROST Ross Stores reports
44 SBUX Starbucks Corp. reports
45 SIG Signet Jewelers reports
46 SNA Snap-On Inc. reports
47 SNI Scripps Networks Interactive Inc. reports
48 SWK Stanley Black & Decker reports
49 TGNA Tegna, Inc. reports
50 TGT Target Corp. reports
51 TIF Tiffany & Co. reports
52 TJX TJX Companies Inc. reports
53 TSCO Tractor Supply Company reports
54 TWX Time Warner Inc. reports
55 ULTA Ulta Salon Cosmetics & Fragrance Inc reports
56 VFC V.F. Corp. reports
57 WHR Whirlpool Corp. reports
58 VIAB Viacom Inc. reports
59 WYN Wyndham Worldwide reports
GICS_Sector GICS_subIndustry CIK \
0 Consumer Discretionary Automotive Retail 1158449
1 Consumer Discretionary Specialty Stores 886158
2 Consumer Discretionary Computer & Electronics Retail 764478
3 Consumer Discretionary Auto Parts & Equipment 908255
4 Consumer Discretionary Broadcasting & Cable TV 813828
5 Consumer Discretionary Hotels, Resorts & Cruise Lines 815097
6 Consumer Discretionary Cable & Satellite 1166691
7 Consumer Discretionary Apparel, Accessories & Luxury Goods 1116132
8 Consumer Discretionary General Merchandise Stores 29534
9 Consumer Discretionary Homebuilding 882184
10 Consumer Discretionary Broadcasting & Cable TV 1001039
11 Consumer Discretionary Auto Parts & Equipment 1521332
12 Consumer Discretionary Restaurants 940944
13 Consumer Discretionary Internet & Direct Marketing Retail 1324424
14 Consumer Discretionary Automobile Manufacturers 37996
15 Consumer Discretionary Apparel Retail 850209
16 Consumer Discretionary Publishing 1308161
17 Consumer Discretionary Publishing 1308161
18 Consumer Discretionary Automobile Manufacturers 1467858
19 Consumer Discretionary Specialty Stores 40987
20 Consumer Discretionary Apparel Retail 39911
21 Consumer Discretionary Consumer Electronics 1121788
22 Consumer Discretionary Tires & Rubber 42582
23 Consumer Discretionary Consumer Electronics 800459
24 Consumer Discretionary Leisure Products 46080
25 Consumer Discretionary Apparel, Accessories & Luxury Goods 1359841
26 Consumer Discretionary Home Improvement Retail 354950
27 Consumer Discretionary Motorcycle Manufacturers 793952
28 Consumer Discretionary Advertising 51644
29 Consumer Discretionary Department Stores 72333
30 Consumer Discretionary General Merchandise Stores 885639
31 Consumer Discretionary Homebuilding 920760
32 Consumer Discretionary Home Improvement Retail 60667
33 Consumer Discretionary Department Stores 794367
34 Consumer Discretionary Hotels, Resorts & Cruise Lines 1048286
35 Consumer Discretionary Leisure Products 63276
36 Consumer Discretionary Apparel, Accessories & Luxury Goods 320187
37 Consumer Discretionary Housewares & Specialties 814453
38 Consumer Discretionary Advertising 29989
39 Consumer Discretionary Homebuilding 822416
40 Consumer Discretionary Apparel, Accessories & Luxury Goods 78239
41 Consumer Discretionary Hotels, Resorts & Cruise Lines 884887
42 Consumer Discretionary Apparel, Accessories & Luxury Goods 1037038
43 Consumer Discretionary Apparel Retail 745732
44 Consumer Discretionary Restaurants 829224
45 Consumer Discretionary Specialty Stores 832988
46 Consumer Discretionary Household Appliances 91440
47 Consumer Discretionary Broadcasting & Cable TV 1430602
48 Consumer Discretionary Household Appliances 93556
49 Consumer Discretionary Publishing 39899
50 Consumer Discretionary General Merchandise Stores 27419
51 Consumer Discretionary Apparel, Accessories & Luxury Goods 98246
52 Consumer Discretionary Apparel Retail 109198
53 Consumer Discretionary Specialty Retail 916365
54 Consumer Discretionary Broadcasting & Cable TV 1105705
55 Consumer Discretionary Specialty Stores 1403568
56 Consumer Discretionary Apparel, Accessories & Luxury Goods 103379
57 Consumer Discretionary Household Appliances 106640
58 Consumer Discretionary Broadcasting & Cable TV 1339947
59 Consumer Discretionary Hotels, Resorts & Cruise Lines 1361658
marketCapital bookValue ebitda dividentShare DividentYield \
0 1.209000e+10 38.78 1.160000e+09 0.24 0.15
1 5.920000e+09 17.82 1.500000e+09 0.50 1.26
2 1.397000e+10 13.61 2.480000e+09 1.12 2.58
3 8.700000e+09 17.42 1.480000e+09 0.53 1.31
4 2.771000e+10 12.24 3.350000e+09 0.72 1.11
5 4.021000e+10 31.12 4.760000e+09 1.40 2.49
6 1.817600e+11 22.38 2.642000e+10 0.63 0.83
7 1.047000e+10 9.73 8.871000e+08 1.35 3.79
8 2.039000e+10 19.41 2.370000e+09 1.00 1.42
9 1.113000e+10 18.70 1.520000e+09 0.40 1.29
10 1.761000e+11 27.09 1.699000e+10 1.56 1.43
11 1.897000e+10 9.41 2.710000e+09 1.16 1.63
12 9.100000e+09 14.93 9.302000e+08 2.24 3.05
13 1.824000e+10 25.91 1.020000e+09 1.04 0.85
14 4.912000e+10 7.92 1.544000e+10 0.60 4.80
15 9.070000e+09 19.89 1.140000e+09 1.10 1.62
16 5.753000e+10 7.44 6.690000e+09 0.36 1.17
17 5.822000e+10 7.44 6.690000e+09 0.36 1.15
18 5.581000e+10 29.81 1.866000e+10 1.52 4.11
19 1.440000e+10 22.34 1.240000e+09 2.63 2.72
20 9.190000e+09 6.83 1.980000e+09 0.92 4.07
21 9.100000e+09 17.84 6.923700e+08 2.04 4.16
22 8.460000e+09 17.15 2.350000e+09 0.34 1.09
23 7.770000e+09 36.87 8.603500e+08 1.40 1.26
24 1.030000e+10 13.94 9.406000e+08 2.04 2.47
25 8.960000e+09 3.14 9.867600e+08 0.60 2.62
26 1.675900e+11 4.61 1.493000e+10 2.76 2.00
27 1.018000e+10 11.17 1.260000e+09 1.40 2.37
28 9.340000e+09 4.89 1.070000e+09 0.60 2.51
29 7.670000e+09 4.97 1.590000e+09 1.48 3.46
30 7.030000e+09 29.02 2.380000e+09 2.00 5.13
31 1.047000e+10 29.97 1.340000e+09 0.16 0.35
32 6.357000e+10 7.56 7.540000e+09 1.40 1.91
33 9.030000e+09 12.40 3.010000e+09 1.51 5.19
34 3.303000e+10 14.96 1.650000e+09 1.20 1.39
35 8.980000e+09 7.02 8.241500e+08 1.52 5.74
36 8.752000e+10 7.44 5.180000e+09 0.72 1.35
37 2.283000e+10 23.69 1.780000e+09 0.76 1.65
38 2.020000e+10 9.85 2.280000e+09 2.20 2.53
39 7.010000e+09 14.29 9.878600e+08 0.36 1.69
40 7.440000e+09 60.33 1.070000e+09 0.15 0.17
41 2.009000e+10 42.51 2.380000e+09 1.92 2.03
42 7.270000e+09 43.77 1.020000e+09 2.00 2.27
43 2.606000e+10 6.72 2.040000e+09 0.54 0.83
44 8.037000e+10 4.03 4.950000e+09 0.90 1.60
45 5.400000e+09 32.06 9.051000e+08 1.04 1.30
46 1.053000e+10 46.03 9.054000e+08 2.84 1.57
47 9.830000e+09 15.70 1.480000e+09 1.00 1.31
48 1.825000e+10 43.17 1.850000e+09 2.32 1.86
49 4.910000e+09 10.27 1.160000e+09 0.56 2.47
50 3.622000e+10 19.64 7.470000e+09 2.40 3.77
51 9.800000e+09 23.37 9.348000e+08 1.80 2.27
52 4.884000e+10 6.64 4.480000e+09 1.04 1.40
53 9.670000e+09 11.06 8.088700e+08 0.96 1.29
54 7.468000e+10 31.45 8.170000e+09 1.61 1.67
55 1.694000e+10 23.30 7.970900e+08 0.00 0.00
56 2.130000e+10 11.78 2.010000e+09 1.68 3.31
57 1.294000e+10 64.50 2.180000e+09 4.00 2.34
58 1.672000e+10 10.77 2.950000e+09 0.80 1.91
59 8.520000e+09 7.36 1.270000e+09 2.00 2.51
earningShare BookPrice SalesPrice earningsGrowth earningsRatio \
0 6.10 4.25 1.27 2.35 26.92
1 4.71 2.25 0.49 1.47 8.57
2 3.35 3.25 0.35 1.11 13.29
3 2.46 2.33 0.97 1.44 16.62
4 3.56 5.26 1.92 0.85 18.11
5 3.72 1.79 2.46 1.14 14.89
6 3.57 3.37 2.26 1.71 21.15
7 1.72 3.70 2.24 1.66 21.72
8 4.26 3.71 0.94 1.63 17.32
9 2.49 1.64 0.91 1.22 11.98
10 5.73 4.10 3.17 1.82 19.31
11 4.24 7.41 1.16 0.94 16.54
12 3.41 4.95 1.31 1.46 21.46
13 1.26 4.69 2.18 1.00 96.65
14 1.81 1.56 0.32 2.59 6.83
15 4.63 3.41 1.17 1.53 14.80
16 1.51 4.16 2.07 1.50 20.50
17 1.51 4.22 2.10 1.30 20.74
18 8.76 1.22 0.34 0.68 4.18
19 4.63 4.35 0.95 2.44 20.92
20 1.68 3.35 0.59 2.59 13.71
21 2.68 2.65 3.04 2.73 18.03
22 1.20 1.83 0.53 1.22 27.06
23 5.06 3.01 1.08 1.02 21.99
24 4.21 5.98 2.14 1.78 19.60
25 1.29 7.43 1.50 1.05 18.34
26 6.16 30.05 1.81 1.59 22.33
27 3.73 5.19 1.70 1.27 15.27
28 1.34 4.89 1.22 1.99 17.60
29 1.88 8.80 0.52 3.01 23.53
30 3.29 1.37 0.37 1.44 12.12
31 3.93 1.52 0.97 1.38 11.35
32 2.72 9.73 1.02 1.17 26.83
33 2.20 2.38 0.35 0.53 13.45
34 2.81 5.70 11.14 1.60 30.12
35 0.92 3.75 1.65 1.13 28.49
36 2.27 7.13 2.62 1.88 23.32
37 1.03 1.95 2.09 1.22 46.13
38 4.66 8.84 1.34 2.65 18.36
39 1.75 1.50 0.91 0.66 12.29
40 7.15 1.53 0.89 2.12 13.13
41 5.93 2.22 2.38 0.93 15.79
42 2.33 2.02 1.01 2.35 37.99
43 2.72 9.73 2.04 2.11 24.31
44 1.95 13.87 3.75 1.69 28.32
45 6.68 2.47 0.81 0.89 11.63
46 8.96 3.94 2.88 1.99 20.26
47 6.05 4.86 2.93 1.48 12.59
48 6.51 2.90 1.61 1.74 19.05
49 2.02 2.21 1.50 1.01 11.35
50 5.62 3.27 0.51 2.44 11.47
51 3.57 3.34 2.44 2.80 22.04
52 3.41 11.15 1.48 2.19 21.94
53 3.15 6.73 1.50 1.97 23.38
54 5.62 3.07 2.61 1.38 17.23
55 5.97 11.59 3.70 1.98 45.64
56 2.63 4.36 1.72 1.92 19.54
57 11.50 2.71 0.62 0.84 15.21
58 3.62 3.94 1.35 -13.42 11.66
59 5.21 10.77 1.66 1.07 15.16
US_state
0 Virginia
1 New Jersey
2 Minnesota
3 Michigan
4 New York
5 Florida
6 Pennsylvania
7 New York
8 Tennessee
9 Texas
10 California
11 Kent, United Kingdom
12 Florida
13 Washington
14 Michigan
15 New York
16 New York
17 New York
18 Michigan
19 Georgia
20 California
21 Switzerland
22 Ohio
23 Connecticut
24 Rhode Island
25 North Carolina
26 Georgia
27 Wisconsin
28 New York
29 Washington
30 Wisconsin
31 Florida
32 North Carolina
33 Ohio
34 Maryland
35 California
36 Oregon
37 Georgia
38 New York
39 Georgia
40 New York
41 Florida
42 New York
43 California
44 Washington
45 Bermuda
46 Wisconsin
47 Ohio
48 Connecticut
49 Virginia
50 Minnesota
51 New York
52 Massachusetts
53 Tennessee
54 New York
55 Illinois
56 North Carolina
57 Michigan
58 New York
59 New Jersey
Dataset for Telecommunications Services
symbol security SEC GICS_Sector \
0 CTL CenturyLink Inc reports Telecommunications Services
1 T AT&T Inc reports Telecommunications Services
2 VZ Verizon Communications reports Telecommunications Services
GICS_subIndustry CIK marketCapital bookValue \
0 Integrated Telecommunications Services 18926 1.414000e+10 25.41
1 Integrated Telecommunications Services 732717 2.588200e+11 20.06
2 Integrated Telecommunications Services 732712 1.998100e+11 5.53
ebitda dividentShare DividentYield earningShare BookPrice \
0 6.750000e+09 2.16 8.32 1.70 1.02
1 5.056000e+10 1.96 4.67 2.10 2.08
2 4.299000e+10 2.31 4.66 3.21 8.94
SalesPrice earningsGrowth earningsRatio US_state
0 0.80 -16.23 15.24 Louisiana
1 1.57 1.56 20.08 Texas
2 1.60 6.58 15.27 New York
Dataset for Information Technology
symbol security SEC \
0 AAPL Apple Inc. reports
1 ACN Accenture plc reports
2 ADBE Adobe Systems Inc reports
3 ADI Analog Devices, Inc. reports
4 ADP Automatic Data Processing reports
5 ADS Alliance Data Systems reports
6 AMAT Applied Materials Inc reports
7 ATVI Activision Blizzard reports
8 CA CA, Inc. reports
9 CSCO Cisco Systems reports
10 CSRA CSRA Inc. reports
11 FIS Fidelity National Information Services reports
12 GPN Global Payments Inc reports
13 HPE Hewlett Packard Enterprise reports
14 HRS Harris Corporation reports
15 IBM International Business Machines reports
16 INTC Intel Corp. reports
17 INTU Intuit Inc. reports
18 JNPR Juniper Networks reports
19 KLAC KLA-Tencor Corp. reports
20 LLTC Linear Technology Corp. reports
21 LRCX Lam Research reports
22 MA Mastercard Inc. reports
23 MCHP Microchip Technology reports
24 MSFT Microsoft Corp. reports
25 NTAP NetApp reports
26 NVDA Nvidia Corporation reports
27 ORCL Oracle Corp. reports
28 PAYX Paychex Inc. reports
29 QCOM QUALCOMM Inc. reports
30 STX Seagate Technology reports
31 SWKS Skyworks Solutions reports
32 SYMC Symantec Corp. reports
33 TEL TE Connectivity Ltd. reports
34 TSS Total System Services reports
35 TXN Texas Instruments reports
36 V Visa Inc. reports
37 WU Western Union Co reports
38 XLNX Xilinx Inc reports
39 XRX Xerox Corp. reports
GICS_Sector GICS_subIndustry \
0 Information Technology Computer Hardware
1 Information Technology IT Consulting & Other Services
2 Information Technology Application Software
3 Information Technology Semiconductors
4 Information Technology Internet Software & Services
5 Information Technology Data Processing & Outsourced Services
6 Information Technology Semiconductor Equipment
7 Information Technology Home Entertainment Software
8 Information Technology Systems Software
9 Information Technology Networking Equipment
10 Information Technology IT Consulting & Other Services
11 Information Technology Internet Software & Services
12 Information Technology Data Processing & Outsourced Services
13 Information Technology Technology Hardware, Storage & Peripherals
14 Information Technology Telecommunications Equipment
15 Information Technology IT Consulting & Other Services
16 Information Technology Semiconductors
17 Information Technology Internet Software & Services
18 Information Technology Networking Equipment
19 Information Technology Semiconductor Equipment
20 Information Technology Semiconductors
21 Information Technology Semiconductor Equipment
22 Information Technology Internet Software & Services
23 Information Technology Semiconductors
24 Information Technology Systems Software
25 Information Technology Internet Software & Services
26 Information Technology Semiconductors
27 Information Technology Application Software
28 Information Technology Internet Software & Services
29 Information Technology Semiconductors
30 Information Technology Computer Storage & Peripherals
31 Information Technology Semiconductors
32 Information Technology Application Software
33 Information Technology Electronic Equipment & Instruments
34 Information Technology Internet Software & Services
35 Information Technology Semiconductors
36 Information Technology Internet Software & Services
37 Information Technology Internet Software & Services
38 Information Technology Semiconductors
39 Information Technology IT Consulting & Other Services
CIK marketCapital bookValue ebitda dividentShare \
0 320193 6.470800e+11 24.03 7.053000e+10 2.28
1 1467373 7.090000e+10 11.95 5.660000e+09 2.42
2 796343 5.602000e+10 15.02 1.820000e+09 0.00
3 6281 2.309000e+10 16.76 1.250000e+09 1.68
4 8670 4.556000e+10 9.38 2.650000e+09 2.28
5 1101215 1.315000e+10 28.79 1.570000e+09 2.08
6 6951 3.687000e+10 6.70 2.540000e+09 0.40
7 718877 2.988000e+10 11.87 1.890000e+09 0.26
8 356028 1.307000e+10 13.49 1.280000e+09 1.02
9 858877 1.542100e+11 12.62 1.499000e+10 1.04
10 1646383 5.070000e+09 1.08 6.033700e+08 0.40
11 1136893 2.607000e+10 29.45 2.200000e+09 1.16
12 1123360 1.177000e+10 17.44 8.311200e+08 0.04
13 1645590 3.776000e+10 18.87 7.830000e+09 0.24
14 202058 1.276000e+10 24.60 1.680000e+09 2.12
15 51143 1.655500e+11 19.24 1.749000e+10 5.60
16 50863 1.743400e+11 13.99 2.296000e+10 1.04
17 896878 3.043000e+10 3.64 1.430000e+09 1.36
18 1043604 1.017000e+10 13.09 1.120000e+09 0.40
19 319201 1.334000e+10 6.16 1.250000e+09 2.16
20 791907 1.552000e+10 7.64 7.259800e+08 1.32
21 707549 1.865000e+10 39.39 1.620000e+09 1.80
22 1141391 1.158600e+11 5.70 5.990000e+09 0.88
23 827054 1.455000e+10 11.67 8.236100e+08 1.44
24 789019 4.995800e+11 8.90 2.774000e+10 1.56
25 1002047 1.055000e+10 10.10 7.150000e+08 0.76
26 1045810 5.885000e+10 9.88 1.760000e+09 0.56
27 1341439 1.645500e+11 11.81 1.460000e+10 0.60
28 723531 2.163000e+10 5.06 1.310000e+09 1.84
29 804328 7.892000e+10 21.12 8.550000e+09 2.12
30 1137789 1.333000e+10 5.16 1.710000e+09 2.52
31 4127 1.695000e+10 19.81 1.370000e+09 1.12
32 849399 1.718000e+10 6.20 9.400000e+08 0.30
33 1385157 2.642000e+10 24.86 2.630000e+09 1.48
34 721683 9.310000e+09 11.43 9.751000e+08 0.40
35 97476 7.524000e+10 10.52 5.710000e+09 2.00
36 1403161 1.935400e+11 11.61 1.027000e+10 0.66
37 1365135 9.490000e+09 2.86 1.360000e+09 0.64
38 743988 1.449000e+10 9.97 7.671300e+08 1.32
39 108772 7.030000e+09 9.13 2.020000e+09 0.31
DividentYield earningShare BookPrice SalesPrice earningsGrowth \
0 1.87 8.31 5.06 3.01 0.99
1 2.10 6.76 9.59 2.14 1.96
2 0.00 2.32 7.58 9.61 0.95
3 2.18 2.76 4.55 6.87 3.36
4 2.24 3.34 10.87 3.88 2.43
5 0.94 7.34 7.93 1.84 1.03
6 1.14 1.54 5.13 3.42 0.91
7 0.66 1.15 3.34 4.95 0.87
8 3.28 1.89 2.31 3.23 21.27
9 3.36 2.09 2.44 3.16 1.42
10 1.26 0.66 28.88 1.05 1.56
11 1.45 1.44 2.70 3.01 1.47
12 0.05 1.65 4.46 3.58 0.00
13 1.06 1.82 1.17 0.74 9.20
14 2.07 2.68 4.16 1.72 0.42
15 3.16 12.38 9.14 2.09 4.98
16 2.74 2.12 2.68 2.98 1.34
17 1.15 3.74 32.55 6.39 1.56
18 1.50 1.55 2.02 2.01 1.10
19 2.51 5.50 14.01 4.15 1.26
20 2.08 2.04 8.30 10.50 2.90
21 1.52 5.58 2.94 2.95 0.82
22 0.80 3.62 19.19 11.30 1.95
23 2.10 0.23 5.92 5.39 1.11
24 2.37 2.12 7.32 5.87 2.36
25 2.01 1.10 3.77 1.94 1.04
26 0.50 1.96 11.14 9.66 1.60
27 1.49 2.10 3.41 4.43 1.86
28 3.01 2.15 12.02 7.12 3.13
29 3.91 3.28 2.54 3.33 1.10
30 5.66 1.71 8.70 1.21 0.58
31 1.22 4.73 4.68 5.23 0.99
32 1.10 3.46 4.40 4.66 2.25
33 1.99 5.72 2.99 2.12 2.08
34 0.78 1.73 4.48 2.26 1.42
35 2.56 3.48 7.41 5.80 2.13
36 0.79 2.53 7.21 12.99 1.61
37 3.27 1.65 6.86 1.75 1.78
38 2.26 2.28 5.93 6.37 2.99
39 4.44 0.60 0.76 0.40 -69.45
earningsRatio US_state
0 14.60 California
1 16.85 Ireland
2 48.87 California
3 27.15 Massachusetts
4 30.22 New Jersey
5 31.11 Texas
6 22.24 California
7 34.90 California
8 16.58 New York
9 14.70 California
10 46.72 Virginia
11 55.00 Florida
12 46.69 Georgia
13 12.46 California
14 38.38 Florida
15 14.10 New York
16 17.37 California
17 31.72 California
18 17.28 California
19 15.47 California
20 30.95 California
21 20.59 California
22 29.40 New York
23 292.83 Arizona
24 30.42 Washington
25 34.77 California
26 55.79 California
27 19.15 California
28 28.04 New York
29 16.29 California
30 26.34 Ireland
31 19.41 Massachusetts
32 7.96 California
33 13.01 Switzerland
34 29.29 Georgia
35 21.72 Texas
36 32.68 California
37 11.86 Colorado
38 25.53 California
39 11.63 Connecticut
Dataset for Health Care
symbol security SEC GICS_Sector \
0 A Agilent Technologies Inc reports Health Care
1 ABBV AbbVie reports Health Care
2 ABC AmerisourceBergen Corp reports Health Care
3 ABT Abbott Laboratories reports Health Care
4 AET Aetna Inc reports Health Care
5 AGN Allergan, Plc reports Health Care
6 AMGN Amgen Inc reports Health Care
7 ANTM Anthem Inc. reports Health Care
8 BAX Baxter International Inc. reports Health Care
9 BCR Bard (C.R.) Inc. reports Health Care
10 BDX Becton Dickinson reports Health Care
11 BMY Bristol-Myers Squibb reports Health Care
12 CAH Cardinal Health Inc. reports Health Care
13 CI CIGNA Corp. reports Health Care
14 COO The Cooper Companies reports Health Care
15 DGX Quest Diagnostics reports Health Care
16 ESRX Express Scripts reports Health Care
17 GILD Gilead Sciences reports Health Care
18 HUM Humana Inc. reports Health Care
19 JNJ Johnson & Johnson reports Health Care
20 LH Laboratory Corp. of America Holding reports Health Care
21 LLY Lilly (Eli) & Co. reports Health Care
22 MCK McKesson Corp. reports Health Care
23 MDT Medtronic plc reports Health Care
24 MRK Merck & Co. reports Health Care
25 MYL Mylan N.V. reports Health Care
26 PDCO Patterson Companies reports Health Care
27 PFE Pfizer Inc. reports Health Care
28 PKI PerkinElmer reports Health Care
29 SYK Stryker Corp. reports Health Care
30 TMO Thermo Fisher Scientific reports Health Care
31 UHS Universal Health Services, Inc. reports Health Care
32 UNH United Health Group Inc. reports Health Care
33 VAR Varian Medical Systems reports Health Care
34 WAT Waters Corporation reports Health Care
35 XRAY Dentsply Sirona reports Health Care
36 ZBH Zimmer Biomet Holdings reports Health Care
37 ZTS Zoetis reports Health Care
GICS_subIndustry CIK marketCapital bookValue ebitda \
0 Health Care Equipment 1090872 1.576000e+10 13.12 8.610000e+08
1 Pharmaceuticals 1551152 9.931000e+10 3.98 1.111000e+10
2 Health Care Distributors 1140859 1.921000e+10 9.68 2.070000e+09
3 Health Care Equipment 1800 6.150000e+10 14.11 5.000000e+09
4 Managed Health Care 1122304 4.162000e+10 52.10 5.970000e+09
5 Pharmaceuticals 884629 8.210000e+10 221.28 6.810000e+09
6 Biotechnology 318154 1.165600e+11 41.32 1.155000e+10
7 Managed Health Care 1156039 4.061000e+10 93.94 5.550000e+09
8 Health Care Equipment 10456 2.606000e+10 15.95 1.830000e+09
9 Health Care Equipment 9892 1.745000e+10 23.42 1.170000e+09
10 Health Care Equipment 10795 3.764000e+10 35.79 3.200000e+09
11 Health Care Distributors 14272 8.216000e+10 9.34 6.780000e+09
12 Health Care Distributors 721371 2.399000e+10 20.35 3.080000e+09
13 Managed Health Care 701221 3.754000e+10 54.46 3.640000e+09
14 Health Care Supplies 711404 9.010000e+09 55.34 6.101500e+08
15 Health Care Facilities 1022079 1.259000e+10 33.78 1.490000e+09
16 Health Care Distributors 1532063 4.247000e+10 25.30 6.840000e+09
17 Biotechnology 882095 9.545000e+10 12.76 2.038000e+10
18 Managed Health Care 49071 2.960000e+10 75.69 2.780000e+09
19 Health Care Equipment 200406 3.081000e+11 26.73 2.481000e+10
20 Health Care Facilities 920148 1.382000e+10 53.73 1.790000e+09
21 Pharmaceuticals 59478 8.147000e+10 14.74 5.060000e+09
22 Health Care Distributors 927653 2.951000e+10 36.27 4.620000e+09
23 Health Care Equipment 64670 1.043800e+11 36.55 8.950000e+09
24 Pharmaceuticals 310158 1.709100e+11 15.84 1.515000e+10
25 Pharmaceuticals 69499 2.036000e+10 22.10 3.300000e+09
26 Health Care Supplies 891024 3.970000e+09 14.76 4.369800e+08
27 Pharmaceuticals 78003 1.925500e+11 10.43 1.998000e+10
28 Health Care Equipment 31791 5.830000e+09 19.50 4.400000e+08
29 Health Care Equipment 310764 4.626000e+10 25.50 3.110000e+09
30 Health Care Equipment 97745 6.020000e+10 54.83 4.370000e+09
31 Health Care Facilities 352915 1.092000e+10 45.33 1.700000e+09
32 Managed Health Care 731766 1.572400e+11 39.58 1.534000e+10
33 Health Care Equipment 203527 7.260000e+09 18.45 6.322800e+08
34 Health Care Distributors 1000697 1.138000e+10 28.64 7.312000e+08
35 Health Care Supplies 818479 1.309000e+10 36.03 7.270000e+08
36 Health Care Equipment 1136869 2.370000e+10 48.68 2.890000e+09
37 Pharmaceuticals 1555280 2.713000e+10 3.21 1.630000e+09
dividentShare DividentYield earningShare BookPrice SalesPrice \
0 0.53 1.09 1.40 3.63 3.65
1 2.56 4.27 3.63 15.18 3.83
2 1.46 1.77 6.32 8.64 0.13
3 1.06 2.59 0.94 2.91 2.90
4 1.00 0.85 6.93 2.24 0.66
5 2.80 1.31 35.66 0.96 4.76
6 4.60 2.93 9.99 3.74 5.09
7 2.60 1.70 8.52 1.64 0.49
8 0.52 1.10 8.93 2.94 2.52
9 1.04 0.44 7.03 10.11 4.69
10 2.92 1.67 4.49 4.89 2.97
11 1.56 3.27 2.65 5.21 4.19
12 1.80 2.48 4.13 3.60 0.19
13 0.04 0.03 7.36 2.68 0.95
14 0.06 0.03 5.59 3.28 4.51
15 1.80 1.94 4.51 2.68 1.65
16 0.00 0.00 4.45 2.69 0.41
17 1.88 2.64 10.81 5.60 2.98
18 1.16 0.58 7.39 2.63 0.54
19 3.20 2.82 5.93 4.23 4.28
20 0.00 0.00 6.31 2.47 1.47
21 2.08 2.76 2.30 5.07 3.79
22 1.12 0.82 8.43 3.78 0.15
23 1.72 2.29 3.00 2.04 3.53
24 1.88 3.04 1.96 3.88 4.24
25 0.00 0.00 0.50 1.64 1.89
26 0.96 2.31 2.15 2.78 0.70
27 1.28 4.07 1.00 3.00 3.57
28 0.28 0.54 2.15 2.66 2.50
29 1.70 1.38 4.35 4.80 4.05
30 0.60 0.41 5.00 2.61 3.15
31 0.40 0.35 7.10 2.49 1.14
32 2.50 1.53 7.48 4.09 0.85
33 0.00 0.00 3.51 4.21 2.25
34 0.00 0.00 6.41 4.92 5.23
35 0.31 0.55 1.91 1.56 3.80
36 0.96 0.82 1.79 2.37 3.04
37 0.42 0.77 1.39 16.92 5.49
earningsGrowth earningsRatio US_state
0 2.25 34.98 California
1 0.76 16.83 Illinois
2 1.58 13.81 Pennsylvania
3 1.49 44.58 Illinois
4 1.24 17.11 Connecticut
5 1.31 6.14 Ireland
6 1.93 15.68 California
7 1.29 18.09 Indiana
8 1.84 5.36 Illinois
9 1.79 33.76 New Jersey
10 1.76 39.49 New Jersey
11 1.21 18.55 New York
12 1.43 18.15 Ohio
13 1.54 19.87 Pennsylvania
14 1.51 33.03 California
15 2.09 20.38 New Jersey
16 0.80 15.49 Missouri
17 -2.58 6.70 California
18 1.56 26.84 Kentucky
19 2.73 19.10 New Jersey
20 1.47 21.28 North Carolina
21 2.02 33.51 Indiana
22 1.38 16.51 California
23 2.21 25.31 Ireland
24 2.74 31.66 New Jersey
25 0.87 76.25 Netherlands
26 1.78 19.32 Minnesota
27 1.82 31.86 New York
28 2.11 24.76 Massachusetts
29 1.96 28.40 Michigan
30 1.60 30.46 Massachusetts
31 1.83 15.86 Pennsylvania
32 1.06 21.68 Minnesota
33 2.17 22.11 California
34 2.41 22.10 Massachusetts
35 2.05 29.62 Pennsylvania
36 1.39 66.25 Indiana
37 2.15 39.61 New Jersey
Dataset for Real Estate
symbol security SEC GICS_Sector \
0 AIV Apartment Investment & Mgmt reports Real Estate
1 AMT American Tower Corp A reports Real Estate
2 AVB AvalonBay Communities, Inc. reports Real Estate
3 BXP Boston Properties reports Real Estate
4 CCI Crown Castle International Corp. reports Real Estate
5 DLR Digital Realty Trust reports Real Estate
6 EQIX Equinix reports Real Estate
7 EQR Equity Residential reports Real Estate
8 ESS Essex Property Trust, Inc. reports Real Estate
9 EXR Extra Space Storage reports Real Estate
10 FRT Federal Realty Investment Trust reports Real Estate
11 GGP General Growth Properties Inc. reports Real Estate
12 HCN Welltower Inc. reports Real Estate
13 HST Host Hotels & Resorts reports Real Estate
14 IRM Iron Mountain Incorporated reports Real Estate
15 KIM Kimco Realty reports Real Estate
16 MAA Mid-America Apartments reports Real Estate
17 MAC Macerich reports Real Estate
18 O Realty Income Corporation reports Real Estate
19 PLD Prologis reports Real Estate
20 PSA Public Storage reports Real Estate
21 SLG SL Green Realty reports Real Estate
22 SPG Simon Property Group Inc reports Real Estate
23 UDR UDR Inc reports Real Estate
24 VNO Vornado Realty Trust reports Real Estate
25 VTR Ventas Inc reports Real Estate
26 WY Weyerhaeuser Corp. reports Real Estate
GICS_subIndustry CIK marketCapital bookValue ebitda \
0 REITs 922864 6.910000e+09 9.93 5.684200e+08
1 Specialized REITs 1053507 4.406000e+10 15.76 3.310000e+09
2 Residential REITs 915912 2.380000e+10 73.09 1.300000e+09
3 REITs 1037540 2.013000e+10 35.94 1.530000e+09
4 REITs 1051470 3.093000e+10 21.46 2.110000e+09
5 Specialized REITs 1297996 1.711000e+10 26.09 1.020000e+09
6 REITs 1101239 2.748000e+10 64.78 1.390000e+09
7 REITs 906107 2.222000e+10 27.56 1.630000e+09
8 Residential REITs 920522 1.470000e+10 92.92 8.986400e+08
9 Specialized REITs 1289490 9.060000e+09 17.48 5.582400e+08
10 Retail REITs 34903 1.008000e+10 27.34 5.034600e+08
11 Retail REITs 895648 2.199000e+10 9.71 1.810000e+09
12 REITs 766704 2.404000e+10 38.03 2.090000e+09
13 REITs 1070750 1.337000e+10 9.61 1.430000e+09
14 REITs 1020569 9.430000e+09 8.07 1.000000e+09
15 REITs 879101 1.058000e+10 12.47 7.248200e+08
16 Residential REITs 912595 7.170000e+09 39.49 6.109900e+08
17 Retail REITs 912242 9.870000e+09 28.94 6.661600e+08
18 Retail REITs 726728 1.542000e+10 24.59 9.780700e+08
19 REITs 1045609 2.691000e+10 27.21 1.820000e+09
20 REITs 1393311 3.729000e+10 29.12 1.840000e+09
21 Office REITs 1040971 1.096000e+10 70.63 1.060000e+09
22 REITs 1063761 5.775000e+10 14.59 4.030000e+09
23 Residential REITs 74208 9.340000e+09 10.76 6.076300e+08
24 REITs 899689 2.009000e+10 27.92 1.210000e+09
25 REITs 740260 2.184000e+10 29.65 1.790000e+09
26 REITs 106535 2.344000e+10 12.29 1.770000e+09
dividentShare DividentYield earningShare BookPrice SalesPrice \
0 1.32 2.98 2.07 4.42 7.11
1 2.32 2.23 2.00 6.54 7.93
2 5.40 3.12 6.89 2.35 11.72
3 3.00 2.29 3.21 3.63 7.86
4 3.80 4.38 0.95 4.04 7.79
5 3.52 3.31 1.45 4.08 8.13
6 7.00 1.83 1.11 5.96 8.11
7 2.02 3.30 11.48 2.20 8.80
8 6.40 2.84 4.51 2.40 11.08
9 3.12 4.26 2.32 4.14 9.38
10 3.92 2.81 3.68 5.09 12.64
11 0.88 3.57 1.29 2.47 8.30
12 3.44 5.22 2.27 1.74 5.82
13 1.00 5.38 1.06 1.87 2.42
14 2.20 6.08 0.26 4.44 2.83
15 1.08 4.35 1.49 1.98 8.95
16 3.48 3.64 2.86 2.40 6.62
17 2.84 4.18 5.97 2.34 8.68
18 2.53 4.25 1.10 2.41 14.21
19 1.68 3.41 2.20 1.79 9.80
20 8.00 3.69 6.53 7.38 14.40
21 3.10 2.83 2.34 1.54 5.85
22 6.60 3.68 5.87 12.18 10.36
23 1.18 3.38 0.83 3.22 9.53
24 2.84 2.66 2.12 3.83 8.16
25 3.10 5.08 1.65 2.07 6.38
26 1.24 3.97 0.77 2.54 2.96
earningsGrowth earningsRatio US_state
0 3.32 21.31 Colorado
1 1.48 51.80 Massachusetts
2 56.34 25.14 Virginia[3]
3 5.88 40.78 Massachusetts
4 -2.24 92.45 Texas
5 1.54 74.18 California
6 11.63 347.14 California
7 -2.43 5.30 Illinois
8 6.57 49.78 California
9 5.27 31.11 UT
10 4.97 38.19 Maryland
11 6.25 19.26 Illinois
12 10.12 29.25 Ohio
13 -0.65 17.06 Maryland
14 3.22 135.61 Massachusetts
15 9.64 16.69 New York
16 5.17 33.20 Tennessee
17 -173.27 11.51 California
18 10.78 54.01 California
19 0.00 22.19 California
20 3.87 32.93 California
21 1.29 46.57 New York
22 3.02 31.30 Indiana
23 -3.75 42.31 Colorado
24 4.62 50.12 New York
25 5.30 37.35 Illinois
26 7.89 40.69 Washington
Dataset for Consumer Staples
symbol security SEC GICS_Sector \
0 ADM Archer-Daniels-Midland Co reports Consumer Staples
1 BF-B Brown-Forman Corporation reports Consumer Staples
2 CAG ConAgra Foods Inc. reports Consumer Staples
3 CHD Church & Dwight reports Consumer Staples
4 CLX The Clorox Company reports Consumer Staples
5 COST Costco Co. reports Consumer Staples
6 COTY Coty, Inc reports Consumer Staples
7 CPB Campbell Soup reports Consumer Staples
8 CVS CVS Health reports Consumer Staples
9 DPS Dr Pepper Snapple Group reports Consumer Staples
10 EL Estee Lauder Cos. reports Consumer Staples
11 GIS General Mills reports Consumer Staples
12 HRL Hormel Foods Corp. reports Consumer Staples
13 HSY The Hershey Company reports Consumer Staples
14 K Kellogg Co. reports Consumer Staples
15 KHC Kraft Heinz Co reports Consumer Staples
16 KO Coca Cola Company reports Consumer Staples
17 KR Kroger Co. reports Consumer Staples
18 MDLZ Mondelez International reports Consumer Staples
19 MKC McCormick & Co. reports Consumer Staples
20 MO Altria Group Inc reports Consumer Staples
21 PEP PepsiCo Inc. reports Consumer Staples
22 PG Procter & Gamble reports Consumer Staples
23 RAI Reynolds American Inc. reports Consumer Staples
24 SJM JM Smucker reports Consumer Staples
25 STZ Constellation Brands reports Consumer Staples
26 SYY Sysco Corp. reports Consumer Staples
27 TAP Molson Coors Brewing Company reports Consumer Staples
28 TSN Tyson Foods reports Consumer Staples
29 WBA Walgreens Boots Alliance reports Consumer Staples
30 WFM Whole Foods Market reports Consumer Staples
31 WMT Wal-Mart Stores reports Consumer Staples
GICS_subIndustry CIK marketCapital bookValue \
0 Agricultural Products 7084 2.547000e+10 30.34
1 Distillers & Vintners 14693 1.755000e+10 3.33
2 Packaged Foods & Meats 23217 1.701000e+10 10.22
3 Household Products 313927 1.169000e+10 8.21
4 Household Products 21076 1.545000e+10 2.24
5 Hypermarkets & Super Centers 909832 7.201000e+10 27.25
6 Personal Products 1024305 1.433000e+10 0.75
7 Packaged Foods & Meats 16732 1.911000e+10 5.18
8 Drug Retail 64803 8.405000e+10 33.72
9 Soft Drinks 1418135 1.675000e+10 11.58
10 Personal Products 1001250 2.976000e+10 9.98
11 Packaged Foods & Meats 40704 3.624000e+10 7.20
12 Packaged Foods & Meats 48465 1.920000e+10 8.42
13 Packaged Foods & Meats 47111 2.238000e+10 4.19
14 Packaged Foods & Meats 55067 2.551000e+10 6.22
15 Packaged Foods & Meats 1545158 1.086900e+11 47.34
16 Soft Drinks 21344 1.792900e+11 6.05
17 Food Retail 56873 3.186000e+10 7.08
18 Packaged Foods & Meats 1103982 6.839000e+10 17.80
19 Packaged Foods & Meats 63754 1.196000e+10 12.98
20 Tobacco 764180 1.389400e+11 1.51
21 Soft Drinks 77476 1.488400e+11 8.88
22 Personal Products 80424 2.239500e+11 20.35
23 Tobacco 1275283 8.573000e+10 15.11
24 Packaged Foods & Meats 91419 1.582000e+10 61.67
25 Distillers & Vintners 16918 2.936000e+10 35.26
26 Food Distributors 96021 2.869000e+10 5.50
27 Brewers 24545 2.074000e+10 46.16
28 Packaged Foods & Meats 100493 2.348000e+10 25.69
29 Drug Retail 1618921 8.845000e+10 27.17
30 Food Retail 865436 9.620000e+09 10.13
31 Hypermarkets & Super Centers 104169 2.051000e+11 25.23
ebitda dividentShare DividentYield earningShare BookPrice \
0 2.390000e+09 1.20 2.70 2.65 1.45
1 1.100000e+09 0.73 1.60 2.64 13.64
2 1.830000e+09 0.80 2.05 1.42 3.82
3 8.338000e+08 0.71 1.57 1.74 5.52
4 1.200000e+09 3.20 2.66 4.97 53.59
5 5.030000e+09 1.80 1.11 5.48 5.99
6 7.480000e+08 0.50 2.56 0.09 25.27
7 1.580000e+09 1.40 2.24 2.13 12.05
8 1.284000e+10 2.00 2.57 4.67 2.33
9 1.650000e+09 2.12 2.35 4.61 7.83
10 2.150000e+09 1.36 1.68 2.93 8.10
11 3.380000e+09 1.92 3.06 2.68 8.69
12 1.420000e+09 0.68 1.88 1.64 4.31
13 1.760000e+09 2.47 2.34 3.78 25.06
14 2.030000e+09 2.08 2.85 1.99 11.67
15 8.710000e+09 2.40 2.68 2.27 1.88
16 1.169000e+10 1.40 3.38 1.65 6.84
17 5.880000e+09 0.48 1.44 2.08 4.75
18 4.320000e+09 0.76 1.72 0.52 2.50
19 7.541000e+08 1.88 1.96 3.69 7.35
20 9.450000e+09 2.44 3.44 2.66 47.28
21 1.208000e+10 3.01 2.91 4.56 11.68
22 1.777000e+10 2.68 3.09 5.46 4.26
23 5.610000e+09 1.84 3.05 3.85 3.96
24 1.690000e+09 3.00 2.21 6.13 2.17
25 2.400000e+09 1.60 1.07 6.46 4.21
26 2.810000e+09 1.32 2.50 1.81 9.59
27 6.055000e+08 1.64 1.72 2.77 2.07
28 3.570000e+09 0.90 1.43 4.53 2.44
29 7.890000e+09 1.50 1.84 3.78 3.00
30 1.370000e+09 0.56 1.85 1.55 2.95
31 3.301000e+10 2.00 3.05 4.61 2.63
SalesPrice earningsGrowth earningsRatio US_state
0 0.41 3.21 16.73 Illinois
1 5.78 0.00 17.26 Kentucky
2 1.51 1.79 27.57 Nebraska
3 3.38 3.41 26.06 New Jersey
4 2.66 3.41 24.15 California
5 0.60 2.67 29.92 Washington
6 3.26 10.63 220.69 NY
7 2.41 3.83 29.24 New Jersey
8 0.49 1.27 16.89 Rhode Island
9 2.60 2.09 19.80 Texas
10 2.62 2.49 27.73 New York
11 2.28 2.92 23.33 Minnesota
12 2.01 2.73 22.13 Minnesota
13 3.02 2.83 27.94 Pennsylvania
14 1.95 3.01 36.59 Michigan
15 4.05 1.25 39.30 Pennsylvania
16 4.20 10.88 25.21 Georgia
17 0.28 2.56 16.32 Ohio
18 2.59 1.80 84.50 Illinois
19 2.71 2.66 25.89 Maryland
20 7.20 2.91 26.76 Virginia
21 2.40 3.31 22.77 New York
22 3.40 3.00 16.05 Ohio
23 6.90 2.43 15.62 North Carolina
24 2.08 3.77 22.15 Ohio
25 4.01 1.27 23.18 New York
26 0.56 1.99 29.02 Texas
27 5.97 2.02 34.84 Colorado
28 0.63 0.57 13.86 Arkansas
29 0.75 1.29 21.68 Illinois
30 0.61 4.52 19.50 Texas
31 0.42 5.42 14.48 Arkansas
Dataset for Industrials
symbol security SEC GICS_Sector \
0 AAL American Airlines Group reports Industrials
1 ALK Alaska Air Group Inc reports Industrials
2 ALLE Allegion reports Industrials
3 AME AMETEK Inc reports Industrials
4 APH Amphenol Corp reports Industrials
5 AYI Acuity Brands Inc reports Industrials
6 BA Boeing Company reports Industrials
7 CHRW C. H. Robinson Worldwide reports Industrials
8 CMI Cummins Inc. reports Industrials
9 COL Rockwell Collins reports Industrials
10 CSX CSX Corp. reports Industrials
11 CTAS Cintas Corporation reports Industrials
12 DAL Delta Air Lines reports Industrials
13 DE Deere & Co. reports Industrials
14 DHR Danaher Corp. reports Industrials
15 DOV Dover Corp. reports Industrials
16 EMR Emerson Electric Company reports Industrials
17 ETN Eaton Corporation reports Industrials
18 EXPD Expeditors Int'l reports Industrials
19 FAST Fastenal Co reports Industrials
20 FBHS Fortune Brands Home & Security reports Industrials
21 FDX FedEx Corporation reports Industrials
22 FLIR FLIR Systems reports Industrials
23 FLR Fluor Corp. reports Industrials
24 FLS Flowserve Corporation reports Industrials
25 FTV Fortive Corp reports Industrials
26 GD General Dynamics reports Industrials
27 GE General Electric reports Industrials
28 GLW Corning Inc. reports Industrials
29 GWW Grainger (W.W.) Inc. reports Industrials
30 HON Honeywell Int'l Inc. reports Industrials
31 IR Ingersoll-Rand PLC reports Industrials
32 ITW Illinois Tool Works reports Industrials
33 JBHT J. B. Hunt Transport Services reports Industrials
34 JEC Jacobs Engineering Group reports Industrials
35 KSU Kansas City Southern reports Industrials
36 LEG Leggett & Platt reports Industrials
37 LLL L-3 Communications Holdings reports Industrials
38 LMT Lockheed Martin Corp. reports Industrials
39 LUV Southwest Airlines reports Industrials
40 MMM 3M Company reports Industrials
41 NLSN Nielsen Holdings reports Industrials
42 NOC Northrop Grumman Corp. reports Industrials
43 NSC Norfolk Southern Corp. reports Industrials
44 PBI Pitney-Bowes reports Industrials
45 PCAR PACCAR Inc. reports Industrials
46 PH Parker-Hannifin reports Industrials
47 R Ryder System reports Industrials
48 RHI Robert Half International reports Industrials
49 ROK Rockwell Automation Inc. reports Industrials
50 ROP Roper Industries reports Industrials
51 RSG Republic Services Inc reports Industrials
52 RTN Raytheon Co. reports Industrials
53 TXT Textron Inc. reports Industrials
54 UAL United Continental Holdings reports Industrials
55 UNP Union Pacific reports Industrials
56 UPS United Parcel Service reports Industrials
57 UTX United Technologies reports Industrials
58 WM Waste Management Inc. reports Industrials
59 XYL Xylem Inc. reports Industrials
GICS_subIndustry CIK marketCapital \
0 Airlines 6201 2.277000e+10
1 Airlines 766421 1.157000e+10
2 Building Products 1579241 6.310000e+09
3 Electrical Components & Equipment 1037868 1.183000e+10
4 Electrical Components & Equipment 820313 2.082000e+10
5 Electrical Components & Equipment 1144215 9.080000e+09
6 Aerospace & Defense 12927 1.008500e+11
7 Air Freight & Logistics 1043277 1.077000e+10
8 Industrial Machinery 26172 2.464000e+10
9 Industrial Conglomerates 1137411 1.197000e+10
10 Railroads 277948 4.345000e+10
11 Diversified Support Services 723254 1.220000e+10
12 Airlines 27904 3.458000e+10
13 Construction & Farm Machinery & Heavy Trucks 315189 3.392000e+10
14 Industrial Machinery 313616 5.805000e+10
15 Industrial Machinery 29905 1.208000e+10
16 Industrial Conglomerates 32604 3.771000e+10
17 Industrial Conglomerates 1551182 3.197000e+10
18 Air Freight & Logistics 746515 9.390000e+09
19 Building Products 815556 1.437000e+10
20 Building Products 1519751 8.510000e+09
21 Air Freight & Logistics 1048911 5.040000e+10
22 Aerospace & Defense 354908 4.810000e+09
23 Diversified Commercial Services 1124198 7.730000e+09
24 Industrial Machinery 30625 6.410000e+09
25 Industrial Machinery 1659166 1.912000e+10
26 Aerospace & Defense 40533 5.478000e+10
27 Industrial Conglomerates 40545 2.612100e+11
28 Construction & Engineering 24741 2.520000e+10
29 Industrial Materials 277135 1.485000e+10
30 Industrial Conglomerates 773840 9.021000e+10
31 Industrial Conglomerates 1466258 2.050000e+10
32 Industrial Machinery 49826 4.430000e+10
33 Trucking 728535 1.103000e+10
34 Industrial Conglomerates 52988 7.070000e+09
35 Railroads 54480 9.160000e+09
36 Industrial Conglomerates 58492 6.380000e+09
37 Industrial Conglomerates 1056239 1.227000e+10
38 Aerospace & Defense 936468 7.334000e+10
39 Airlines 92380 3.228000e+10
40 Industrial Conglomerates 66740 1.043200e+11
41 Research & Consulting Services 1492633 1.462000e+10
42 Aerospace & Defense 1133421 4.010000e+10
43 Railroads 702165 3.411000e+10
44 Technology, Hardware, Software and Supplies 78814 2.960000e+09
45 Construction & Farm Machinery & Heavy Trucks 75362 2.359000e+10
46 Industrial Conglomerates 76334 1.963000e+10
47 Industrial Conglomerates 85961 4.150000e+09
48 Human Resource & Employment Services 315213 5.950000e+09
49 Industrial Conglomerates 1024478 1.919000e+10
50 Industrial Conglomerates 882835 1.946000e+10
51 Industrial Conglomerates 1060391 1.951000e+10
52 Aerospace & Defense 1047122 4.241000e+10
53 Industrial Conglomerates 217346 1.294000e+10
54 Airlines 100517 2.236000e+10
55 Railroads 100885 8.731000e+10
56 Air Freight & Logistics 1090727 9.523000e+10
57 Industrial Conglomerates 101829 8.796000e+10
58 Environmental Services 823768 3.072000e+10
59 Industrial Conglomerates 1524472 8.850000e+09
bookValue ebitda dividentShare DividentYield earningShare \
0 7.36 7.500000e+09 0.40 0.85 4.81
1 23.23 1.790000e+09 1.10 1.16 7.13
2 1.58 4.883000e+08 0.48 0.72 2.33
3 14.57 1.020000e+09 0.36 0.69 2.30
4 11.91 1.460000e+09 0.64 0.96 2.61
5 39.50 5.862000e+08 0.52 0.25 6.92
6 1.32 7.450000e+09 5.68 3.39 7.61
7 8.95 9.185300e+08 1.80 2.32 3.61
8 41.37 2.320000e+09 4.10 2.79 6.88
9 16.74 1.230000e+09 1.32 1.45 5.59
10 12.44 4.440000e+09 0.72 1.50 1.80
11 19.29 9.832800e+08 1.05 0.90 4.80
12 16.75 8.860000e+09 0.81 1.63 5.79
13 20.71 3.810000e+09 2.40 2.22 4.81
14 33.53 5.430000e+09 0.50 0.62 3.58
15 24.45 1.080000e+09 1.76 2.21 3.25
16 11.77 3.110000e+09 1.92 3.19 2.52
17 34.10 3.270000e+09 2.28 3.21 4.23
18 10.26 7.223900e+08 0.80 1.50 2.36
19 6.68 8.993600e+08 1.28 2.55 1.73
20 15.29 7.533000e+08 0.72 1.29 2.50
21 54.52 7.860000e+09 1.60 0.82 6.80
22 12.15 3.532200e+08 0.48 1.35 1.27
23 22.31 8.532400e+08 0.84 1.48 1.13
24 13.05 5.198400e+08 0.76 1.48 1.15
25 7.39 1.450000e+09 0.28 0.50 2.56
26 36.28 4.760000e+09 3.04 1.64 9.52
27 8.62 1.680000e+10 0.96 3.20 0.90
28 16.22 2.320000e+09 0.54 2.02 1.96
29 32.41 1.370000e+09 4.88 1.90 9.87
30 25.64 7.710000e+09 2.66 2.25 6.20
31 26.20 1.940000e+09 1.60 2.00 5.76
32 12.21 3.530000e+09 2.60 2.02 5.70
33 12.70 1.080000e+09 0.92 0.93 3.81
34 35.26 6.549400e+08 0.60 0.99 1.73
35 38.31 1.120000e+09 1.32 1.53 4.43
36 8.24 5.999000e+08 1.36 2.87 2.73
37 58.86 1.210000e+09 2.80 1.77 9.01
38 5.18 6.760000e+09 7.28 2.87 17.49
39 13.68 4.980000e+09 0.40 0.76 3.55
40 17.33 8.680000e+09 4.44 2.50 8.16
41 11.88 1.560000e+09 1.24 3.03 1.63
42 30.04 3.650000e+09 3.60 1.57 12.19
43 42.73 4.100000e+09 2.44 2.03 5.62
44 0.70 7.526600e+08 0.75 4.73 1.37
45 19.90 2.500000e+09 0.96 1.42 1.64
46 34.84 1.580000e+09 2.64 1.77 6.03
47 39.22 1.810000e+09 1.76 2.25 5.43
48 8.58 6.168200e+08 0.88 1.90 2.67
49 15.80 1.190000e+09 3.04 2.02 5.81
50 56.32 1.280000e+09 1.40 0.73 6.70
51 22.42 2.610000e+09 1.28 2.23 1.72
52 34.22 3.760000e+09 2.93 2.01 7.44
53 20.41 1.590000e+09 0.08 0.17 3.53
54 26.55 6.940000e+09 0.00 0.00 6.85
55 24.33 9.310000e+09 2.42 2.22 5.07
56 3.14 1.016000e+10 3.12 2.64 5.61
57 34.39 1.013000e+10 2.64 2.41 6.12
58 12.12 3.650000e+09 1.70 2.44 2.49
59 12.41 6.130000e+08 0.62 1.24 1.80
BookPrice SalesPrice earningsGrowth earningsRatio US_state
0 6.10 0.58 -2.13 9.20 Texas
1 4.05 2.01 1.39 13.16 Washington
2 41.64 2.86 1.56 28.18 Ireland
3 3.53 3.09 2.52 22.22 Pennsylvania
4 5.62 3.29 3.26 25.86 Connecticut
5 5.19 2.63 1.17 29.95 Georgia
6 125.05 1.08 1.36 21.47 Illinois
7 8.55 0.84 3.31 21.07 Minnesota
8 3.55 1.39 -45.88 21.36 Indiana
9 5.43 2.27 2.52 16.22 Iowa
10 3.82 4.11 2.44 25.82 Florida
11 6.02 2.40 2.46 24.20 Ohio
12 2.85 0.88 0.00 8.16 Georgia
13 5.17 1.28 1.30 22.26 Illinois
14 2.40 2.44 2.72 23.47 D.C.
15 3.21 1.79 2.14 23.92 Illinois
16 5.02 2.62 6.77 23.28 Missouri
17 2.06 1.60 2.02 16.72 Ireland
18 5.16 1.58 6.21 22.06 Washington
19 7.51 3.66 2.34 28.73 Minnesota
20 3.64 1.75 1.59 22.06 Illinois
21 3.54 0.93 1.53 27.79 Tennessee
22 2.91 2.96 1.39 27.78 Oregon
23 2.52 0.42 2.92 49.12 Texas
24 3.87 1.57 -4.33 42.67 Texas
25 7.50 3.11 3.21 21.64 Washington
26 5.03 1.76 1.87 19.01 Virginia
27 3.48 2.13 1.48 33.15 Connecticut
28 1.64 2.77 1.78 13.50 New York
29 7.86 1.48 2.87 25.59 Illinois
30 4.65 2.31 2.31 19.08 New Jersey
31 3.04 1.52 2.01 13.77 Ireland
32 10.54 3.30 2.25 22.32 Illinois
33 7.79 1.68 1.98 26.01 Arkansas
34 1.68 0.65 2.95 33.84 California
35 2.25 3.95 1.51 19.39 Missouri
36 5.73 1.66 4.66 17.45 Missouri
37 2.67 1.16 2.84 17.61 New York
38 48.83 1.56 2.40 14.37 Maryland
39 3.83 1.58 1.30 14.74 Texas
40 10.12 3.48 2.28 21.42 Minnesota
41 3.46 2.34 1.81 25.14 New York
42 7.64 1.64 2.35 18.79 Virginia
43 2.80 3.51 1.64 20.90 Virginia
44 22.43 0.84 2.27 11.59 Connecticut
45 3.40 1.37 -3.21 40.97 Washington
46 4.23 1.75 2.36 24.40 Ohio
47 1.99 0.62 0.89 14.29 Florida
48 5.39 1.11 2.33 17.63 California
49 9.45 3.26 3.06 25.48 Wisconsin
50 3.38 5.19 2.62 28.65 Florida
51 2.56 2.10 2.59 33.36 Arizona
52 4.25 1.78 2.04 19.37 Massachusetts
53 2.32 0.94 2.04 13.43 Rhode Island
54 2.70 0.62 -1.73 10.29 Illinois
55 4.44 4.44 1.71 21.02 Nebraska
56 37.29 1.70 2.24 19.45 Georgia
57 3.17 1.53 2.26 17.93 Connecticut
58 5.74 2.30 2.26 27.89 Texas
59 3.99 2.42 1.72 27.36 New York
Dataset for Financials
symbol security SEC GICS_Sector \
0 AFL AFLAC Inc reports Financials
1 AIG American International Group, Inc. reports Financials
2 AIZ Assurant Inc reports Financials
3 AJG Arthur J. Gallagher & Co. reports Financials
4 ALL Allstate Corp reports Financials
5 AMP Ameriprise Financial reports Financials
6 AON Aon plc reports Financials
7 AXP American Express Co reports Financials
8 BAC Bank of America Corp reports Financials
9 BBT BB&T Corporation reports Financials
10 BEN Franklin Resources reports Financials
11 BK The Bank of New York Mellon Corp. reports Financials
12 BLK BlackRock reports Financials
13 C Citigroup Inc. reports Financials
14 CB Chubb Limited reports Financials
15 CFG Citizens Financial Group reports Financials
16 CINF Cincinnati Financial reports Financials
17 CMA Comerica Inc. reports Financials
18 CME CME Group Inc. reports Financials
19 COF Capital One Financial reports Financials
20 DFS Discover Financial Services reports Financials
21 EFX Equifax Inc. reports Financials
22 ETFC E*Trade reports Financials
23 FITB Fifth Third Bancorp reports Financials
24 GS Goldman Sachs Group reports Financials
25 HBAN Huntington Bancshares reports Financials
26 HIG Hartford Financial Svc.Gp. reports Financials
27 ICE Intercontinental Exchange reports Financials
28 IVZ Invesco Ltd. reports Financials
29 JPM JPMorgan Chase & Co. reports Financials
.. ... ... ... ...
31 L Loews Corp. reports Financials
32 LNC Lincoln National reports Financials
33 LUK Leucadia National Corp. reports Financials
34 MET MetLife Inc. reports Financials
35 MMC Marsh & McLennan reports Financials
36 MS Morgan Stanley reports Financials
37 MTB M&T Bank Corp. reports Financials
38 NAVI Navient reports Financials
39 NDAQ NASDAQ OMX Group reports Financials
40 NTRS Northern Trust Corp. reports Financials
41 PBCT People's United Financial reports Financials
42 PFG Principal Financial Group reports Financials
43 PGR Progressive Corp. reports Financials
44 PNC PNC Financial Services reports Financials
45 PRU Prudential Financial reports Financials
46 RF Regions Financial Corp. reports Financials
47 SCHW Charles Schwab Corporation reports Financials
48 SPGI S&P Global, Inc. reports Financials
49 STI SunTrust Banks reports Financials
50 STT State Street Corp. reports Financials
51 SYF Synchrony Financial reports Financials
52 TMK Torchmark Corp. reports Financials
53 TROW T. Rowe Price Group reports Financials
54 TRV The Travelers Companies Inc. reports Financials
55 UNM Unum Group reports Financials
56 USB U.S. Bancorp reports Financials
57 WFC Wells Fargo reports Financials
58 WLTW Willis Towers Watson reports Financials
59 XL XL Capital reports Financials
60 ZION Zions Bancorp reports Financials
GICS_subIndustry CIK marketCapital bookValue \
0 Life & Health Insurance 4977 2.856000e+10 55.84
1 Property & Casualty Insurance 5272 6.600000e+10 85.02
2 Multi-line Insurance 1267238 5.540000e+09 77.66
3 Insurance Brokers 354190 9.600000e+09 20.17
4 Property & Casualty Insurance 899051 2.770000e+10 52.14
5 Asset Management & Custody Banks 820027 1.774000e+10 42.88
6 Insurance Brokers 315293 2.965000e+10 20.62
7 Consumer Finance 4962 -1.000000e+00 23.23
8 Banks 70858 -1.000000e+00 24.04
9 Banks 92230 -1.000000e+00 33.14
10 Asset Management & Custody Banks 38777 2.247000e+10 21.15
11 Banks 1390777 -1.000000e+00 33.67
12 Asset Management & Custody Banks 1364742 6.100000e+10 176.40
13 Banks 831001 -1.000000e+00 74.26
14 Property & Casualty Insurance 896159 6.119000e+10 103.96
15 Regional Banks 759944 -1.000000e+00 38.09
16 Property & Casualty Insurance 20286 1.163000e+10 43.24
17 Regional Banks 28412 -1.000000e+00 44.47
18 Financial Exchanges & Data 1156375 4.109000e+10 62.92
19 Consumer Finance 927628 -1.000000e+00 98.27
20 Consumer Finance 1393612 -1.000000e+00 29.11
21 Diversified Financial Services 33185 1.405000e+10 22.96
22 Investment Banking & Brokerage 1015780 -1.000000e+00 21.41
23 Banks 35527 -1.000000e+00 19.82
24 Investment Banking & Brokerage 886982 -1.000000e+00 181.25
25 Banks 49196 -1.000000e+00 8.48
26 Property & Casualty Insurance 874766 1.840000e+10 49.15
27 Diversified Financial Services 1571949 6.710000e+09 26.07
28 Asset Management & Custody Banks 914208 1.181000e+10 18.94
29 Banks 19617 -1.000000e+00 63.89
.. ... ... ... ...
31 Multi-Sector Holdings 60086 1.570000e+10 54.22
32 Multi-line Insurance 59558 1.543000e+10 71.43
33 Multi-Sector Holdings 96223 8.590000e+09 27.97
34 Life & Health Insurance 1099219 5.980000e+10 71.24
35 Insurance Brokers 62709 3.507000e+10 12.91
36 Investment Banking & Brokerage 895421 -1.000000e+00 37.11
37 Banks 36270 -1.000000e+00 97.66
38 Consumer Finance 1593538 -1.000000e+00 12.71
39 Diversified Financial Services 1120193 1.165000e+10 34.83
40 Asset Management & Custody Banks 73124 -1.000000e+00 38.88
41 Thrifts & Mortgage Finance 1378946 -1.000000e+00 15.85
42 Diversified Financial Services 1126328 1.642000e+10 37.52
43 Property & Casualty Insurance 80661 2.171000e+10 13.72
44 Banks 713676 -1.000000e+00 94.38
45 Diversified Financial Services 1137774 4.520000e+10 130.72
46 Diversified Financial Services 1281761 -1.000000e+00 13.04
47 Investment Banking & Brokerage 316709 -1.000000e+00 10.03
48 Diversified Financial Services 64040 3.114000e+10 1.78
49 Banks 750556 -1.000000e+00 46.63
50 Diversified Financial Services 93751 -1.000000e+00 46.74
51 Consumer Finance 1601712 -1.000000e+00 17.37
52 Life & Health Insurance 320335 8.730000e+09 42.78
53 Diversified Financial Services 1113169 1.651000e+10 20.46
54 Property & Casualty Insurance 86312 3.293000e+10 83.05
55 Diversified Financial Services 5513 1.055000e+10 40.33
56 Banks 36104 -1.000000e+00 24.63
57 Banks 72971 -1.000000e+00 35.21
58 Insurance Brokers 1140536 1.711000e+10 78.47
59 Property & Casualty Insurance 875159 1.011000e+10 42.95
60 Regional Banks 109380 -1.000000e+00 34.10
ebitda dividentShare DividentYield earningShare BookPrice \
0 4.610000e+09 1.72 2.45 6.31 1.26
1 5.330000e+09 1.28 1.96 0.31 0.76
2 1.090000e+09 2.12 2.17 9.32 1.25
3 8.611700e+08 1.56 2.86 2.32 2.67
4 2.910000e+09 1.32 1.75 3.69 1.45
5 2.790000e+09 3.00 2.65 7.37 2.64
6 2.490000e+09 1.32 1.16 5.42 5.43
7 -1.000000e+00 1.28 1.67 5.65 3.33
8 -1.000000e+00 0.30 1.28 1.50 0.95
9 -1.000000e+00 1.20 2.55 2.77 1.40
10 2.320000e+09 0.80 1.98 2.97 1.90
11 -1.000000e+00 0.76 1.70 3.15 1.33
12 4.870000e+09 10.00 2.67 19.04 2.13
13 -1.000000e+00 0.64 1.12 4.72 0.76
14 4.730000e+09 2.76 2.07 7.46 1.27
15 -1.000000e+00 0.56 1.51 1.97 0.96
16 9.990000e+08 1.92 2.72 3.89 1.62
17 -1.000000e+00 0.92 1.33 2.68 1.53
18 2.370000e+09 2.40 1.99 4.29 1.91
19 -1.000000e+00 1.60 1.79 6.89 0.90
20 -1.000000e+00 1.20 1.74 5.77 2.39
21 1.040000e+09 1.32 1.12 3.95 5.11
22 -1.000000e+00 0.00 0.00 1.98 1.77
23 -1.000000e+00 0.56 2.09 1.93 1.33
24 -1.000000e+00 2.60 1.10 16.29 1.29
25 -1.000000e+00 0.32 2.32 0.67 1.61
26 2.310000e+09 0.92 1.88 3.47 1.00
27 2.620000e+09 0.68 1.17 2.44 2.22
28 1.350000e+09 1.12 3.80 2.06 1.54
29 -1.000000e+00 1.92 2.21 6.19 1.35
.. ... ... ... ... ...
31 2.630000e+09 0.25 0.54 0.48 0.86
32 1.810000e+09 1.16 1.67 5.29 0.96
33 1.060000e+09 0.25 1.05 0.12 0.85
34 5.450000e+09 1.60 2.88 3.26 0.77
35 3.070000e+09 1.36 1.98 3.25 5.29
36 -1.000000e+00 0.80 1.83 2.92 1.16
37 -1.000000e+00 2.80 1.71 7.78 1.67
38 -1.000000e+00 0.64 4.21 2.12 1.19
39 1.170000e+09 1.28 1.87 2.85 1.96
40 -1.000000e+00 1.52 1.82 4.32 2.14
41 -1.000000e+00 0.68 3.57 0.92 1.18
42 1.690000e+09 1.72 2.97 4.27 1.54
43 1.800000e+09 0.68 1.79 1.76 2.73
44 -1.000000e+00 2.20 1.81 7.30 1.28
45 9.750000e+09 2.80 2.63 10.61 0.81
46 -1.000000e+00 0.26 1.79 0.87 1.11
47 -1.000000e+00 0.32 0.76 1.31 4.17
48 2.430000e+09 1.64 1.36 6.78 67.65
49 -1.000000e+00 1.04 1.80 3.61 1.23
50 -1.000000e+00 1.52 2.00 5.56 1.63
51 -1.000000e+00 0.52 1.42 2.71 2.10
52 8.627600e+08 0.56 0.75 4.43 1.73
53 1.930000e+09 2.16 3.11 4.75 3.32
54 5.240000e+09 2.68 2.27 10.28 1.41
55 1.560000e+09 0.80 1.74 3.81 1.13
56 -1.000000e+00 1.12 2.11 3.24 2.15
57 -1.000000e+00 1.52 2.69 3.99 1.59
58 1.360000e+09 1.92 1.52 1.85 1.60
59 8.581400e+08 0.80 2.12 1.27 0.87
60 -1.000000e+00 0.32 0.74 1.99 1.24
SalesPrice earningsGrowth earningsRatio US_state
0 1.29 1.51 11.10 Georgia
1 1.25 0.69 209.32 New York
2 0.67 2.76 10.42 New York
3 1.74 1.61 23.20 Illinois
4 0.77 1.35 20.37 Illinois
5 1.52 1.45 15.23 Minnesota
6 2.55 2.06 20.78 United Kingdom
7 2.32 2.09 13.52 New York
8 3.01 1.23 15.09 North Carolina
9 3.68 2.84 16.68 North Carolina
10 3.54 -4.18 13.39 California
11 3.07 1.16 14.20 New York
12 5.49 1.51 19.64 New York
13 2.49 1.54 11.83 New York
14 2.19 4.97 17.62 Switzerland
15 3.81 1.50 18.36 Rhode Island
16 2.14 -3.95 18.14 Ohio
17 4.59 0.80 25.20 Texas
18 11.69 3.04 28.22 Illinois
19 2.25 1.31 12.68 Virginia
20 3.12 1.39 12.01 Illinois
21 4.67 1.77 29.69 Georgia
22 4.99 1.05 18.91 New York
23 3.46 7.40 13.52 Ohio
24 3.17 0.99 14.08 New York
25 4.44 1.38 20.19 Ohio
26 1.02 2.47 14.05 Connecticut
27 1.57 1.62 23.91 Georgia
28 2.52 1.63 14.04 Georgia
29 3.40 2.14 13.67 New York
.. ... ... ... ...
31 1.19 3.11 97.24 New York
32 1.19 1.06 12.75 Pennsylvania
33 0.81 6.74 203.85 New York
34 0.90 1.56 16.72 New York
35 2.67 1.91 20.92 New York
36 2.31 0.96 14.55 New York
37 4.99 2.52 20.90 New York
38 2.10 2.86 7.09 Delaware
39 3.13 1.76 24.79 New York
40 3.81 1.50 19.20 Illinois
41 4.51 9.72 20.38 Connecticut
42 1.42 1.71 13.38 Iowa
43 0.93 3.02 21.27 Ohio
44 3.96 1.88 16.50 Pennsylvania
45 0.72 3.44 9.91 New Jersey
46 3.29 2.50 16.49 Alabama
47 7.43 1.26 31.48 California
48 5.54 1.92 17.72 New York
49 3.55 3.33 15.74 Georgia
50 2.85 1.72 13.71 Massachusetts
51 4.27 1.15 13.22 Connecticut
52 2.26 2.31 16.58 Texas
53 3.94 1.94 14.20 Maryland
54 1.19 2.15 11.46 New York
55 0.97 1.67 11.92 Tennessee
56 4.53 2.70 16.25 Minnesota
57 3.33 1.88 14.12 California
58 2.51 0.27 67.82 United Kingdom
59 0.98 1.29 29.63 Bermuda
60 3.75 1.91 21.20 Utah
[61 rows x 17 columns]
Dataset for Utilities
symbol security SEC GICS_Sector \
0 AEE Ameren Corp reports Utilities
1 AEP American Electric Power reports Utilities
2 AWK American Water Works Company Inc reports Utilities
3 CMS CMS Energy reports Utilities
4 D Dominion Resources reports Utilities
5 DTE DTE Energy Co. reports Utilities
6 DUK Duke Energy reports Utilities
7 ED Consolidated Edison reports Utilities
8 EIX Edison Int'l reports Utilities
9 ES Eversource Energy reports Utilities
10 ETR Entergy Corp. reports Utilities
11 EXC Exelon Corp. reports Utilities
12 LNT Alliant Energy Corp reports Utilities
13 NEE NextEra Energy reports Utilities
14 NI NiSource Inc. reports Utilities
15 PCG PG&E Corp. reports Utilities
16 PEG Public Serv. Enterprise Inc. reports Utilities
17 PNW Pinnacle West Capital reports Utilities
18 PPL PPL Corp. reports Utilities
19 SCG SCANA Corp reports Utilities
20 SO Southern Co. reports Utilities
21 SRE Sempra Energy reports Utilities
22 WEC Wec Energy Group Inc reports Utilities
23 XEL Xcel Energy Inc reports Utilities
GICS_subIndustry CIK marketCapital bookValue ebitda \
0 MultiUtilities 1002910 1.277000e+10 29.65 2.290000e+09
1 Electric Utilities 4904 3.150000e+10 35.38 5.440000e+09
2 Water Utilities 1410636 1.307000e+10 29.43 1.520000e+09
3 MultiUtilities 811156 1.180000e+10 15.26 1.890000e+09
4 Electric Utilities 715957 4.781000e+10 23.86 5.420000e+09
5 MultiUtilities 936340 1.770000e+10 50.88 2.150000e+09
6 Electric Utilities 1326160 5.411000e+10 58.77 9.610000e+09
7 Electric Utilities 1047862 2.266000e+10 46.78 3.590000e+09
8 Electric Utilities 827052 2.375000e+10 36.26 3.690000e+09
9 MultiUtilities 72741 1.753000e+10 33.53 2.510000e+09
10 Electric Utilities 65984 1.283000e+10 56.21 3.510000e+09
11 MultiUtilities 1109357 3.313000e+10 28.19 8.700000e+09
12 Electric Utilities 352541 8.570000e+09 16.96 1.030000e+09
13 MultiUtilities 753308 5.802000e+10 51.90 7.670000e+09
14 MultiUtilities 1111711 7.220000e+09 11.82 1.350000e+09
15 MultiUtilities 1004980 3.130000e+10 34.35 4.290000e+09
16 Electric Utilities 788784 2.239000e+10 26.68 3.530000e+09
17 MultiUtilities 764622 8.640000e+09 43.64 1.410000e+09
18 Electric Utilities 922224 2.368000e+10 14.69 3.940000e+09
19 MultiUtilities 754737 9.820000e+09 39.71 1.540000e+09
20 Electric Utilities 92122 4.844000e+10 25.05 7.410000e+09
21 MultiUtilities 1032208 2.564000e+10 49.31 2.830000e+09
22 Electric Utilities 783325 1.864000e+10 28.17 2.400000e+09
23 MultiUtilities 72903 2.099000e+10 21.63 3.590000e+09
dividentShare DividentYield earningShare BookPrice SalesPrice \
0 1.76 3.40 2.670 1.7400 2.150
1 2.36 3.75 1.240 1.7900 1.900
2 1.50 2.07 2.600 2.4400 3.900
3 1.33 3.18 2.081 2.7549 1.872
4 3.02 4.00 3.320 3.1500 4.210
5 3.30 3.40 4.540 1.9100 1.700
6 3.42 4.45 4.130 1.3100 2.320
7 2.76 3.77 4.060 1.5700 1.850
8 2.17 3.01 2.700 1.9800 2.070
9 1.78 3.28 2.810 1.6200 2.280
10 3.48 4.93 7.160 1.2600 1.180
11 1.27 3.63 1.330 1.2400 1.070
12 1.26 3.42 1.510 2.1700 2.570
13 3.48 2.87 6.250 2.3600 3.550
14 0.64 2.88 0.940 1.8500 1.640
15 1.96 3.23 1.670 1.7600 1.790
16 1.64 3.81 2.540 1.6200 2.360
17 2.62 3.41 3.840 1.7500 2.440
18 1.52 4.44 2.690 2.3400 3.130
19 2.30 3.36 3.980 1.7200 2.360
20 2.24 4.62 2.660 1.9400 2.610
21 3.02 2.98 5.390 2.0400 2.520
22 2.08 3.57 2.910 2.0700 2.500
23 1.36 3.34 2.170 1.8800 1.890
earningsGrowth earningsRatio US_state
0 3.31 19.6900 Missouri
1 11.53 51.5800 Ohio
2 3.39 28.2600 New Jersey
3 2.87 20.3111 Michigan
4 3.32 22.9900 Virginia
5 3.34 21.7100 Michigan
6 9.10 19.0000 North Carolina
7 9.16 18.3200 New York
8 9.56 27.0200 California
9 3.18 19.6900 Massachusetts
10 -1.25 10.0000 Louisiana
11 2.20 26.9000 Illinois
12 3.27 24.9200 Wisconsin
13 2.61 19.8000 Florida
14 2.26 23.7700 Indiana
15 2.89 37.1500 California
16 12.82 17.4200 New Jersey
17 3.64 20.2000 Arizona
18 5.95 12.9400 Pennsylvania
19 2.94 17.2600 South Carolina
20 5.32 18.5600 Georgia
21 3.24 19.0000 California
22 2.94 20.2600 Wisconsin
23 0.00 19.0400 Minnesota
Dataset for Energy
symbol security SEC GICS_Sector \
0 FTI FMC Technologies Inc. reports Energy
1 KMI Kinder Morgan reports Energy
2 MPC Marathon Petroleum reports Energy
3 OKE ONEOK reports Energy
4 PSX Phillips 66 reports Energy
5 RIG Transocean reports Energy
6 SE Spectra Energy Corp. reports Energy
7 TSO Tesoro Petroleum Co. reports Energy
8 VLO Valero Energy reports Energy
9 XOM Exxon Mobil Corp. reports Energy
GICS_subIndustry CIK marketCapital \
0 Oil & Gas Equipment & Services 1135152 4.010000e+09
1 Oil & Gas Refining & Marketing & Transportation 1506307 4.982000e+10
2 Oil & Gas Refining & Marketing & Transportation 1510295 2.536000e+10
3 Oil & Gas Exploration & Production 1039684 1.160000e+10
4 Oil & Gas Refining & Marketing & Transportation 1534701 4.251000e+10
5 Oil & Gas Drilling 1451505 5.110000e+09
6 Oil & Gas Refining & Marketing & Transportation 1373835 2.922000e+10
7 Oil & Gas Refining & Marketing & Transportation 50104 9.560000e+09
8 Oil & Gas Refining & Marketing & Transportation 1035002 2.977000e+10
9 Integrated Oil & Gas 34088 3.478700e+11
bookValue ebitda dividentShare DividentYield earningShare \
0 43.16 1.310000e+09 1.12 3.16 4.62
1 15.44 6.160000e+09 0.50 2.23 0.25
2 25.37 4.430000e+09 1.44 2.93 2.12
3 1.02 1.650000e+09 2.46 4.48 1.35
4 43.98 3.100000e+09 2.52 3.04 3.82
5 41.27 1.770000e+09 0.00 0.00 3.16
6 10.65 2.410000e+09 1.76 4.19 0.46
7 46.53 2.130000e+09 2.20 2.68 5.89
8 44.89 5.590000e+09 2.40 3.57 4.72
9 41.14 2.228000e+10 3.00 3.51 2.14
BookPrice SalesPrice earningsGrowth earningsRatio US_state
0 0.77 0.38 -2.92 7.27 Texas
1 1.42 3.75 -63.72 90.08 Texas
2 1.91 0.47 -1.48 22.62 Ohio
3 52.82 1.38 6.46 40.70 Oklahoma
4 1.87 0.62 -7.46 21.37 Texas
5 0.34 1.17 -0.16 4.42 Switzerland
6 3.90 5.91 3.30 91.54 Texas
7 1.79 0.42 -0.84 13.72 Texas
8 1.52 0.42 -1.97 13.94 Texas
9 2.06 1.79 2.93 39.27 Texas
Dataset for Materials
symbol security SEC GICS_Sector \
0 ALB Albemarle Corp reports Materials
1 APD Air Products & Chemicals Inc reports Materials
2 AVY Avery Dennison Corp reports Materials
3 BLL Ball Corp reports Materials
4 CF CF Industries Holdings Inc reports Materials
5 DD Du Pont (E.I.) reports Materials
6 DOW Dow Chemical reports Materials
7 ECL Ecolab Inc. reports Materials
8 EMN Eastman Chemical reports Materials
9 IFF Intl Flavors & Fragrances reports Materials
10 IP International Paper reports Materials
11 LYB LyondellBasell reports Materials
12 MLM Martin Marietta Materials reports Materials
13 MON Monsanto Co. reports Materials
14 MOS The Mosaic Company reports Materials
15 NUE Nucor Corp. reports Materials
16 PPG PPG Industries reports Materials
17 PX Praxair Inc. reports Materials
18 SEE Sealed Air reports Materials
19 SHW Sherwin-Williams reports Materials
20 VMC Vulcan Materials reports Materials
21 WRK WestRock Company reports Materials
GICS_subIndustry CIK marketCapital bookValue \
0 Specialty Chemicals 915913 1.042000e+10 29.33
1 Industrial Gases 2969 3.043000e+10 32.90
2 Paper Packaging 8818 6.500000e+09 11.69
3 Metal & Glass Containers 9389 1.333000e+10 21.25
4 Fertilizers & Agricultural Chemicals 1324404 8.230000e+09 16.56
5 Diversified Chemicals 30554 6.516000e+10 11.31
6 Diversified Chemicals 29915 6.596000e+10 23.49
7 Specialty Chemicals 31462 3.502000e+10 23.56
8 Diversified Chemicals 915389 1.135000e+10 30.26
9 Specialty Chemicals 51253 9.310000e+09 21.31
10 Paper Packaging 51434 2.327000e+10 10.24
11 Diversified Chemicals 1489393 3.801000e+10 14.86
12 Construction Materials 916076 1.457000e+10 65.47
13 Fertilizers & Agricultural Chemicals 1110783 4.750000e+10 10.04
14 Fertilizers & Agricultural Chemicals 1285785 1.099000e+10 28.09
15 Steel 73309 1.850000e+10 24.26
16 Diversified Chemicals 79879 2.640000e+10 19.06
17 Industrial Gases 884905 3.384000e+10 17.57
18 Paper Packaging 1012100 9.380000e+09 2.86
19 Specialty Chemicals 89800 2.798000e+10 17.37
20 Construction Materials 1396009 1.698000e+10 34.04
21 Paper Packaging 1636023 1.362000e+10 37.41
ebitda dividentShare DividentYield earningShare BookPrice \
0 9.729800e+08 1.22 1.28 1.91 3.22
1 3.130000e+09 3.44 2.42 2.60 4.29
2 7.076000e+08 1.64 2.22 3.45 6.24
3 1.240000e+09 0.52 0.68 1.74 3.60
4 1.300000e+09 1.20 3.29 0.30 2.14
5 5.070000e+09 1.52 1.96 2.86 6.72
6 8.590000e+09 1.84 3.00 3.52 2.56
7 2.870000e+09 1.48 1.22 3.60 5.16
8 2.030000e+09 2.04 2.63 5.84 2.56
9 7.017400e+08 2.56 2.14 5.03 5.58
10 2.930000e+09 1.85 3.23 2.08 5.56
11 6.080000e+09 3.40 3.57 8.99 6.34
12 9.177400e+08 1.68 0.70 6.34 3.59
13 4.010000e+09 2.16 1.97 3.65 10.81
14 1.270000e+09 1.10 3.50 1.25 1.10
15 2.050000e+09 1.51 2.47 1.59 2.48
16 2.530000e+09 1.60 1.57 3.28 5.35
17 3.460000e+09 3.15 2.62 5.21 6.79
18 1.080000e+09 0.64 1.30 2.21 16.99
19 1.950000e+09 3.36 1.10 11.99 17.55
20 9.772100e+08 0.80 0.60 2.74 3.84
21 2.180000e+09 1.60 2.97 0.54 1.44
SalesPrice earningsGrowth earningsRatio US_state
0 3.01 2.90 48.50 Louisiana
1 3.22 -75.67 53.82 Pennsylvania
2 1.08 1.71 21.17 California
3 1.59 2.46 43.73 Colorado
4 2.10 -4.95 117.63 Illinois
5 2.67 3.03 26.44 Delaware
6 1.38 2.10 16.94 Michigan
7 2.68 2.43 33.40 Minnesota
8 1.26 1.64 13.27 Tennessee
9 3.08 2.94 23.32 New York
10 1.11 2.14 27.26 Tennessee
11 1.35 -5.81 10.38 Netherlands
12 4.31 1.55 36.23 North Carolina
13 3.42 2.87 29.70 Missouri
14 1.45 -1.58 25.00 Minnesota
15 1.22 0.95 36.44 North Carolina
16 1.83 2.06 30.48 Pennsylvania
17 3.24 3.69 22.73 Connecticut
18 1.38 2.03 21.93 New Jersey
19 2.37 2.10 25.34 Ohio
20 4.84 2.02 46.85 Alabama
21 0.97 4.18 99.18 Virginia
Done
In [ ]:
Content source: markus-antero/Stock
Similar notebooks: