mysql example Printing into excel (snippet)

Python mysql example 'Printing into excel'

Modules used in program:

• import pandas as pd
• import os
• import tabula

python Printing into excel

Python mysql example: Printing into excel

import tabula
import os
from tabula import read_pdf
import pandas as pd
from xlrd import open_workbook
from xutils.copy import copy

#expected_csv = 'C:\Users\abhishek chandel\python program\x.csv'
df =tabula.read_pdf('C:\ghr.pdf', encoding="cp932",pages="all", multiple_tables=True)


Regional_data = df[0]
FREQ = pd.DataFrame(df[1])
PSPS = pd.DataFrame(df[2])
ICTE = pd.DataFrame(df[3])
IER =  pd.DataFrame(df[4])
GEN_OUT = pd.DataFrame(df[5])
SOURCE_GEN = pd.DataFrame(df[6])
#print(PSPS)


#now that we have PSPS we want to improve this file
rb= openwork_book("states_list.xls")
wb = copy(rb)

for x in range (3,42):
 states = PSPS[1][x]
 print(states)
 s= wb.get_sheet(0)
 s.write(0,x, states)

wb.save("states_list.xls")

Python links

• Learn Python: https://pythonbasics.org/
• Python Tutorial: https://pythonprogramminglanguage.com