{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"# EventVestor: Earnings Guidance\n",
"\n",
"In this notebook, we'll take a look at EventVestor's *Earnings Guidance* dataset, available on the [Quantopian Store](https://www.quantopian.com/store). This dataset spans January 01, 2007 through the current day, and documents forward looking earnings guidance provided by companies.\n",
"\n",
"### Blaze\n",
"Before we dig into the data, we want to tell you about how you generally access Quantopian Store data sets. These datasets are available through an API service known as [Blaze](http://blaze.pydata.org). Blaze provides the Quantopian user with a convenient interface to access very large datasets.\n",
"\n",
"Blaze provides an important function for accessing these datasets. Some of these sets are many millions of records. Bringing that data directly into Quantopian Research directly just is not viable. So Blaze allows us to provide a simple querying interface and shift the burden over to the server side.\n",
"\n",
"It is common to use Blaze to reduce your dataset in size, convert it over to Pandas and then to use Pandas for further computation, manipulation and visualization.\n",
"\n",
"Helpful links:\n",
"* [Query building for Blaze](http://blaze.pydata.org/en/latest/queries.html)\n",
"* [Pandas-to-Blaze dictionary](http://blaze.pydata.org/en/latest/rosetta-pandas.html)\n",
"* [SQL-to-Blaze dictionary](http://blaze.pydata.org/en/latest/rosetta-sql.html).\n",
"\n",
"Once you've limited the size of your Blaze object, you can convert it to a Pandas DataFrames using:\n",
"> `from odo import odo` \n",
"> `odo(expr, pandas.DataFrame)`\n",
"\n",
"### Free samples and limits\n",
"One other key caveat: we limit the number of results returned from any given expression to 10,000 to protect against runaway memory usage. To be clear, you have access to all the data server side. We are limiting the size of the responses back from Blaze.\n",
"\n",
"There is a *free* version of this dataset as well as a paid one. The free one includes about three years of historical data, though not up to the current day.\n",
"\n",
"With preamble in place, let's get started:"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"# import the dataset\n",
"from quantopian.interactive.data.eventvestor import earnings_guidance\n",
"# or if you want to import the free dataset, use:\n",
"# from quantopian.interactive.data.eventvestor import earnings_guidance_free\n",
"\n",
"# import data operations\n",
"from odo import odo\n",
"# import other libraries we will use\n",
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"dshape(\"\"\"var * {\n",
" event_id: ?float64,\n",
" asof_date: datetime,\n",
" trade_date: ?datetime,\n",
" symbol: ?string,\n",
" event_type: ?string,\n",
" event_headline: ?string,\n",
" event_phase: ?string,\n",
" guidance_content: ?string,\n",
" guidance_gaap: ?string,\n",
" guidance_trend: ?string,\n",
" guidance_quality: ?string,\n",
" fiscal_quarter: ?string,\n",
" eps_low: ?float64,\n",
" eps_high: ?float64,\n",
" revenue_low: ?float64,\n",
" revenue_high: ?float64,\n",
" netincome_low: ?float64,\n",
" netincome_high: ?float64,\n",
" fiscal_year: ?string,\n",
" annual_trend: ?string,\n",
" event_rating: ?float64,\n",
" timestamp: datetime,\n",
" sid: ?int64\n",
" }\"\"\")"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Let's use blaze to understand the data a bit using Blaze dshape()\n",
"earnings_guidance.dshape"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"97769"
],
"text/plain": [
"97769"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# And how many rows are there?\n",
"# N.B. we're using a Blaze function to do this, not len()\n",
"earnings_guidance.count()"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
" \n",
" \n",
" | \n",
" event_id | \n",
" asof_date | \n",
" trade_date | \n",
" symbol | \n",
" event_type | \n",
" event_headline | \n",
" event_phase | \n",
" guidance_content | \n",
" guidance_gaap | \n",
" guidance_trend | \n",
" guidance_quality | \n",
" fiscal_quarter | \n",
" eps_low | \n",
" eps_high | \n",
" revenue_low | \n",
" revenue_high | \n",
" netincome_low | \n",
" netincome_high | \n",
" fiscal_year | \n",
" annual_trend | \n",
" event_rating | \n",
" timestamp | \n",
" sid | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 933903 | \n",
" 2007-01-02 | \n",
" 2007-01-02 | \n",
" INOD | \n",
" Guidance | \n",
" Numerex Raises 4Q and FY 06 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" Higher | \n",
" Open Ended | \n",
" 4Q 06 | \n",
" 0.00 | \n",
" 0.00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" FY 06 | \n",
" Higher | \n",
" 1 | \n",
" 2007-01-03 | \n",
" 9581 | \n",
"
\n",
" \n",
" 1 | \n",
" 138379 | \n",
" 2007-01-02 | \n",
" 2007-01-03 | \n",
" SLG | \n",
" Guidance | \n",
" SL Green Realty Issues FY 07 FFO Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 0.00 | \n",
" 0.00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" FY 07 | \n",
" New | \n",
" 1 | \n",
" 2007-01-03 | \n",
" 17448 | \n",
"
\n",
" \n",
" 2 | \n",
" 137809 | \n",
" 2007-01-03 | \n",
" 2007-01-03 | \n",
" AEO | \n",
" Guidance | \n",
" American Eagle Raises 4Q 06 EPS Guidance | \n",
" NaN | \n",
" EPS | \n",
" GAAP | \n",
" Higher | \n",
" Range | \n",
" 4Q 06 | \n",
" 0.64 | \n",
" 0.65 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2007-01-04 | \n",
" 11086 | \n",
"
\n",
" \n",
"
"
],
"text/plain": [
" event_id asof_date trade_date symbol event_type \\\n",
"0 933903 2007-01-02 2007-01-02 INOD Guidance \n",
"1 138379 2007-01-02 2007-01-03 SLG Guidance \n",
"2 137809 2007-01-03 2007-01-03 AEO Guidance \n",
"\n",
" event_headline event_phase guidance_content \\\n",
"0 Numerex Raises 4Q and FY 06 Guidance NaN Other Financial \n",
"1 SL Green Realty Issues FY 07 FFO Guidance NaN Other Financial \n",
"2 American Eagle Raises 4Q 06 EPS Guidance NaN EPS \n",
"\n",
" guidance_gaap guidance_trend ... eps_high revenue_low revenue_high \\\n",
"0 GAAP Higher ... 0.00 0 0 \n",
"1 Non-GAAP NaN ... 0.00 0 0 \n",
"2 GAAP Higher ... 0.65 0 0 \n",
"\n",
" netincome_low netincome_high fiscal_year annual_trend event_rating \\\n",
"0 0 0 FY 06 Higher 1 \n",
"1 0 0 FY 07 New 1 \n",
"2 0 0 NaN NaN 1 \n",
"\n",
" timestamp sid \n",
"0 2007-01-03 9581 \n",
"1 2007-01-03 17448 \n",
"2 2007-01-04 11086 \n",
"\n",
"[3 rows x 23 columns]"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Let's see what the data looks like. We'll grab the first three rows.\n",
"earnings_guidance[:3]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's go over the columns:\n",
"- **event_id**: the unique identifier for this event.\n",
"- **asof_date**: EventVestor's timestamp of event capture.\n",
"- **trade_date**: for event announcements made before trading ends, trade_date is the same as event_date. For announcements issued after market close, trade_date is next market open day.\n",
"- **symbol**: stock ticker symbol of the affected company.\n",
"- **event_type**: this should always be *Guidance*.\n",
"- **event_headline**: a brief description of the event\n",
"- **event_phase**: the inclusion of this field is likely an error on the part of the data vendor. We're currently attempting to resolve this.\n",
"- **guidance_content**: values include *EPS, EPS & Financial, Operational, Other Financial*\n",
"- **guidance_gaap**: values include *GAAP, Non-GAAP*\n",
"- **guidance_trend**: values include *Higher, Lower, Narrows, New, Reiterate, Withdrawal*\n",
"- **guidance_quality**: values include *Open Ended, Point, Range*\n",
"- **fiscal_quarter**: fiscal quarter for which guidance is provided\n",
"- **eps_low**: low end of the quarterly EPS guidance\n",
"- **eps_high**: high end of the quarterly EPS guidance\n",
"- **revenue_low**: low end of the quarterly revenue guidance\n",
"- **revenue_high**: high end of the quarterly revenue guidance\n",
"- **netincome_low**: low end of the quarterly net income guidance\n",
"- **netincome_high**: high end of the quarterly net income guidance\n",
"- **fiscal_year**: fiscal year for which the quarterly guidance is provided\n",
"- **annual_trend**: the annual guidance trend. Values include *Higher, Lower, Narrows, New, Reiterate, Withdrawal*\n",
"- **event_rating**: this is always 1. The meaning of this is uncertain.\n",
"- **timestamp**: this is our timestamp on when we registered the data.\n",
"- **sid**: the equity's unique identifier. Use this instead of the symbol."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We've done much of the data processing for you. Fields like `timestamp` and `sid` are standardized across all our Store Datasets, so the datasets are easy to combine. We have standardized the `sid` across all our equity databases.\n",
"\n",
"We can select columns and rows with ease. Below, we'll fetch all of Apple's entries from 2012."
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" \n",
" \n",
" | \n",
" event_id | \n",
" asof_date | \n",
" trade_date | \n",
" symbol | \n",
" event_type | \n",
" event_headline | \n",
" event_phase | \n",
" guidance_content | \n",
" guidance_gaap | \n",
" guidance_trend | \n",
" guidance_quality | \n",
" fiscal_quarter | \n",
" eps_low | \n",
" eps_high | \n",
" revenue_low | \n",
" revenue_high | \n",
" netincome_low | \n",
" netincome_high | \n",
" fiscal_year | \n",
" annual_trend | \n",
" event_rating | \n",
" timestamp | \n",
" sid | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 1385926 | \n",
" 2012-01-24 | \n",
" 2012-01-25 | \n",
" AAPL | \n",
" Guidance | \n",
" Apple Issues 2Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" Point | \n",
" 2Q 12 | \n",
" 8.50 | \n",
" 8.50 | \n",
" 3250 | \n",
" 3250 | \n",
" 0 | \n",
" 0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-25 | \n",
" 24 | \n",
"
\n",
" \n",
" 1 | \n",
" 1421102 | \n",
" 2012-04-24 | \n",
" 2012-04-25 | \n",
" AAPL | \n",
" Guidance | \n",
" Apple Issues 3Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" Point | \n",
" 3Q 12 | \n",
" 8.68 | \n",
" 8.68 | \n",
" 34000 | \n",
" 34000 | \n",
" 0 | \n",
" 0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-25 | \n",
" 24 | \n",
"
\n",
" \n",
" 2 | \n",
" 1456501 | \n",
" 2012-07-24 | \n",
" 2012-07-25 | \n",
" AAPL | \n",
" Guidance | \n",
" Apple Issues 4Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" Point | \n",
" 4Q 12 | \n",
" 7.65 | \n",
" 7.65 | \n",
" 34000 | \n",
" 34000 | \n",
" 0 | \n",
" 0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-07-25 | \n",
" 24 | \n",
"
\n",
" \n",
" 3 | \n",
" 1496798 | \n",
" 2012-10-25 | \n",
" 2012-10-26 | \n",
" AAPL | \n",
" Guidance | \n",
" Apple Issues 1Q 13 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" Point | \n",
" 1Q 13 | \n",
" 11.75 | \n",
" 11.75 | \n",
" 5200 | \n",
" 5200 | \n",
" 0 | \n",
" 0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-26 | \n",
" 24 | \n",
"
\n",
" \n",
"
"
],
"text/plain": [
" event_id asof_date trade_date symbol event_type \\\n",
"0 1385926 2012-01-24 2012-01-25 AAPL Guidance \n",
"1 1421102 2012-04-24 2012-04-25 AAPL Guidance \n",
"2 1456501 2012-07-24 2012-07-25 AAPL Guidance \n",
"3 1496798 2012-10-25 2012-10-26 AAPL Guidance \n",
"\n",
" event_headline event_phase guidance_content guidance_gaap \\\n",
"0 Apple Issues 2Q 12 Guidance NaN EPS & Financial GAAP \n",
"1 Apple Issues 3Q 12 Guidance NaN EPS & Financial GAAP \n",
"2 Apple Issues 4Q 12 Guidance NaN EPS & Financial GAAP \n",
"3 Apple Issues 1Q 13 Guidance NaN EPS & Financial GAAP \n",
"\n",
" guidance_trend ... eps_high revenue_low revenue_high netincome_low \\\n",
"0 New ... 8.50 3250 3250 0 \n",
"1 New ... 8.68 34000 34000 0 \n",
"2 New ... 7.65 34000 34000 0 \n",
"3 New ... 11.75 5200 5200 0 \n",
"\n",
" netincome_high fiscal_year annual_trend event_rating timestamp sid \n",
"0 0 NaN NaN 1 2012-01-25 24 \n",
"1 0 NaN NaN 1 2012-04-25 24 \n",
"2 0 NaN NaN 1 2012-07-25 24 \n",
"3 0 NaN NaN 1 2012-10-26 24 \n",
"\n",
"[4 rows x 23 columns]"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# get apple's sid first\n",
"aapl_sid = symbols('AAPL').sid\n",
"aapl_earnings = earnings_guidance[('2011-12-31' < earnings_guidance['asof_date']) & (earnings_guidance['asof_date'] <'2013-01-01') & (earnings_guidance.sid==aapl_sid)]\n",
"# When displaying a Blaze Data Object, the printout is automatically truncated to ten rows.\n",
"aapl_earnings.sort('asof_date')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Finally, suppose we want a DataFrame of all earnings guidances releases in 2012 in which revenue_low and revenue_high differ. Then we'll compute by how much they differ!"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" event_id | \n",
" asof_date | \n",
" trade_date | \n",
" symbol | \n",
" event_type | \n",
" event_headline | \n",
" event_phase | \n",
" guidance_content | \n",
" guidance_gaap | \n",
" guidance_trend | \n",
" ... | \n",
" revenue_low | \n",
" revenue_high | \n",
" netincome_low | \n",
" netincome_high | \n",
" fiscal_year | \n",
" annual_trend | \n",
" event_rating | \n",
" timestamp | \n",
" sid | \n",
" revenue_difference | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 1930090 | \n",
" 2012-07-26 | \n",
" 2012-07-26 | \n",
" ATE | \n",
" Guidance | \n",
" Advantest Corp. Issues 2Q 12 & Narrows FY 12 O... | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 72000.00 | \n",
" 77000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Narrows | \n",
" 1 | \n",
" 2012-07-27 | \n",
" 23052 | \n",
" 5000.00 | \n",
"
\n",
" \n",
" 1 | \n",
" 1496843 | \n",
" 2012-10-25 | \n",
" 2012-10-26 | \n",
" AMZN | \n",
" Guidance | \n",
" Amazon.com Issues 4Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 20250.00 | \n",
" 22750.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-26 | \n",
" 16841 | \n",
" 2500.00 | \n",
"
\n",
" \n",
" 2 | \n",
" 1496029 | \n",
" 2012-10-25 | \n",
" 2012-10-25 | \n",
" TSM | \n",
" Guidance | \n",
" Taiwan Semiconductor Issues 4Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 129000.00 | \n",
" 131000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-26 | \n",
" 17773 | \n",
" 2000.00 | \n",
"
\n",
" \n",
" 3 | \n",
" 1490534 | \n",
" 2012-09-10 | \n",
" 2012-09-10 | \n",
" TSM | \n",
" Guidance | \n",
" Taiwan Semiconductor Raises 3Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" Higher | \n",
" ... | \n",
" 136000.00 | \n",
" 138000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-09-11 | \n",
" 17773 | \n",
" 2000.00 | \n",
"
\n",
" \n",
" 4 | \n",
" 1454839 | \n",
" 2012-07-19 | \n",
" 2012-07-19 | \n",
" TSM | \n",
" Guidance | \n",
" Taiwan Semiconductor Issues 3Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 136000.00 | \n",
" 138000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-07-20 | \n",
" 17773 | \n",
" 2000.00 | \n",
"
\n",
" \n",
" 5 | \n",
" 1384154 | \n",
" 2012-01-18 | \n",
" 2012-01-18 | \n",
" TSM | \n",
" Guidance | \n",
" Taiwan Semiconductor Issues 1Q & FY 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 103000.00 | \n",
" 105000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-01-19 | \n",
" 17773 | \n",
" 2000.00 | \n",
"
\n",
" \n",
" 6 | \n",
" 1423149 | \n",
" 2012-04-26 | \n",
" 2012-04-26 | \n",
" TSM | \n",
" Guidance | \n",
" Taiwan Semiconductor Issues 2Q & Revises FY 12... | \n",
" NaN | \n",
" Operational | \n",
" NaN | \n",
" New | \n",
" ... | \n",
" 126000.00 | \n",
" 128000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-27 | \n",
" 17773 | \n",
" 2000.00 | \n",
"
\n",
" \n",
" 7 | \n",
" 1419797 | \n",
" 2012-04-20 | \n",
" 2012-04-20 | \n",
" INTU | \n",
" Guidance | \n",
" Intuit Reaffirms 3Q & FY 12 Earnings Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" Reiterate | \n",
" ... | \n",
" 0.00 | \n",
" 1950.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Reiterate | \n",
" 1 | \n",
" 2012-04-21 | \n",
" 8655 | \n",
" 1950.00 | \n",
"
\n",
" \n",
" 8 | \n",
" 1388974 | \n",
" 2012-01-31 | \n",
" 2012-02-01 | \n",
" AMZN | \n",
" Guidance | \n",
" Amazon Issues 1Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 12000.00 | \n",
" 13400.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-02-01 | \n",
" 16841 | \n",
" 1400.00 | \n",
"
\n",
" \n",
" 9 | \n",
" 1422959 | \n",
" 2012-04-26 | \n",
" 2012-04-27 | \n",
" AMZN | \n",
" Guidance | \n",
" Amazon.com Issues 2Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 11900.00 | \n",
" 13300.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-27 | \n",
" 16841 | \n",
" 1400.00 | \n",
"
\n",
" \n",
" 10 | \n",
" 1491411 | \n",
" 2012-10-16 | \n",
" 2012-10-17 | \n",
" INTC | \n",
" Guidance | \n",
" Intel Corp. Issues 4Q and Revises FY 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 13100.00 | \n",
" 14100.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-17 | \n",
" 3951 | \n",
" 1000.00 | \n",
"
\n",
" \n",
" 11 | \n",
" 1453377 | \n",
" 2012-07-17 | \n",
" 2012-07-18 | \n",
" INTC | \n",
" Guidance | \n",
" Intel Corp. Issues 3Q and Lowers FY 12 Revenue... | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 13800.00 | \n",
" 14800.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Lower | \n",
" 1 | \n",
" 2012-07-18 | \n",
" 3951 | \n",
" 1000.00 | \n",
"
\n",
" \n",
" 12 | \n",
" 1384551 | \n",
" 2012-01-19 | \n",
" 2012-01-20 | \n",
" INTC | \n",
" Guidance | \n",
" Intel Issues 1Q & FY 12 Outlook | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 12300.00 | \n",
" 13300.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-01-20 | \n",
" 3951 | \n",
" 1000.00 | \n",
"
\n",
" \n",
" 13 | \n",
" 1418488 | \n",
" 2012-04-17 | \n",
" 2012-04-18 | \n",
" INTC | \n",
" Guidance | \n",
" Intel Issues 2Q and Revises FY 12 Outlook | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 13100.00 | \n",
" 14100.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-18 | \n",
" 3951 | \n",
" 1000.00 | \n",
"
\n",
" \n",
" 14 | \n",
" 1495917 | \n",
" 2012-10-25 | \n",
" 2012-10-25 | \n",
" AVT | \n",
" Guidance | \n",
" Avnet Issues 2Q 13 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 5950.00 | \n",
" 6650.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-26 | \n",
" 661 | \n",
" 700.00 | \n",
"
\n",
" \n",
" 15 | \n",
" 1387009 | \n",
" 2012-01-26 | \n",
" 2012-01-26 | \n",
" AVT | \n",
" Guidance | \n",
" Avnet Issues 3Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 5950.00 | \n",
" 6550.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-27 | \n",
" 661 | \n",
" 600.00 | \n",
"
\n",
" \n",
" 16 | \n",
" 1467054 | \n",
" 2012-08-08 | \n",
" 2012-08-08 | \n",
" AVT | \n",
" Guidance | \n",
" Avnet Issues 1Q 13 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 5800.00 | \n",
" 6400.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-08-09 | \n",
" 661 | \n",
" 600.00 | \n",
"
\n",
" \n",
" 17 | \n",
" 1422463 | \n",
" 2012-04-26 | \n",
" 2012-04-26 | \n",
" AVT | \n",
" Guidance | \n",
" Avnet Issues 4Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 6300.00 | \n",
" 6900.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-27 | \n",
" 661 | \n",
" 600.00 | \n",
"
\n",
" \n",
" 18 | \n",
" 1459661 | \n",
" 2012-07-30 | \n",
" 2012-07-30 | \n",
" ARW | \n",
" Guidance | \n",
" Arrow Electronics Issues 3Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 4800.00 | \n",
" 5200.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 3Q 12 | \n",
" NaN | \n",
" 1 | \n",
" 2012-07-31 | \n",
" 538 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 19 | \n",
" 1492709 | \n",
" 2012-10-18 | \n",
" 2012-10-19 | \n",
" FLEX | \n",
" Guidance | \n",
" Flextronics International Issues 3Q 13 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 5800.00 | \n",
" 6200.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-19 | \n",
" 10953 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 20 | \n",
" 1389393 | \n",
" 2012-02-01 | \n",
" 2012-02-01 | \n",
" ARW | \n",
" Guidance | \n",
" Arrow Electronics Issues 1Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 4670.00 | \n",
" 5070.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-02-02 | \n",
" 538 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 21 | \n",
" 1424909 | \n",
" 2012-05-01 | \n",
" 2012-05-01 | \n",
" ARW | \n",
" Guidance | \n",
" Arrow Electronics Issues 2Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 5040.00 | \n",
" 5440.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-05-02 | \n",
" 538 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 22 | \n",
" 1418864 | \n",
" 2012-04-18 | \n",
" 2012-04-19 | \n",
" QCOM | \n",
" Guidance | \n",
" Qualcomm Issues 3Q & Raises FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 4450.00 | \n",
" 4850.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Higher | \n",
" 1 | \n",
" 2012-04-19 | \n",
" 6295 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 23 | \n",
" 1454039 | \n",
" 2012-07-18 | \n",
" 2012-07-19 | \n",
" QCOM | \n",
" Guidance | \n",
" Qualcomm Issues 4Q and Lowers FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 4450.00 | \n",
" 4850.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Lower | \n",
" 1 | \n",
" 2012-07-19 | \n",
" 6295 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 24 | \n",
" 1457395 | \n",
" 2012-07-25 | \n",
" 2012-07-26 | \n",
" FLEX | \n",
" Guidance | \n",
" Flextronics International Issues 2Q 13 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 5900.00 | \n",
" 6300.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-07-26 | \n",
" 10953 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 25 | \n",
" 1425487 | \n",
" 2012-05-01 | \n",
" 2012-05-02 | \n",
" FLEX | \n",
" Guidance | \n",
" Flextronics International Issues 1Q 13 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 5900.00 | \n",
" 6300.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-05-02 | \n",
" 10953 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 26 | \n",
" 1389626 | \n",
" 2012-02-01 | \n",
" 2012-02-02 | \n",
" QCOM | \n",
" Guidance | \n",
" Qualcomm Issues 2Q and Raises FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 4600.00 | \n",
" 5000.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Higher | \n",
" 1 | \n",
" 2012-02-02 | \n",
" 6295 | \n",
" 400.00 | \n",
"
\n",
" \n",
" 27 | \n",
" 1380315 | \n",
" 2012-01-04 | \n",
" 2012-01-05 | \n",
" STX | \n",
" Guidance | \n",
" Seagate Technology Raises 3Q 12 Outlook | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" Higher | \n",
" ... | \n",
" 4200.00 | \n",
" 4500.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-05 | \n",
" 24518 | \n",
" 300.00 | \n",
"
\n",
" \n",
" 28 | \n",
" 1384635 | \n",
" 2012-01-19 | \n",
" 2012-01-20 | \n",
" FLEX | \n",
" Guidance | \n",
" Flextronics Issues 4Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 6300.00 | \n",
" 6600.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-20 | \n",
" 10953 | \n",
" 300.00 | \n",
"
\n",
" \n",
" 29 | \n",
" 1419632 | \n",
" 2012-04-19 | \n",
" 2012-04-19 | \n",
" CVI | \n",
" Guidance | \n",
" CVR Energy Issues 1Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 1800.00 | \n",
" 2100.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-20 | \n",
" 22766 | \n",
" 300.00 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 1599 | \n",
" 1398611 | \n",
" 2012-02-21 | \n",
" 2012-02-22 | \n",
" ZIXI | \n",
" Guidance | \n",
" Zix Corp. Issues 1Q and FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 10.00 | \n",
" 10.10 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-02-22 | \n",
" 20822 | \n",
" 0.10 | \n",
"
\n",
" \n",
" 1600 | \n",
" 1403341 | \n",
" 2012-02-29 | \n",
" 2012-03-01 | \n",
" MTZ | \n",
" Guidance | \n",
" MasTec Issues 1Q and FY 12 Outlook | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 0.15 | \n",
" 0.17 | \n",
" 12.3 | \n",
" 14.1 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-03-01 | \n",
" 4667 | \n",
" 0.02 | \n",
"
\n",
" \n",
" 1601 | \n",
" 1387298 | \n",
" 2012-01-26 | \n",
" 2012-01-27 | \n",
" CYS | \n",
" Guidance | \n",
" CYS Investments Issues 4Q 11 Guidance | \n",
" NaN | \n",
" EPS | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 0.55 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-27 | \n",
" 38477 | \n",
" -0.55 | \n",
"
\n",
" \n",
" 1602 | \n",
" 1439505 | \n",
" 2012-02-14 | \n",
" 2012-02-14 | \n",
" KORS | \n",
" Guidance | \n",
" Michael Kors Holdings Issues 4Q & FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 350.00 | \n",
" 335.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-02-15 | \n",
" 42270 | \n",
" -15.00 | \n",
"
\n",
" \n",
" 1603 | \n",
" 1424617 | \n",
" 2012-04-26 | \n",
" 2012-04-26 | \n",
" INOD | \n",
" Guidance | \n",
" Innodata Isogen Issues 2Q 12 Revenue Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 21.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-27 | \n",
" 9581 | \n",
" -21.00 | \n",
"
\n",
" \n",
" 1604 | \n",
" 1382294 | \n",
" 2012-01-11 | \n",
" 2012-01-11 | \n",
" SAAS | \n",
" Guidance | \n",
" inContact Issues 4Q 11 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 23.50 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-12 | \n",
" 31137 | \n",
" -23.50 | \n",
"
\n",
" \n",
" 1605 | \n",
" 1441324 | \n",
" 2012-06-06 | \n",
" 2012-06-06 | \n",
" AMSC | \n",
" Guidance | \n",
" American Superconductor Issues 1Q 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 26.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 10.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-06-07 | \n",
" 393 | \n",
" -26.00 | \n",
"
\n",
" \n",
" 1606 | \n",
" 1393252 | \n",
" 2012-02-09 | \n",
" 2012-02-09 | \n",
" AMSC | \n",
" Guidance | \n",
" American Superconductor Updates 4Q 11 Outlook | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" NaN | \n",
" ... | \n",
" 27.00 | \n",
" 0.00 | \n",
" -24.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-02-10 | \n",
" 393 | \n",
" -27.00 | \n",
"
\n",
" \n",
" 1607 | \n",
" 1391621 | \n",
" 2012-02-06 | \n",
" 2012-02-07 | \n",
" BDE | \n",
" Guidance | \n",
" Black Diamond Issues 4Q and Raises FY 11 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 36.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 11 | \n",
" Higher | \n",
" 1 | \n",
" 2012-02-07 | \n",
" 18803 | \n",
" -36.00 | \n",
"
\n",
" \n",
" 1608 | \n",
" 1544306 | \n",
" 2012-06-04 | \n",
" 2012-06-04 | \n",
" CALL | \n",
" Guidance | \n",
" magicJack VocalTec Issues 2Q and Raises FY 12 ... | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 36.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Higher | \n",
" 1 | \n",
" 2012-06-05 | \n",
" 14457 | \n",
" -36.00 | \n",
"
\n",
" \n",
" 1609 | \n",
" 1411122 | \n",
" 2012-03-20 | \n",
" 2012-03-21 | \n",
" FSII | \n",
" Guidance | \n",
" FSI International Issues 3Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 50.00 | \n",
" 0.00 | \n",
" 7.0 | \n",
" 9.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-03-21 | \n",
" 3029 | \n",
" -50.00 | \n",
"
\n",
" \n",
" 1610 | \n",
" 1412014 | \n",
" 2012-03-23 | \n",
" 2012-03-23 | \n",
" KITD | \n",
" Guidance | \n",
" KIT digital Reaffirms 1Q and FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" Reiterate | \n",
" ... | \n",
" 72.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Reiterate | \n",
" 1 | \n",
" 2012-03-24 | \n",
" 30692 | \n",
" -72.00 | \n",
"
\n",
" \n",
" 1611 | \n",
" 1401903 | \n",
" 2012-02-27 | \n",
" 2012-02-28 | \n",
" KITD | \n",
" Guidance | \n",
" KIT digital Issues 1Q and Lowers FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 72.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Lower | \n",
" 1 | \n",
" 2012-02-28 | \n",
" 30692 | \n",
" -72.00 | \n",
"
\n",
" \n",
" 1612 | \n",
" 1409726 | \n",
" 2012-03-15 | \n",
" 2012-03-15 | \n",
" KITD | \n",
" Guidance | \n",
" KIT digital Reaffirms 1Q and FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" Reiterate | \n",
" ... | \n",
" 72.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Reiterate | \n",
" 1 | \n",
" 2012-03-16 | \n",
" 30692 | \n",
" -72.00 | \n",
"
\n",
" \n",
" 1613 | \n",
" 1490036 | \n",
" 2012-10-11 | \n",
" 2012-10-12 | \n",
" ET | \n",
" Guidance | \n",
" ExactTarget Raises 3Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" Higher | \n",
" ... | \n",
" 72.00 | \n",
" 0.00 | \n",
" -3.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-10-12 | \n",
" 42700 | \n",
" -72.00 | \n",
"
\n",
" \n",
" 1614 | \n",
" 1391196 | \n",
" 2012-02-02 | \n",
" 2012-02-02 | \n",
" FTK | \n",
" Guidance | \n",
" Flotek Industries Issues 4Q and FY 11 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 74.50 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 11 | \n",
" New | \n",
" 1 | \n",
" 2012-02-03 | \n",
" 27496 | \n",
" -74.50 | \n",
"
\n",
" \n",
" 1615 | \n",
" 1417909 | \n",
" 2012-04-16 | \n",
" 2012-04-16 | \n",
" FTK | \n",
" Guidance | \n",
" Flotek Industries Raises 1Q 12 Revenues Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 78.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-17 | \n",
" 27496 | \n",
" -78.00 | \n",
"
\n",
" \n",
" 1616 | \n",
" 1437795 | \n",
" 2012-01-24 | \n",
" 2012-01-24 | \n",
" FIO | \n",
" Guidance | \n",
" Fusion-io Issues 3Q & Raises FY 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 85.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Higher | \n",
" 1 | \n",
" 2012-01-25 | \n",
" 41554 | \n",
" -85.00 | \n",
"
\n",
" \n",
" 1617 | \n",
" 1443898 | \n",
" 2012-05-14 | \n",
" 2012-05-14 | \n",
" MPAA | \n",
" Guidance | \n",
" Motorcar Parts of America Issues 4Q and FY 12 ... | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 90.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-05-15 | \n",
" 10992 | \n",
" -90.00 | \n",
"
\n",
" \n",
" 1618 | \n",
" 1400239 | \n",
" 2012-02-23 | \n",
" 2012-02-24 | \n",
" WBMD | \n",
" Guidance | \n",
" WebMD Health Issues 1Q and Updates FY 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 105.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" NaN | \n",
" 1 | \n",
" 2012-02-24 | \n",
" 27669 | \n",
" -105.00 | \n",
"
\n",
" \n",
" 1619 | \n",
" 1457505 | \n",
" 2012-07-25 | \n",
" 2012-07-26 | \n",
" CVD | \n",
" Guidance | \n",
" Covance Issues 3Q and Lowers FY 12 Guidance | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 538.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Lower | \n",
" 1 | \n",
" 2012-07-26 | \n",
" 25396 | \n",
" -538.00 | \n",
"
\n",
" \n",
" 1620 | \n",
" 1486588 | \n",
" 2012-01-06 | \n",
" 2012-01-06 | \n",
" VRX | \n",
" Guidance | \n",
" Valeant Pharmaceuticals Issues 4Q and Updates ... | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 650.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 11 | \n",
" NaN | \n",
" 1 | \n",
" 2012-01-07 | \n",
" 10908 | \n",
" -650.00 | \n",
"
\n",
" \n",
" 1621 | \n",
" 1416853 | \n",
" 2012-04-11 | \n",
" 2012-04-11 | \n",
" VMW | \n",
" Guidance | \n",
" VMware Raises 1Q 12 Guidance | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" Higher | \n",
" ... | \n",
" 1040.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-12 | \n",
" 34545 | \n",
" -1040.00 | \n",
"
\n",
" \n",
" 1622 | \n",
" 1392473 | \n",
" 2012-02-08 | \n",
" 2012-02-08 | \n",
" CTSH | \n",
" Guidance | \n",
" Cognizant Technology Solutions Issues 1Q and F... | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 1700.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" New | \n",
" 1 | \n",
" 2012-02-09 | \n",
" 18870 | \n",
" -1700.00 | \n",
"
\n",
" \n",
" 1623 | \n",
" 1428889 | \n",
" 2012-05-07 | \n",
" 2012-05-07 | \n",
" CTSH | \n",
" Guidance | \n",
" Cognizant Technology Solutions Issues 2Q and L... | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 1790.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Lower | \n",
" 1 | \n",
" 2012-05-08 | \n",
" 18870 | \n",
" -1790.00 | \n",
"
\n",
" \n",
" 1624 | \n",
" 1464692 | \n",
" 2012-08-06 | \n",
" 2012-08-06 | \n",
" CTSH | \n",
" Guidance | \n",
" Cognizant Technology Solutions Issues 3Q and R... | \n",
" NaN | \n",
" EPS & Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 1875.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Higher | \n",
" 1 | \n",
" 2012-08-07 | \n",
" 18870 | \n",
" -1875.00 | \n",
"
\n",
" \n",
" 1625 | \n",
" 1388993 | \n",
" 2012-01-31 | \n",
" 2012-02-01 | \n",
" STX | \n",
" Guidance | \n",
" Seagate Technology Raises 3Q 12 Outlook | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" Higher | \n",
" ... | \n",
" 4300.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-02-01 | \n",
" 24518 | \n",
" -4300.00 | \n",
"
\n",
" \n",
" 1626 | \n",
" 1422045 | \n",
" 2012-04-26 | \n",
" 2012-04-26 | \n",
" TYC | \n",
" Guidance | \n",
" Tyco International Issues 3Q and Raises FY 12 ... | \n",
" NaN | \n",
" EPS & Financial | \n",
" Non-GAAP | \n",
" New | \n",
" ... | \n",
" 4500.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" FY 12 | \n",
" Higher | \n",
" 1 | \n",
" 2012-04-27 | \n",
" 7679 | \n",
" -4500.00 | \n",
"
\n",
" \n",
" 1627 | \n",
" 1433072 | \n",
" 2012-04-17 | \n",
" 2012-04-17 | \n",
" STX | \n",
" Guidance | \n",
" Seagate Technology Updates 4Q 12 and Calendar ... | \n",
" NaN | \n",
" Other Financial | \n",
" Non-GAAP | \n",
" NaN | \n",
" ... | \n",
" 5000.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-04-18 | \n",
" 24518 | \n",
" -5000.00 | \n",
"
\n",
" \n",
" 1628 | \n",
" 1389165 | \n",
" 2012-01-31 | \n",
" 2012-02-01 | \n",
" STX | \n",
" Guidance | \n",
" Seagate Technology Issues 4Q 12 Outlook | \n",
" NaN | \n",
" Other Financial | \n",
" GAAP | \n",
" New | \n",
" ... | \n",
" 5000.00 | \n",
" 0.00 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 1 | \n",
" 2012-02-01 | \n",
" 24518 | \n",
" -5000.00 | \n",
"
\n",
" \n",
"
\n",
"
1629 rows × 24 columns
\n",
"
"
],
"text/plain": [
" event_id asof_date trade_date symbol event_type \\\n",
"0 1930090 2012-07-26 2012-07-26 ATE Guidance \n",
"1 1496843 2012-10-25 2012-10-26 AMZN Guidance \n",
"2 1496029 2012-10-25 2012-10-25 TSM Guidance \n",
"3 1490534 2012-09-10 2012-09-10 TSM Guidance \n",
"4 1454839 2012-07-19 2012-07-19 TSM Guidance \n",
"5 1384154 2012-01-18 2012-01-18 TSM Guidance \n",
"6 1423149 2012-04-26 2012-04-26 TSM Guidance \n",
"7 1419797 2012-04-20 2012-04-20 INTU Guidance \n",
"8 1388974 2012-01-31 2012-02-01 AMZN Guidance \n",
"9 1422959 2012-04-26 2012-04-27 AMZN Guidance \n",
"10 1491411 2012-10-16 2012-10-17 INTC Guidance \n",
"11 1453377 2012-07-17 2012-07-18 INTC Guidance \n",
"12 1384551 2012-01-19 2012-01-20 INTC Guidance \n",
"13 1418488 2012-04-17 2012-04-18 INTC Guidance \n",
"14 1495917 2012-10-25 2012-10-25 AVT Guidance \n",
"15 1387009 2012-01-26 2012-01-26 AVT Guidance \n",
"16 1467054 2012-08-08 2012-08-08 AVT Guidance \n",
"17 1422463 2012-04-26 2012-04-26 AVT Guidance \n",
"18 1459661 2012-07-30 2012-07-30 ARW Guidance \n",
"19 1492709 2012-10-18 2012-10-19 FLEX Guidance \n",
"20 1389393 2012-02-01 2012-02-01 ARW Guidance \n",
"21 1424909 2012-05-01 2012-05-01 ARW Guidance \n",
"22 1418864 2012-04-18 2012-04-19 QCOM Guidance \n",
"23 1454039 2012-07-18 2012-07-19 QCOM Guidance \n",
"24 1457395 2012-07-25 2012-07-26 FLEX Guidance \n",
"25 1425487 2012-05-01 2012-05-02 FLEX Guidance \n",
"26 1389626 2012-02-01 2012-02-02 QCOM Guidance \n",
"27 1380315 2012-01-04 2012-01-05 STX Guidance \n",
"28 1384635 2012-01-19 2012-01-20 FLEX Guidance \n",
"29 1419632 2012-04-19 2012-04-19 CVI Guidance \n",
"... ... ... ... ... ... \n",
"1599 1398611 2012-02-21 2012-02-22 ZIXI Guidance \n",
"1600 1403341 2012-02-29 2012-03-01 MTZ Guidance \n",
"1601 1387298 2012-01-26 2012-01-27 CYS Guidance \n",
"1602 1439505 2012-02-14 2012-02-14 KORS Guidance \n",
"1603 1424617 2012-04-26 2012-04-26 INOD Guidance \n",
"1604 1382294 2012-01-11 2012-01-11 SAAS Guidance \n",
"1605 1441324 2012-06-06 2012-06-06 AMSC Guidance \n",
"1606 1393252 2012-02-09 2012-02-09 AMSC Guidance \n",
"1607 1391621 2012-02-06 2012-02-07 BDE Guidance \n",
"1608 1544306 2012-06-04 2012-06-04 CALL Guidance \n",
"1609 1411122 2012-03-20 2012-03-21 FSII Guidance \n",
"1610 1412014 2012-03-23 2012-03-23 KITD Guidance \n",
"1611 1401903 2012-02-27 2012-02-28 KITD Guidance \n",
"1612 1409726 2012-03-15 2012-03-15 KITD Guidance \n",
"1613 1490036 2012-10-11 2012-10-12 ET Guidance \n",
"1614 1391196 2012-02-02 2012-02-02 FTK Guidance \n",
"1615 1417909 2012-04-16 2012-04-16 FTK Guidance \n",
"1616 1437795 2012-01-24 2012-01-24 FIO Guidance \n",
"1617 1443898 2012-05-14 2012-05-14 MPAA Guidance \n",
"1618 1400239 2012-02-23 2012-02-24 WBMD Guidance \n",
"1619 1457505 2012-07-25 2012-07-26 CVD Guidance \n",
"1620 1486588 2012-01-06 2012-01-06 VRX Guidance \n",
"1621 1416853 2012-04-11 2012-04-11 VMW Guidance \n",
"1622 1392473 2012-02-08 2012-02-08 CTSH Guidance \n",
"1623 1428889 2012-05-07 2012-05-07 CTSH Guidance \n",
"1624 1464692 2012-08-06 2012-08-06 CTSH Guidance \n",
"1625 1388993 2012-01-31 2012-02-01 STX Guidance \n",
"1626 1422045 2012-04-26 2012-04-26 TYC Guidance \n",
"1627 1433072 2012-04-17 2012-04-17 STX Guidance \n",
"1628 1389165 2012-01-31 2012-02-01 STX Guidance \n",
"\n",
" event_headline event_phase \\\n",
"0 Advantest Corp. Issues 2Q 12 & Narrows FY 12 O... NaN \n",
"1 Amazon.com Issues 4Q 12 Guidance NaN \n",
"2 Taiwan Semiconductor Issues 4Q 12 Guidance NaN \n",
"3 Taiwan Semiconductor Raises 3Q 12 Guidance NaN \n",
"4 Taiwan Semiconductor Issues 3Q 12 Guidance NaN \n",
"5 Taiwan Semiconductor Issues 1Q & FY 12 Guidance NaN \n",
"6 Taiwan Semiconductor Issues 2Q & Revises FY 12... NaN \n",
"7 Intuit Reaffirms 3Q & FY 12 Earnings Guidance NaN \n",
"8 Amazon Issues 1Q 12 Guidance NaN \n",
"9 Amazon.com Issues 2Q 12 Guidance NaN \n",
"10 Intel Corp. Issues 4Q and Revises FY 12 Guidance NaN \n",
"11 Intel Corp. Issues 3Q and Lowers FY 12 Revenue... NaN \n",
"12 Intel Issues 1Q & FY 12 Outlook NaN \n",
"13 Intel Issues 2Q and Revises FY 12 Outlook NaN \n",
"14 Avnet Issues 2Q 13 Guidance NaN \n",
"15 Avnet Issues 3Q 12 Guidance NaN \n",
"16 Avnet Issues 1Q 13 Guidance NaN \n",
"17 Avnet Issues 4Q 12 Guidance NaN \n",
"18 Arrow Electronics Issues 3Q 12 Guidance NaN \n",
"19 Flextronics International Issues 3Q 13 Guidance NaN \n",
"20 Arrow Electronics Issues 1Q 12 Guidance NaN \n",
"21 Arrow Electronics Issues 2Q 12 Guidance NaN \n",
"22 Qualcomm Issues 3Q & Raises FY 12 Guidance NaN \n",
"23 Qualcomm Issues 4Q and Lowers FY 12 Guidance NaN \n",
"24 Flextronics International Issues 2Q 13 Guidance NaN \n",
"25 Flextronics International Issues 1Q 13 Guidance NaN \n",
"26 Qualcomm Issues 2Q and Raises FY 12 Guidance NaN \n",
"27 Seagate Technology Raises 3Q 12 Outlook NaN \n",
"28 Flextronics Issues 4Q 12 Guidance NaN \n",
"29 CVR Energy Issues 1Q 12 Guidance NaN \n",
"... ... ... \n",
"1599 Zix Corp. Issues 1Q and FY 12 Guidance NaN \n",
"1600 MasTec Issues 1Q and FY 12 Outlook NaN \n",
"1601 CYS Investments Issues 4Q 11 Guidance NaN \n",
"1602 Michael Kors Holdings Issues 4Q & FY 12 Guidance NaN \n",
"1603 Innodata Isogen Issues 2Q 12 Revenue Guidance NaN \n",
"1604 inContact Issues 4Q 11 Guidance NaN \n",
"1605 American Superconductor Issues 1Q 12 Guidance NaN \n",
"1606 American Superconductor Updates 4Q 11 Outlook NaN \n",
"1607 Black Diamond Issues 4Q and Raises FY 11 Guidance NaN \n",
"1608 magicJack VocalTec Issues 2Q and Raises FY 12 ... NaN \n",
"1609 FSI International Issues 3Q 12 Guidance NaN \n",
"1610 KIT digital Reaffirms 1Q and FY 12 Guidance NaN \n",
"1611 KIT digital Issues 1Q and Lowers FY 12 Guidance NaN \n",
"1612 KIT digital Reaffirms 1Q and FY 12 Guidance NaN \n",
"1613 ExactTarget Raises 3Q 12 Guidance NaN \n",
"1614 Flotek Industries Issues 4Q and FY 11 Guidance NaN \n",
"1615 Flotek Industries Raises 1Q 12 Revenues Guidance NaN \n",
"1616 Fusion-io Issues 3Q & Raises FY 12 Guidance NaN \n",
"1617 Motorcar Parts of America Issues 4Q and FY 12 ... NaN \n",
"1618 WebMD Health Issues 1Q and Updates FY 12 Guidance NaN \n",
"1619 Covance Issues 3Q and Lowers FY 12 Guidance NaN \n",
"1620 Valeant Pharmaceuticals Issues 4Q and Updates ... NaN \n",
"1621 VMware Raises 1Q 12 Guidance NaN \n",
"1622 Cognizant Technology Solutions Issues 1Q and F... NaN \n",
"1623 Cognizant Technology Solutions Issues 2Q and L... NaN \n",
"1624 Cognizant Technology Solutions Issues 3Q and R... NaN \n",
"1625 Seagate Technology Raises 3Q 12 Outlook NaN \n",
"1626 Tyco International Issues 3Q and Raises FY 12 ... NaN \n",
"1627 Seagate Technology Updates 4Q 12 and Calendar ... NaN \n",
"1628 Seagate Technology Issues 4Q 12 Outlook NaN \n",
"\n",
" guidance_content guidance_gaap guidance_trend ... \\\n",
"0 Other Financial GAAP New ... \n",
"1 Other Financial GAAP New ... \n",
"2 Other Financial GAAP New ... \n",
"3 Other Financial GAAP Higher ... \n",
"4 Other Financial GAAP New ... \n",
"5 Other Financial GAAP New ... \n",
"6 Operational NaN New ... \n",
"7 EPS & Financial GAAP Reiterate ... \n",
"8 Other Financial GAAP New ... \n",
"9 Other Financial GAAP New ... \n",
"10 Other Financial Non-GAAP New ... \n",
"11 Other Financial GAAP New ... \n",
"12 Other Financial GAAP New ... \n",
"13 Other Financial GAAP New ... \n",
"14 EPS & Financial Non-GAAP New ... \n",
"15 EPS & Financial Non-GAAP New ... \n",
"16 EPS & Financial Non-GAAP New ... \n",
"17 EPS & Financial Non-GAAP New ... \n",
"18 EPS & Financial Non-GAAP New ... \n",
"19 EPS & Financial GAAP New ... \n",
"20 EPS & Financial Non-GAAP New ... \n",
"21 EPS & Financial Non-GAAP New ... \n",
"22 EPS & Financial GAAP New ... \n",
"23 EPS & Financial GAAP New ... \n",
"24 EPS & Financial GAAP New ... \n",
"25 EPS & Financial GAAP New ... \n",
"26 EPS & Financial GAAP New ... \n",
"27 Other Financial Non-GAAP Higher ... \n",
"28 EPS & Financial GAAP New ... \n",
"29 Other Financial GAAP New ... \n",
"... ... ... ... ... \n",
"1599 EPS & Financial Non-GAAP New ... \n",
"1600 EPS & Financial GAAP New ... \n",
"1601 EPS GAAP New ... \n",
"1602 EPS & Financial GAAP New ... \n",
"1603 Other Financial GAAP New ... \n",
"1604 Other Financial GAAP New ... \n",
"1605 EPS & Financial GAAP New ... \n",
"1606 EPS & Financial GAAP NaN ... \n",
"1607 EPS & Financial GAAP New ... \n",
"1608 EPS & Financial GAAP New ... \n",
"1609 Other Financial GAAP New ... \n",
"1610 EPS & Financial Non-GAAP Reiterate ... \n",
"1611 EPS & Financial Non-GAAP New ... \n",
"1612 EPS & Financial Non-GAAP Reiterate ... \n",
"1613 Other Financial Non-GAAP Higher ... \n",
"1614 Other Financial GAAP New ... \n",
"1615 Other Financial GAAP New ... \n",
"1616 Other Financial Non-GAAP New ... \n",
"1617 Other Financial GAAP New ... \n",
"1618 Other Financial Non-GAAP New ... \n",
"1619 EPS & Financial Non-GAAP New ... \n",
"1620 EPS & Financial Non-GAAP New ... \n",
"1621 Other Financial GAAP Higher ... \n",
"1622 EPS & Financial GAAP New ... \n",
"1623 EPS & Financial GAAP New ... \n",
"1624 EPS & Financial GAAP New ... \n",
"1625 Other Financial GAAP Higher ... \n",
"1626 EPS & Financial Non-GAAP New ... \n",
"1627 Other Financial Non-GAAP NaN ... \n",
"1628 Other Financial GAAP New ... \n",
"\n",
" revenue_low revenue_high netincome_low netincome_high fiscal_year \\\n",
"0 72000.00 77000.00 0.0 0.0 FY 12 \n",
"1 20250.00 22750.00 0.0 0.0 NaN \n",
"2 129000.00 131000.00 0.0 0.0 NaN \n",
"3 136000.00 138000.00 0.0 0.0 NaN \n",
"4 136000.00 138000.00 0.0 0.0 NaN \n",
"5 103000.00 105000.00 0.0 0.0 FY 12 \n",
"6 126000.00 128000.00 0.0 0.0 FY 12 \n",
"7 0.00 1950.00 0.0 0.0 FY 12 \n",
"8 12000.00 13400.00 0.0 0.0 NaN \n",
"9 11900.00 13300.00 0.0 0.0 NaN \n",
"10 13100.00 14100.00 0.0 0.0 FY 12 \n",
"11 13800.00 14800.00 0.0 0.0 FY 12 \n",
"12 12300.00 13300.00 0.0 0.0 FY 12 \n",
"13 13100.00 14100.00 0.0 0.0 FY 12 \n",
"14 5950.00 6650.00 0.0 0.0 NaN \n",
"15 5950.00 6550.00 0.0 0.0 NaN \n",
"16 5800.00 6400.00 0.0 0.0 NaN \n",
"17 6300.00 6900.00 0.0 0.0 NaN \n",
"18 4800.00 5200.00 0.0 0.0 3Q 12 \n",
"19 5800.00 6200.00 0.0 0.0 NaN \n",
"20 4670.00 5070.00 0.0 0.0 NaN \n",
"21 5040.00 5440.00 0.0 0.0 NaN \n",
"22 4450.00 4850.00 0.0 0.0 FY 12 \n",
"23 4450.00 4850.00 0.0 0.0 FY 12 \n",
"24 5900.00 6300.00 0.0 0.0 NaN \n",
"25 5900.00 6300.00 0.0 0.0 NaN \n",
"26 4600.00 5000.00 0.0 0.0 FY 12 \n",
"27 4200.00 4500.00 0.0 0.0 NaN \n",
"28 6300.00 6600.00 0.0 0.0 NaN \n",
"29 1800.00 2100.00 0.0 0.0 NaN \n",
"... ... ... ... ... ... \n",
"1599 10.00 10.10 0.0 0.0 FY 12 \n",
"1600 0.15 0.17 12.3 14.1 FY 12 \n",
"1601 0.55 0.00 0.0 0.0 NaN \n",
"1602 350.00 335.00 0.0 0.0 FY 12 \n",
"1603 21.00 0.00 0.0 0.0 NaN \n",
"1604 23.50 0.00 0.0 0.0 NaN \n",
"1605 26.00 0.00 0.0 10.0 NaN \n",
"1606 27.00 0.00 -24.0 0.0 NaN \n",
"1607 36.00 0.00 0.0 0.0 FY 11 \n",
"1608 36.00 0.00 0.0 0.0 FY 12 \n",
"1609 50.00 0.00 7.0 9.0 NaN \n",
"1610 72.00 0.00 0.0 0.0 FY 12 \n",
"1611 72.00 0.00 0.0 0.0 FY 12 \n",
"1612 72.00 0.00 0.0 0.0 FY 12 \n",
"1613 72.00 0.00 -3.0 0.0 NaN \n",
"1614 74.50 0.00 0.0 0.0 FY 11 \n",
"1615 78.00 0.00 0.0 0.0 NaN \n",
"1616 85.00 0.00 0.0 0.0 FY 12 \n",
"1617 90.00 0.00 0.0 0.0 FY 12 \n",
"1618 105.00 0.00 0.0 0.0 FY 12 \n",
"1619 538.00 0.00 0.0 0.0 FY 12 \n",
"1620 650.00 0.00 0.0 0.0 FY 11 \n",
"1621 1040.00 0.00 0.0 0.0 NaN \n",
"1622 1700.00 0.00 0.0 0.0 FY 12 \n",
"1623 1790.00 0.00 0.0 0.0 FY 12 \n",
"1624 1875.00 0.00 0.0 0.0 FY 12 \n",
"1625 4300.00 0.00 0.0 0.0 NaN \n",
"1626 4500.00 0.00 0.0 0.0 FY 12 \n",
"1627 5000.00 0.00 0.0 0.0 NaN \n",
"1628 5000.00 0.00 0.0 0.0 NaN \n",
"\n",
" annual_trend event_rating timestamp sid revenue_difference \n",
"0 Narrows 1 2012-07-27 23052 5000.00 \n",
"1 NaN 1 2012-10-26 16841 2500.00 \n",
"2 NaN 1 2012-10-26 17773 2000.00 \n",
"3 NaN 1 2012-09-11 17773 2000.00 \n",
"4 NaN 1 2012-07-20 17773 2000.00 \n",
"5 New 1 2012-01-19 17773 2000.00 \n",
"6 NaN 1 2012-04-27 17773 2000.00 \n",
"7 Reiterate 1 2012-04-21 8655 1950.00 \n",
"8 NaN 1 2012-02-01 16841 1400.00 \n",
"9 NaN 1 2012-04-27 16841 1400.00 \n",
"10 NaN 1 2012-10-17 3951 1000.00 \n",
"11 Lower 1 2012-07-18 3951 1000.00 \n",
"12 New 1 2012-01-20 3951 1000.00 \n",
"13 NaN 1 2012-04-18 3951 1000.00 \n",
"14 NaN 1 2012-10-26 661 700.00 \n",
"15 NaN 1 2012-01-27 661 600.00 \n",
"16 NaN 1 2012-08-09 661 600.00 \n",
"17 NaN 1 2012-04-27 661 600.00 \n",
"18 NaN 1 2012-07-31 538 400.00 \n",
"19 NaN 1 2012-10-19 10953 400.00 \n",
"20 NaN 1 2012-02-02 538 400.00 \n",
"21 NaN 1 2012-05-02 538 400.00 \n",
"22 Higher 1 2012-04-19 6295 400.00 \n",
"23 Lower 1 2012-07-19 6295 400.00 \n",
"24 NaN 1 2012-07-26 10953 400.00 \n",
"25 NaN 1 2012-05-02 10953 400.00 \n",
"26 Higher 1 2012-02-02 6295 400.00 \n",
"27 NaN 1 2012-01-05 24518 300.00 \n",
"28 NaN 1 2012-01-20 10953 300.00 \n",
"29 NaN 1 2012-04-20 22766 300.00 \n",
"... ... ... ... ... ... \n",
"1599 New 1 2012-02-22 20822 0.10 \n",
"1600 New 1 2012-03-01 4667 0.02 \n",
"1601 NaN 1 2012-01-27 38477 -0.55 \n",
"1602 New 1 2012-02-15 42270 -15.00 \n",
"1603 NaN 1 2012-04-27 9581 -21.00 \n",
"1604 NaN 1 2012-01-12 31137 -23.50 \n",
"1605 NaN 1 2012-06-07 393 -26.00 \n",
"1606 NaN 1 2012-02-10 393 -27.00 \n",
"1607 Higher 1 2012-02-07 18803 -36.00 \n",
"1608 Higher 1 2012-06-05 14457 -36.00 \n",
"1609 NaN 1 2012-03-21 3029 -50.00 \n",
"1610 Reiterate 1 2012-03-24 30692 -72.00 \n",
"1611 Lower 1 2012-02-28 30692 -72.00 \n",
"1612 Reiterate 1 2012-03-16 30692 -72.00 \n",
"1613 NaN 1 2012-10-12 42700 -72.00 \n",
"1614 New 1 2012-02-03 27496 -74.50 \n",
"1615 NaN 1 2012-04-17 27496 -78.00 \n",
"1616 Higher 1 2012-01-25 41554 -85.00 \n",
"1617 New 1 2012-05-15 10992 -90.00 \n",
"1618 NaN 1 2012-02-24 27669 -105.00 \n",
"1619 Lower 1 2012-07-26 25396 -538.00 \n",
"1620 NaN 1 2012-01-07 10908 -650.00 \n",
"1621 NaN 1 2012-04-12 34545 -1040.00 \n",
"1622 New 1 2012-02-09 18870 -1700.00 \n",
"1623 Lower 1 2012-05-08 18870 -1790.00 \n",
"1624 Higher 1 2012-08-07 18870 -1875.00 \n",
"1625 NaN 1 2012-02-01 24518 -4300.00 \n",
"1626 Higher 1 2012-04-27 7679 -4500.00 \n",
"1627 NaN 1 2012-04-18 24518 -5000.00 \n",
"1628 NaN 1 2012-02-01 24518 -5000.00 \n",
"\n",
"[1629 rows x 24 columns]"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# manipulate with Blaze first:\n",
"twentytwelve = earnings_guidance[(earnings_guidance['asof_date'] < '2012-12-31')&('2012-01-01' <= earnings_guidance['asof_date'])]\n",
"# now that we've got a much smaller object (len: ~39000 rows), we can convert it to a pandas DataFrame\n",
"df = odo(twentytwelve, pd.DataFrame)\n",
"df = df[df.revenue_low != df.revenue_high]\n",
"df['revenue_difference'] = df.revenue_high - df.revenue_low\n",
"df.sort('revenue_difference', ascending=False, inplace=True)\n",
"df.index = range(len(df))\n",
"# When printed: pandas DataFrames display the head(30) and tail(30) rows, and truncate the middle.\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.10"
}
},
"nbformat": 4,
"nbformat_minor": 0
}