src.serena.utilities.logging_serena

pandas baesd log reporting

 1"""
 2pandas baesd log reporting
 3"""
 4
 5from typing import List
 6import pandas as pd
 7from pandas import DataFrame
 8import os
 9
10class PNASAnalysisLogging():
11
12    def __init__(self) -> None:
13        pass
14
15    def open_sublab_from_excel(self,path:str, sheet_name:str, sublab:str):
16        sheet:DataFrame = pd.read_excel(path, sheet_name=sheet_name)
17        sublab_sheet:DataFrame = sheet
18        if sublab != "":
19            sublab_sheet:DataFrame  = sheet[sheet['Puzzle_Name'] == sublab]
20        return sublab_sheet
21    
22    def save_excel_sheet(self, df:DataFrame, excel_path:str, sheet_name:str):
23        if not os.path.exists(excel_path):
24            df.to_excel(excel_path, sheet_name=sheet_name, index=False)
25        else:
26            with pd.ExcelWriter(excel_path, engine='openpyxl', if_sheet_exists='overlay', mode='a') as writer:
27                df.to_excel(writer, sheet_name=sheet_name, startrow=writer.sheets[sheet_name].max_row, header=None, index=False)
28
29    def save_dataframe_to_excel(self, src_dataframe:DataFrame, dst_path:str, dst_sheet_name:str):
30        with pd.ExcelWriter(dst_path) as writer:
31            src_dataframe.to_excel(writer, sheet_name=dst_sheet_name)
32
33    def add_new_named_collumn(self,src_datafrm:DataFrame, column_name:str, column_list:List[str]):
34        src_datafrm[column_name]=column_list
35        return src_datafrm
class PNASAnalysisLogging: 
11class PNASAnalysisLogging():
12
13    def __init__(self) -> None:
14        pass
15
16    def open_sublab_from_excel(self,path:str, sheet_name:str, sublab:str):
17        sheet:DataFrame = pd.read_excel(path, sheet_name=sheet_name)
18        sublab_sheet:DataFrame = sheet
19        if sublab != "":
20            sublab_sheet:DataFrame  = sheet[sheet['Puzzle_Name'] == sublab]
21        return sublab_sheet
22    
23    def save_excel_sheet(self, df:DataFrame, excel_path:str, sheet_name:str):
24        if not os.path.exists(excel_path):
25            df.to_excel(excel_path, sheet_name=sheet_name, index=False)
26        else:
27            with pd.ExcelWriter(excel_path, engine='openpyxl', if_sheet_exists='overlay', mode='a') as writer:
28                df.to_excel(writer, sheet_name=sheet_name, startrow=writer.sheets[sheet_name].max_row, header=None, index=False)
29
30    def save_dataframe_to_excel(self, src_dataframe:DataFrame, dst_path:str, dst_sheet_name:str):
31        with pd.ExcelWriter(dst_path) as writer:
32            src_dataframe.to_excel(writer, sheet_name=dst_sheet_name)
33
34    def add_new_named_collumn(self,src_datafrm:DataFrame, column_name:str, column_list:List[str]):
35        src_datafrm[column_name]=column_list
36        return src_datafrm
def open_sublab_from_excel(self, path: str, sheet_name: str, sublab: str): 
16    def open_sublab_from_excel(self,path:str, sheet_name:str, sublab:str):
17        sheet:DataFrame = pd.read_excel(path, sheet_name=sheet_name)
18        sublab_sheet:DataFrame = sheet
19        if sublab != "":
20            sublab_sheet:DataFrame  = sheet[sheet['Puzzle_Name'] == sublab]
21        return sublab_sheet
def save_excel_sheet( self, df: pandas.core.frame.DataFrame, excel_path: str, sheet_name: str): 
23    def save_excel_sheet(self, df:DataFrame, excel_path:str, sheet_name:str):
24        if not os.path.exists(excel_path):
25            df.to_excel(excel_path, sheet_name=sheet_name, index=False)
26        else:
27            with pd.ExcelWriter(excel_path, engine='openpyxl', if_sheet_exists='overlay', mode='a') as writer:
28                df.to_excel(writer, sheet_name=sheet_name, startrow=writer.sheets[sheet_name].max_row, header=None, index=False)
def save_dataframe_to_excel( self, src_dataframe: pandas.core.frame.DataFrame, dst_path: str, dst_sheet_name: str): 
30    def save_dataframe_to_excel(self, src_dataframe:DataFrame, dst_path:str, dst_sheet_name:str):
31        with pd.ExcelWriter(dst_path) as writer:
32            src_dataframe.to_excel(writer, sheet_name=dst_sheet_name)
def add_new_named_collumn( self, src_datafrm: pandas.core.frame.DataFrame, column_name: str, column_list: List[str]): 
34    def add_new_named_collumn(self,src_datafrm:DataFrame, column_name:str, column_list:List[str]):
35        src_datafrm[column_name]=column_list
36        return src_datafrm