Watson Library closed – Tuesday 3/14

Due to the impending Winter storm expected to arrive tomorrow (Tuesday, March 14th), the Watson Library of Business & Economics will be closed.

Butler Library will open as study space from 9 a.m. to 9 p.m. with Public Safety presence only. All services, including stack access and circulation are closed. All other libraries are closed.

For more information regarding Columbia University campus closings, please visit…

preparedness.columbia.edu

For a schedule of Watson Library’s hours of operation, please visit…

https://hours.library.columbia.edu/?library=business

 

Extended Library hours for Mid-term Exams

Watson Library will remain open until Midnight from Sunday, March 5th, through Thursday, March 9th.  Here are our hours during the mid-term exam period…

Friday 3/03 : 8am-9pm

Saturday 3/04 : 10am-9pm

Sunday 3/05 : 10am-Midnight

Monday 3/06 : 8am-Midnight  [restricted access until 7pm]

Tuesday 3/07 : 8am-Midnight  [restricted access until 7pm]

Wednesday 3/08 : 8am-Midnight  [restricted access until 7pm]

Thursday 3/09 : 8am-Midnight  [restricted access until 7pm]

Friday 3/10 : 8am-5pm

Saturday 3/11 : CLOSED

Sunday 3/12 : CLOSED

Watson Library’s hours of operation for the rest of the Spring semester can be found here…

https://hours.library.columbia.edu/?library=business

 

 

Restricted Access Period for Mid-term Exams

From 8am to 7pm, Monday to Friday, February 20th through March 9th, Watson Library is open to all current graduate students, undergraduates in economics, faculty, and staff.

At all other times during these two weeks, i.e. after 7pm until close and all open hours on Saturday and Sunday, Watson Library is available to all University affiliates.

If you need materials or services during the 8am to 7pm period designated above and you are not in one of the groups listed please ask a library staff member for help.

Study space is available in Butler Library, Lehman Library (3rd floor of International Affairs Building), and the Science and Engineering Library (campus level of the NorthWest Corner Building).  http://library.columbia.edu/services/study-spaces.html

And check out the designated talk zones now available across the across the Columbia Libraries!  https://blogs.cul.columbia.edu/business/2015/09/01/talk-zones-come-to-columbia-libraries/

If you have any questions, please contact our staff at 212-854-7804 or business_circulation@library.columbia.edu.  Thanks.

ADI Hackathon – February 3rd-4th

The Application Development Initiative Group (ADI) will be hosting a Hackathon in the Watson Library of Business & Economics starting at 4pm this Friday, February 3rd, and ending at Noon on Saturday, February 4th.  During this time, use of the main ground floor reading room and study rooms (G01-G17) will be restricted to use by Hackathon participants.  The rest of the Library (including the computer workstations, 1M & 2M study spaces, and mezzanine study rooms) will remain accessible to all eligible patrons as usual.

To view the hours of operation for Watson Library, please visit this page… https://hours.library.columbia.edu/?library=business

To contact the Watson Library staff, please call 212-854-7804 during our open hours or send an  email to business_circulation@library.columbia.edu.  Thanks.

New Dataset: Infogroup’s Historical Business File

Columbia University has access to the Infogroup’s Historical Business File via WRDS.

Infogroup gathers geographic location-related business and residential data from various public data sources, such as local yellow pages, credit card billing data, etc. The Infogroup database at WRDS contains two packages: Historical Business and Historical Residential, both of which largely focus on US sectors.

The Historical Business data starts in 1997, while Historical Residential dates back to 2006. The Historical Business data is a calendar year-end snapshot of local business data. It contains business identification, location, industry, corporation hierarchy, employment, sales, and other fields.

For more information about this dataset, please visit this page

Figure 1

Table1

Table2

Using Python, R, MATLAB APIs for Datastream!

Do you know that in addition to Excel API, now you can also extract data easily from Datastream by using Python, R, or MATLAB?

For Python:

PyDatastream is a Python interface to the Thomson Dataworks Enterprise (DWE) SOAP API (non free), with some convenience functions for retrieving Datastream data specifically. This package requires valid credentials for this API.

It is a Python API for time-series data which abstracts the database which is used to store the data, providing a powerful and unified API. It provides an easy way to insert time-series datapoints and automatically downsample them into multiple levels of granularity for efficient querying time-series data at various time scales.

 

 

Alternatives for other scientific computing languages:

Please note that only PhD students and faculty can request credentials. Please email business@library.columbia.edu if you had any questions.

Intersession Hours

The Winter Intersession hours for the Watson Library of Business & Economics are as follows…

Friday,12/23                                             8am – 5pm

Saturday,12/24 – Tuesday,12/27           Closed

 

Wednesday, 12/28 – Friday,12/30         8am -5pm

Saturday,12/31 – Tuesday, 1/03            Closed

 

Wednesday, 1/04 – Friday, 1/06            8am -5pm

Saturday, 1/07 – Sunday, 1/08               10am-6pm

 

Monday, 1/09                                           7:30am-9pm

Tuesday, 1/10                                           7:30am-10pm

Wednesday, 1/11                                      7:30am – 7pm

Thursday, 1/12                                         7:30am – 10pm

Friday, 1/13                                              7:30am-7pm

Saturday, 1/14 – Monday, 1/16             Closed

Regular Spring Hours begin Tuesday  1/17/17 and can be found at http://hours.library.columbia.edu/?library=business

Happy Holidays!

 

 

final exams – restricted access period

From 8am to 7pm, Monday to Friday, December 8th through December 22nd, Watson Library is open to all current graduate students, undergraduates in economics, faculty and staff.

At all other times during these two weeks, i.e. after 7pm until close and all open hours on Saturday and Sunday, Watson Library is available to all University affiliates.

If you need materials or services during the 8am to 7pm period designated above and you are not in one of the groups listed please ask a library staff member for help.

Study space is available in Butler Library, Lehman Library (3rd floor of the International Affairs Building), and the Science and Engineering Library (campus level of the NorthWest Corner Building).  A listing of study space open NOW can be found at… http://hours.library.columbia.edu/study-spaces-open-now.php