Untitled
pandas excel as an objectcalendula
plain_text
4 years ago
1.6 kB
11
Indexable
import pandas as pd
class Table:
def __init__(self):
"self.workbook = "Airport.xlsx"
self.table = []
self.info = []
self.data_list_of_sets=[]
self.namedflight=[]
self.x=[]
self.no=0
self.date = "1.4.2022"
self.flight_type='NN'
self.flight_sub_type='NN'
self.flight='NN'
self.destination='NN'
self.ttl_guests=0
self.inf=0
self.transfer=0
self.id00=0
self.dhc=0
self.ttl_pax_for_charge=0
self.registration='NN'
self.ac_type='NN'
self.umnr=0
self.loc=0
def ucitajTabelu(self):
# Read and store contentof an excel file
read_file = pd.read_excel (input('Unesi naziv xlsx tabele: ')) #ovo radi ali da ne bih stalno unosila ime
#bolje je ovo ispod:
#read_file = pd.read_excel ("Airport.xlsx")
# Write the dataframe/df object - called "table"
# into csv file
read_file.to_csv ("Airport.csv",
index = None,
header=True)
# read csv file and convert into a dataframe object
table = pd.DataFrame(pd.read_csv("Airport.csv"))
# show the dataframe
#df
return table
#*********************************
table=Table()
print(table)
table.ucitajTabelu()
"""
print("uneta prva tabela")
table2=Table()
print(table2)
table2.ucitajTabelu()
print("uneta druga tabela")
"""
Editor is loading...