SQLiteAPI.py 文件源码

def GetRepsAtEachConcentration(self, analyte_table_lst, data_set):
        df = pd.DataFrame()
        for table in analyte_table_lst:
            sql_statement = "SELECT \
                                %s.Concentration_pg AS Conc, COUNT(%s.Concentration_pg) AS %s \
                            FROM \
                                Sample \
                            Inner Join %s ON \
                                %s.id = Sample.%s_foreignkey \
                            WHERE \
                                DataSetName = '%s' \
                            GROUP BY 1 \
                            ORDER BY 1 ASC;" % (table, table, table, table, table, table, data_set)
            df1 = pd.read_sql_query(sql_statement, self.conn)
            df1.set_index('Conc', inplace=True)

            df = pd.concat([df, df1], axis=1)

        return df