kailo_beewell_dashboard.import_data

Helper function for importing the data from TiDB Cloud

Module Contents

Functions

get_df(query, conn)	Get data from the connected SQL database
import_tidb_data(survey_type)	Imports all the datasets from TiDB Cloud, fixes any data type issues, and

kailo_beewell_dashboard.import_data.get_df(query, conn)

Get data from the connected SQL database

Parameters:

querystring

SQL query

connconnection object

Connection to the SQL database

Returns:

dfpandas DataFrame

Dataframe produced from the query

kailo_beewell_dashboard.import_data.import_tidb_data(survey_type)

Imports all the datasets from TiDB Cloud, fixes any data type issues, and saves the datasets to the session state.

Parameters

survey_typestring

Designates whether to import for ‘standard’ or ‘symbol’ survey