The invention relates to the technical field of
data processing, in particular to a pandas-based cross-
database query method,
system and device and a medium. The method comprises the following steps: configuring and storing
database connection information, receiving a cross-
database query request, and decomposing the cross-
database query request into sub-query requests; establishing
database connection according to the sub-query and connection information, executing query by using a pandas function, and storing a result as a DataFrame object;
processing the problem that data types and field names are inconsistent, and associating a plurality of DataFrame objects to generate a final result; and outputting the result in a specified format. The
system comprises a configuration module, a request
processing module, a query execution module, a
data integration module and a result output module. According to the method, the efficient
processing capacity of the pandas is utilized, and the query performance is improved; multiple databases are supported, and the development difficulty and cost are reduced; consistency and integrity are guaranteed in
data integration, and data problems are avoided.