输出中没有csv文件

wj8zmpe1  于 2021-09-29  发布在  Java
关注(0)|答案(0)|浏览(255)

有人能告诉我为什么这个代码没有生成任何csv文件吗?

  1. import tabula
  2. import pandas as pd
  3. import re
  4. _all_ = ['PdfFileReader', 'tabula', 'read_pdf' 'os', 're', 'csv']
  5. def getdata():
  6. import PyPDF2
  7. # open the pdf file
  8. object = PyPDF2.PdfFileReader("C:/Users/Manav Trivedi/Downloads/1-800-FLOWERS.COM, Inc._Annual Report_2017_EN.pdf")
  9. # get number of pages
  10. NumPages = object.getNumPages()
  11. for i in range(0, NumPages):
  12. df1 = {'Total Assets': [], 'Total Liabilities': [], 'Current Assets': [], 'Current Liabilities': []}
  13. df2 = {'Revenue': [], 'Net Income': [], 'Gross Profit': [], 'Net Profit': []}
  14. tables = tabula.read_pdf("C:/Users/Manav Trivedi/Downloads/1-800-FLOWERS.COM, Inc._Annual Report_2017_EN.pdf", encoding='utf-8', pages="all")
  15. for table in tables:
  16. if re.search("Total Assets", str(table)) or re.search("Total Liabilities", str(table)) or re.search("Current Assets",str(table)) or re.search("Current Liabilities", str(table)):
  17. strg = str(table)
  18. strg = strg.split(',')
  19. for j in (0,strg):
  20. if(j=='Total Assets'):
  21. df1[0].extend(j+1)
  22. if(j=='Total Liabilities'):
  23. df1[1].extend(j+1)
  24. if(j=='Current Assets'):
  25. df1[2].extend(j+1)
  26. if(j=='Current Liabilities'):
  27. df1[3].extend(j+1)
  28. df1 = pd.DataFrame.from_dict(df1)
  29. df1.to_csv('Balance-sheet.csv', encoding='utf-8')
  30. if re.search("Revenue", str(table)) or re.search("Net Income", str(table)) or re.search("Gross Profit",str(table)) or re.search("Net Profit", str(table)):
  31. strg = str(table)
  32. strg = strg.split(',')
  33. for j in (0,strg):
  34. if(j=='Revenue'):
  35. df2[0].extend(j+1)
  36. if(j=='Net Income'):
  37. df2[1].extend(j+1)
  38. if(j=='Gross Profit'):
  39. df2[2].extend(j+1)
  40. if(j=='Net Profit'):
  41. df2[3].extend(j+1)
  42. df2 = pd.DataFrame.from_dict(df2)
  43. df2.to_csv('Income-Statement.csv', encoding='utf-8')
  44. if __name__ == '__main__':
  45. getdata()

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题