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
| Entity | State | Ownership | Customers (Count) | Sales (Megawatthours) | Revenues (Thousands Dollars) | Average Price (cents/kWh) | |
|---|---|---|---|---|---|---|---|
| Alaska Electric Light&Power Co | AK | Investor Owned | 13,912 | 142,255 | 16,970.0 | 11.93 | |
| Alaska Power and Telephone Co | AK | Investor Owned | 4,803 | 24,391 | 7,470.0 | 30.63 | |
| Alaska Village Elec Coop, Inc | AK | Cooperative | 6,148 | 31,085 | 19,275.0 | 62.01 | |
| Anchorage Municipal Light and Power | AK | Municipal | 24,443 | 146,789 | 17,221.2 | 11.73 | |
| Barrow Utils & Elec Coop, Inc | AK | Cooperative | 1,471 | 11,511 | 1,364.0 | 11.85 | |
| Bethel Utilities Corp | AK | Investor Owned | 1,671 | 10,677 | 5,990.0 | 56.10 | |
| Chugach Electric Assn Inc | AK | Cooperative | 69,495 | 549,748 | 76,083.0 | 13.84 | |
| City & Borough of Sitka - (AK) | AK | Municipal | 3,669 | 47,899 | 4,570.0 | 9.54 | |
| City of Petersburg - (AK) | AK | Municipal | 1,354 | 20,803 | 2,010.2 | 9.66 |
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
| from pandas import DataFrame, concat, merge | |
| import Quandl | |
| symbol_list = ["AMZN","GOOG", "MSFT"] | |
| df = DataFrame(columns=['Effective Tax Rate', 'Earnings Before Interest and Taxes', 'symbol']) | |
| for symbol in symbol_list: | |
| effective_tax_parameter = "DMDRN/" + symbol + "_EFF_TAX" |
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
| require(Quandl) | |
| symbolList <- c("AMZN","GOOG", "MSFT", "AAPL", "GLW", "HAL") | |
| data <- data.frame("Date" = c(), | |
| "Effective Tax Rate" = c(), | |
| "Earnings Before Interest and Taxes" = c(), | |
| "symbol" = c()) | |
| for(symbol in symbolList){ |
NewerOlder