old_contents: # -*- coding:utf-8 -*-
  import time
  from crawler import SecCrawler
  
  
  def test():
  	t1 = time.time()
  	# file containig company name and corresponding cik codes
  	seccrawler = SecCrawler()
  
  	companyCodeList = list()    # company code list
  	cikList = list()	        # cik code list
  	dateList = list()           # pror date list
  	countList = list()
  
  	try:
  		crs = open("data.txt", "r")
  	except:
  		print "No input file Found"
  
  	# get the comapny  quotes and cik number from the file.
  	for columns in ( raw.strip().split() for raw in crs ):
  	    companyCodeList.append(columns[0])
  	    cikList.append(columns[1])
  	    dateList.append(columns[2])
  	    countList.append(columns[3])
  
  	del cikList[0]; del companyCodeList[0]; del dateList[0]
  
  	for i in range(len(cikList)):
  		seccrawler.filing_10Q(str(companyCodeList[i]), str(cikList[i]), str(dateList[i]), str(countList[i]))
  		seccrawler.filing_10K(str(companyCodeList[i]), str(cikList[i]), str(dateList[i]), str(countList[i]))
  		seccrawler.filing_8K(str(companyCodeList[i]), str(cikList[i]), str(dateList[i]), str(countList[i]))
  
  	t2 = time.time()
  	print "Total Time taken: ",
  	print (t2-t1)
  	crs.close()
  
  if __name__ == '__main__':
  	test()
new_contents: # -*- coding:utf-8 -*-
  import time
  from crawler import SecCrawler
  
  
  def test():
      t1 = time.time()
      # file containig company name and corresponding cik codes
      seccrawler = SecCrawler()
  
      company_code_list = list()   # company code list
      cik_list = list()            # cik code list
      date_list = list()           # pror date list
      count_list = list()
  
      try:
          crs = open("data.txt", "r")
      except:
          print "No input file Found"
  
      # get the comapny  quotes and cik number from the file.
      for columns in (raw.strip().split() for raw in crs):
          company_code_list.append(columns[0])
          cik_list.append(columns[1])
          date_list.append(columns[2])
          count_list.append(columns[3])
  
      # call different  API from the crawler
      for i in range(1, len(cik_list)):
          seccrawler.filing_10Q(str(company_code_list[i]), str(cik_list[i]),
              str(date_list[i]), str(count_list[i]))
          seccrawler.filing_10K(str(company_code_list[i]), str(cik_list[i]),
              str(date_list[i]), str(count_list[i]))
          seccrawler.filing_8K(str(company_code_list[i]), str(cik_list[i]),
              str(date_list[i]), str(count_list[i]))
  
      t2 = time.time()
      print "Total Time taken: ",
      print (t2 - t1)
      crs.close()
  
  if __name__ == '__main__':
      test()
  
subject: remove row del code