generate functionThu, 30 Mar 2023

Define the function "KPI" for dataframe grouped by columns "time" and "Volts" (concatenating them using the column name as delimiters) for mean data of columns "NEVs" and "MWht". Call the function "KPI" for the dataframe "global_dataframe" Define the dataframe "RdataFrame" with columns: - "absGap" - "dG1", "dG2", "dG3",etc. With "NVEI" columns. - "Id1","Id2","Id3", etc. With "NNewInd" columns. For the first 2 indexes of "RdataFrame", in the columns "dG1", "dG2", etc. Put the information of the columns: "time" and "Volt" of "gKPI" in Start a loop of 1000 "Sample" in "Samples", per each sample: - Get sub dataframe "SDFrame" componed by 10% of the indexes of "global_dataframe" choosen randomly. Store the list "Indexes" of indexes choosen transposed. - Call "KPI" for "SDFrame" as "sKPI". - Calculate absolute error, "absGap", and detailed error per "Volt" value, "detGap", between "sKPI" and "gKPI". - Store "absGap" and "detGap" in the dataframe "RdataFrame" in columns "aGap", "dG1", "dG2", "dG3",etc. - Store "Indexes" in the dataframe "RdataFrame" in the columns "Id1","Id2","Id3",etc.

def KPI(dataframe): return dataframe.groupby(["Time","Volts"]).mean()[["NEVs","MWht"]] gKPI = KPI(global_dataframe) RdataFrame = pd.DataFrame(columns=["absGap"]+["dG"+str(i) for i in range(1,len(gKPI.index)+1)]+["Id"+str(i) for i in range(1,len(gKPI.index)+1)]) for s in range(0,1000): SDFrame = global_dataframe.sample(frac=0.1) Indexes = SDFrame.index sKPI = KPI(SDFrame) absGap = sum([abs(sKPI[col][i]-gKPI[col][i]) for i in range(0,len(gKPI.index))for col in gKPI.columns]) detGap = [abs(sKPI[col][i]-gKPI[col][i])

Questions about programming?Chat with your personal AI assistant