Skip to content

Instantly share code, notes, and snippets.

@cds-amal

cds-amal/Analysis of Original DCAS CSV Drop - work in progress.ipynb

Created April 9, 2015 14:14
Show Gist options
  • Save cds-amal/5fd4456e2720b25896a7 to your computer and use it in GitHub Desktop.
Save cds-amal/5fd4456e2720b25896a7 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Analysis of Original DCAS CSV Drop - work in progress.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 100,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"[original] procPublicationRequest Oct-Dec 2014 (2).csv [original] procPublicationRequestDMSSPortal Oct-Dec 2014.csv\r\n"
]
}
],
"source": [
"%ls *original*"
]
},
{
"cell_type": "code",
"execution_count": 101,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"from bs4 import BeautifulSoup as Soup\n",
"from IPython.display import HTML\n",
"import pandas as pd\n",
"import numpy as np\n",
"import re\n",
"import pprint\n",
"import json"
]
},
{
"cell_type": "code",
"execution_count": 102,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"fns = [\n",
" '[original] procPublicationRequestDMSSPortal Oct-Dec 2014.csv',\n",
" '[original] procPublicationRequest Oct-Dec 2014 (2).csv'\n",
"]"
]
},
{
"cell_type": "code",
"execution_count": 103,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"r1 = pd.read_csv(fns[0], header=0, sep='|', encoding='ISO-8859-1')\n",
"r2 = pd.read_csv(fns[0], header=0, sep='|', encoding='ISO-8859-1')"
]
},
{
"cell_type": "code",
"execution_count": 104,
"metadata": {
"collapsed": false,
"scrolled": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"Int64Index: 1170 entries, 0 to 1169\n",
"Data columns (total 34 columns):\n",
"RequestID 1131 non-null object\n",
"StartDate 1007 non-null object\n",
"EndDate 1007 non-null object\n",
"AgencyCode 1101 non-null object\n",
"AgencyName 962 non-null object\n",
"AgencyDivision 732 non-null object\n",
"TypeOfNoticeCode 962 non-null float64\n",
"TypeOfNoticeDescription 962 non-null object\n",
"CategoryCode 962 non-null float64\n",
"CategoryDescription 962 non-null object\n",
"ShortTitle 962 non-null object\n",
"SelectionMethodCode 958 non-null float64\n",
"SelectionMethodDescription 958 non-null object\n",
"SectionID 962 non-null float64\n",
"SectionName 962 non-null object\n",
"SpecialCaseReasonCode 262 non-null float64\n",
"SpecialCaseReasonDescription 262 non-null object\n",
"PIN 958 non-null object\n",
"DueDate 544 non-null object\n",
"AddressToRequest 548 non-null object\n",
"ContactName 548 non-null object\n",
"ContactPhone 548 non-null float64\n",
"Email 512 non-null object\n",
"AddressToSubmit 543 non-null object\n",
"ContractAmount 414 non-null float64\n",
"RequestedBy 962 non-null object\n",
"PhoneRequested 962 non-null float64\n",
"ConfirmationNumber 962 non-null float64\n",
"ContactFax 330 non-null float64\n",
"AdditionalDescription 662 non-null object\n",
"OtherInfo 265 non-null object\n",
"VendorName 363 non-null object\n",
"VendorAddress 363 non-null object\n",
"Printout 823 non-null object\n",
"dtypes: float64(10), object(24)\n",
"memory usage: 319.9+ KB\n"
]
}
],
"source": [
"r1.info(null_counts=True)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"**Here are examples of requestID fields that are obviously incorrect.**\n",
"**These fields should be of the form: '20140930007' "
]
},
{
"cell_type": "code",
"execution_count": 105,
"metadata": {
"collapsed": false,
"scrolled": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Providers may express interest in future procurements by contacting Hazel Harber at ACS Office of Procurement-Administrative Contracts Unit, 150 William Street, Room 9K5, New York 10038; hazel.harber@acs.nyc.gov or by calling 212-676-8811 between the hours of 10:00 AM and 4:00 PM.\n",
"---\n",
"\n",
"<class 'str'> Suppliers may express interest in future procurements by contacting Hazel Harber at ACS Administrative Contracts Unit, 150 William Street, Location 9K5,\n",
"---\n",
"\n",
"<class 'str'> New York NY 1038; email to hazel.harber@acs.nyc.gov; or by calling (212) 676-8811 between the hours of 10:00AM and 4:00PM.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Providers may express interest in future procurements by contacting Clifford Sykes at ACS Office of Procurement-Administrative Contracts, 150 William Street 9K4/9th fl, New York, NY 10038; clifford.sykes@acs.nyc.gov or by calling 212-341-3529 between the hours of 10:00am and 4:00pm.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Optional Pre-bid Conference Date: Friday, 11/21/2014 AT 10:00 AM at 150 William Street, Room 8B1, New York, NY 10038\n",
"---\n",
"\n",
"<class 'str'> Bids forms and specifications may be obtained, free of charge, from the ACS Website, any time before the bid due date (recommended method). You must register at the ACS Website to obtain a copy of the bid. Copy the link into your browser to go to the appropriate page http://nyc.gov/html/acs/html/business/business.shtml. \n",
"---\n",
"\n",
"<class 'str'> In the event that you are unable to download this bid, a bid package may be requested via e-mail. Send all e-mail requests to Michael.Wright@acs.nyc.gov and hazel.harber@acs.nyc.gov. Please type the PIN above and type of service into the subject line. Also, type the name of the company, complete address, Contact Name, Phone and Fax numbes into the body of the e-mail. If all else fails, you may call (212) 341-3528 or (212) 676-8811 to make arrangements to pick up a bid package in person. \n",
"---\n",
"\n",
"<class 'str'> Bid pick up procedure vendors will need to provide the following information when picking up bids:Company Name, mailing address, primary contact person, E-Mail address and phone number of primary contract person.\n",
"---\n",
"\n",
"<class 'str'> E-PIN # 06813B0001\n",
"---\n",
"\n",
"<class 'str'> Late bids will not be opened; faxed or emailed bids will not be accepted.\n",
"---\n",
"\n",
"<class 'str'> Bid Documents are available after 12:00 noon on October 16, 2014 online at www.cuny.edu/cunybuilds for download or a CD version may be picked up during business hours at the address below. Proper Identification such as a driver’s license or passport will be required at the lobby entrance to 555 West 57th Street.\n",
"---\n",
"\n",
"<class 'str'> Bids will be opened at CUNY’s Offices located at 555 West 57th Street,\n",
"---\n",
"\n",
"<class 'str'> 16th Floor Conference Room, New York, NY 10019 on Wednesday, November 12, 2014 at 11:30 AM.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the General Services Administration of the Federal Government are advised to contact the Small Business Utilization Center, Jacob K. Javits Federal Building, 26 Federal Plaza, Room 18-130, NY, NY 10278 or by phone; 212-264-1234.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> Suppliers wishing to be considered for a contract with the Office of General Services of New York State are advised to contact the Procurement Services Group, Corning Tower, Room 3711, Empire State Plaza, Albany, NY 12242 or by phone: 518-474-6717.\n",
"---\n",
"\n",
"<class 'str'> This contract is subject to the Project Labor Agreement (“PLA”) entered into between the City and the Building and Construction Trades Council of Greater New York (“BCTC”) affiliated Local Unions.\n",
"---\n",
"\n",
"<class 'str'> This procurement is subject to participation goals for MBEs and/or WBEs as required by Local Law 1 of 2013.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> 20130808014\n",
"---\n",
"\n",
"<class 'str'> Companies certified by the New York City Department of Small Business Services as Minority- or Women- Owned Business Enterprises (”M/WBE”) are strongly encouraged to submit a bid. Also, this bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> DBE Goals (FHWA Funding)\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> DBE GOALS APPLY TO THIS CONTRACT\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'str'> This bid solicitation includes M/WBE Participation Goal(s). For the MWBE goals, please visit our website at www.nyc.gov/buildnyc see “Bid Opportunities”. To find out more about M/WBE certification visit www.nyc.gov/getcertified or call the DSBS certification helpline at (212) 513-6311.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> The M/WBE Total Participation Goal is 30 percent .\n",
"---\n",
"\n",
"<class 'str'> E-Pin: 05714P0004\n",
"---\n",
"\n",
"<class 'str'> Vendor Source #87114\n",
"---\n",
"\n",
"<class 'str'> Bidders are hereby advised that this contract is subject to the Project Labor Agreement (PLA).\n",
"---\n",
"\n",
"<class 'str'> Bidders are hereby advised that this contract is subject to Local Law 1 M/WBE Requirements. \n",
"---\n",
"\n",
"<class 'str'> Vendor Source ID# 87172\n",
"---\n",
"\n",
"<class 'str'> Vendor Source ID # 87370\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by Cash, USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one (1) signed original and five (5) copies of its technical proposal and two (2) signed originals of its fee proposal. The originals must be clearly labeled as such. If there are any differences between the original and any of the copies, the material in the original will prevail.\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one (1) signed original and five (5) copies of its Technical Proposal and five (5) signed originals of its Fee Proposal. The originals must be clearly labeled as such. If there are any differences between the original and any of the copies, the material in the original will prevail.\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one (1) signed original and five (5) copies of its Technical Proposal and five (5) signed originals of its Fee Proposal. The originals must be clearly labeled as such. If there are any differences between the original and any of the copies, the material in the original will prevail.\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one (1) signed original and five (5) copies of its Technical Proposal and five (5) signed originals of its Fee Proposal. The originals must be clearly labeled as such. If there are any differences between the original and any of the copies, the material in the original will prevail.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Http://www.nyc.gov/nychabusiness; Select Selling to NYCHA. Vendors are instructed to access the Getting Started: Register or Log-in link. If you have supplied goods or services to NYCHA in the past and you have your log-in credentials, click Returning iSupplier users, Log-in here. If you do not have your log-in credentials, select Click here to Request a Log-in ID. Upon access, select Sourcing Supplier then Sourcing Homepage, conduct a search for applicable RFQ number. Proposers electing to obtain a non-electronic paper document will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street, 6th Floor; obtain receipt and present it to the Supply Management Procurement Group; RFQ package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order or Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street, 6th Floor; obtain receipt and present it to 6th Floor, Supply Management Department. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendor electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street-6th Floor, New York, NY 10007; obtain receipt and present it to 6th floor/Supply Management Dept. Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendor electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street-6th Floor, New York, NY 10007; obtain receipt and present it to 6th floor/Supply Management Dept. Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendor electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street-6th Floor, New York, NY 10007; obtain receipt and present it to 6th floor/Supply Management Dept. Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendor electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street-6th Floor, New York, NY 10007; obtain receipt and present it to 6th floor/Supply Management Dept. Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Http://www.nyc.gov/nychabusiness; Select Selling to NYCHA. Vendors are instructed to access the Getting Started: Register or Log-in link. If you have supplied goods or services to NYCHA in the past and you have your log-in credentials, click Returning iSupplier users, Log-in here. If you do not have your log-in credentials, select Click here to Request a Log-in ID. Upon access, select Sourcing Supplier then Sourcing Homepage, conduct a search for applicable RFQ number. Proposers electing to obtain a non-electronic paper document will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street, 6th Floor; obtain receipt and present it to the Supply Management Procurement Group; RFQ package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order or Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street, 6th Floor; obtain receipt and present it to 6th Floor, Supply Management Department. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Http://www.nyc.gov/nychabusiness; Select Selling to NYCHA. Vendors are instructed to access the Getting Started: Register or Log-in link. If you have supplied goods or services to NYCHA in the past and you have your log-in credentials, click Returning iSupplier users, Log-in here. If you do not have your log-in credentials, select Click here to Request a Log-in ID. Upon access, select Sourcing Supplier then Sourcing Homepage, conduct a search for applicable RFQ number. Proposers electing to obtain a non-electronic paper document will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street, 6th Floor; obtain receipt and present it to the Supply Management Procurement Group; RFQ package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order or Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street, 6th Floor; obtain receipt and present it to 6th Floor, Supply Management Department. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department,90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Procurement Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department,90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Procurement Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department,90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Procurement Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department, 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request. \n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department, 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Doing Business With NYCHA. \n",
"---\n",
"\n",
"<class 'str'> Http://www.nyc.gov/html/nycha/html/business/business.shtml ;Vendors are instructed to access the “Register Here” link for “New Vendors”; if you have supplied goods or services to NYCHA in the past and you have your log-in credentials, click the “Log into iSupplier” link under “Existing Vendor”. If you do not have your log-in credentials, click the “Request a Log-in ID” using the link under “Existing Vendor”. Upon access, reference applicable RFQ number per solicitation.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ General Services Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Doing Business With NYCHA. \n",
"---\n",
"\n",
"<class 'str'> Http://www.nyc.gov/html/nycha/html/business/business.shtml ;Vendors are instructed to access the “Register Here” link for “New Vendors”; if you have supplied goods or services to NYCHA in the past and you have your log-in credentials, click the “Log into iSupplier” link under “Existing Vendor”. If you do not have your log-in credentials, click the “Request a Log-in ID” using the link under “Existing Vendor”. Upon access, reference applicable RFQ number per solicitation.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ General Services Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one signed original and five copies of its Proposal package. In addition to the paper copies of the Proposal, Proposers shall submit one complete and exact copy of the Proposal electronically by submitting it through NYCHA’s Advance Procurement I Supplier System. The original signed hard-copy must be clearly labeled as such. If there are any differences between the original and any of the copies (or the electronic copy of the Proposal), the material in the hard copy original will prevail.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one (1) signed original and five (5) copies of its Proposal package. The original must be clearly labeled. If there are any differences between the original and any of the copies, the material in the signed original will prevail.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department @ 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Each Proposer is required to submit one (1) signed original and five (5) copies of its Proposal package. In addition to the paper copies of the Proposal, Proposers shall submit one (1) complete and exact copy of the Proposal electronically by submitting it through NYCHA’s Advance Procurement I Supplier System. The original signed hard-copy must be clearly labeled as such. If there are any differences between the original and any of the copies (or the electronic copy of the Proposal), the material in the hard copy original will prevail.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department,90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department,90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Procurement Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Please ensure that bid response includes documentation as required and attached/included in electronic bid proposal submittal. Failure to comply will result in your bid being deemed non-responsive.\n",
"---\n",
"\n",
"<class 'str'> Interested firms may obtain a copy and submit it on NYCHA`s website: Http://www.nyc.gov/html/nycha/html/business/business.shtml ; Vendors are instructed to access “Doing Business With NYCHA”; then click- “Selling Goods and Services to NYCHA” link; then click on “Getting Started” to create a log-in utilizing log-in credentials: “New User, Request Log-In ID or Returning iSupplier User”. Upon access, reference applicable RFQ/Pin number per solicitation. \n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department, 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/ Supply Management Department Procurement Group. A bid package will be generated at time of request. \n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department, 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/Supply Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'str'> Vendors electing to submit a non-electronic bid (paper document) will be subject to a $25 non-refundable fee; payable to NYCHA by USPS-Money Order/ Certified Check or Cash only for each set of RFQ documents requested. Remit payment to NYCHA Finance Department, 90 Church Street/6th Floor; obtain receipt and present it to 6th Floor/Supply Management Procurement Group. A bid package will be generated at time of request.\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Contract is subject to all provisions as may be required by Federal, State and Local Statutes, Rules and Regulations.\n",
"---\n",
"\n",
"<class 'str'> This procurement is subject to participation goals for MBEs and/or WBEs as required by Local Law 1 of 2013. \n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Contract is subject to all provisions as may be required by Federal, State and Local Statutes, Rules and Regulations.\n",
"---\n",
"\n",
"<class 'str'> This procurement is subject to participation goals for MBEs and/or WBEs as required by Local Law 1 of 2013. \n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Contract is subject to all provisions as may be required by Federal, State and Local Statutes, Rules and Regulations.\n",
"---\n",
"\n",
"<class 'str'> This procurement is subject to participation goals for MBEs and/or WBEs as required by Local Law 1 of 2013. \n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> This contract is subject to all provisions as may be required by Federal, State and Local Statutes, Rules and Regulations.\n",
"---\n",
"\n",
"<class 'str'> Download from City Record free of charge or obtain paper documents for a Non-refundable convenience fee of $25.00 per bid package, payable at time of pick-up. Acceptable forms of payment are money order, teller’s check or certified bank check only. Sale hours are Monday through Friday, excluding City Holidays, between 9 AM and Noon, and between 2 PM and 4 PM.\n",
"---\n",
"\n",
"<class 'str'> A Pre-Bid conference is scheduled for Tuesday, October 7, 2014 at 11 AM at HPD, 100 Gold Street, New York, NY 10038, 6th Floor, Room 6-S. Attendance is not mandatory, but is HIGHLY RECOMMENDED.\n",
"---\n",
"\n",
"<class 'str'> Other Legally Mandated Information: \n",
"---\n",
"\n",
"<class 'str'> People with disabilities requiring special accommodations to pick up solicitation documents are advised to call Diane Faulkner at 212-863-7078/7723, so that necessary arrangements can be made.\n",
"---\n",
"\n",
"<class 'str'> Contract is subject to all provisions as may be required by Federal, State and Local Statutes, Rules and Regulations. \n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> Bhuvana Ramamoorthi\n",
"---\n",
"\n",
"<class 'str'> HRA/Management Information Systems \n",
"---\n",
"\n",
"<class 'str'> 15 Metrotech Center 12th Floor \n",
"---\n",
"\n",
"<class 'str'> Brooklyn, NY 11201\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> In addition, a non-mandatory pre-bid conference will be held on Thursday, October 30, 2014 at 11:00 a.m. at 180 Water Street, 7th Floor Conference Room, New York, NY 10038. Attendance is strongly recommended.\n",
"---\n",
"\n",
"<class 'str'> A non-mandatory pre-bid conference will be held on Tuesday, January 6, 2015 at 11:00 a.m. at 180 Water Street, 7th Floor Conference Room, New York, NY 10038. ATTENDANCE IS STRONGLY RECOMMENDED.\n",
"---\n",
"\n",
"<class 'str'> EPIN: 09614B0016\n",
"---\n",
"\n",
"<class 'float'> nan\n",
"---\n",
"\n",
"<class 'str'> A pre-proposal meeting is scheduled for 2:00 pm, December 16, 2014 at the Olmsted Center, Bid Room, Flushing Meadows Corona Park, Flushing, NY 11368\n",
"---\n",
"\n",
"<class 'str'> Bid documents are available for a fee of $100.00 in the Blueprint Room, Room #64, Olmsted Center, from 8:00 AM to 3:00 PM. The fee is payable by company check or money order to the City of NY, Parks and Recreation. A separate check/money order is required for each project. The Company name, address and telephone number as well as the project contract number must appear on the check/money order. Bidders should ensure that the correct company name, address, telephone and fax numbers are submitted by your company/messenger service when picking up bid documents.\n",
"---\n",
"\n",
"<class 'str'> Bid documents are available for a fee of $25.00 in the Blueprint Room, Room #64, Olmsted Center, from 8:00 AM to 3:00 PM. The fee is payable by company check or money order to the City of NY, Parks and Recreation. A separate check/money order is required for each project. The Company name, address and telephone number as well as the project contract number must appear on the check/money order. Bidders should ensure that the correct company name, address, telephone and fax numbers are submitted by your company/messenger service when picking up bid documents.\n",
"---\n",
"\n",
"<class 'str'> Bid documents are available for a fee of $100.00 in the Blueprint Room, Room #64, Olmsted Center, from 8:00 AM to 3:00 PM. The fee is payable by company check or money order to the City of NY, Parks and Recreation. A separate check/money order is required for each project. The Company name, address and telephone number as well as the project contract number must appear on the check/money order. Bidders should ensure that the correct company name, address, telephone and fax numbers are submitted by your company/messenger service when picking up bid documents.\n",
"---\n",
"\n",
"<class 'str'> Bid documents are available for a fee of $25.00 in the Blueprint Room, Room #64, Olmsted Center, from 8:00 AM to 3:00 PM. The fee is payable by company check or money order to the City of NY, Parks and Recreation. A separate check/money order is required for each project. The Company name, address and telephone number as well as the project contract number must appear on the check/money order. Bidders should ensure that the correct company name, address, telephone and fax numbers are submitted by your company/messenger service when picking up bid documents.\n",
"---\n",
"\n",
"<class 'str'> Bid documents are available for a fee of $25.00 in the Blueprint Room, Room #64, Olmsted Center, from 8:00 AM to 3:00 PM. The fee is payable by company check or money order to the City of NY, Parks and Recreation. A separate check/money order is required for each project. The Company name, address and telephone number as well as the project contract number must appear on the check/money order. Bidders should ensure that the correct company name, address, telephone and fax numbers are submitted by your company/messenger service when picking up bid documents.\n",
"---\n",
"\n",
"<class 'str'> Bid documents are available for a fee of $25.00 in the Blueprint Room, Room #64, Olmsted Center, from 8:00 AM to 3:00 PM. The fee is payable by company check or money order to the City of NY, Parks and Recreation. A separate check/money order is required for each project. The Company name, address and telephone number as well as the project contract number must appear on the check/money order. Bidders should ensure that the correct company name, address, telephone and fax numbers are submitted by your company/messenger service when picking up bid documents.\n",
"---\n",
"\n",
"<class 'str'> VSID 87613\n",
"---\n",
"\n",
"<class 'str'> VSID#: 87409\n",
"---\n",
"\n",
"<class 'str'> VSID#:87467\n",
"---\n",
"\n"
]
}
],
"source": [
"for row in r1['RequestID'].values:\n",
" if isinstance(row, str) and row.startswith('2014'):\n",
" continue\n",
" print (type(row), row)\n",
" print ('---\\n')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.4.3"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment