how can i get the following in python? SQL connection to our SQLite database

conn $=$ sqlite$3.$connect$($memory$.$db$)$

create a variable to store SQL command

Execute SQL command using Pandas read sql function and store into variable

Additional SQL queries written and executed here if you need multiple pieces of data to answer this testable question. Check for data quality issues

Fix data quality issues if needed

Multivariate graphical and non$-$graphical EDA here to answer testable question give me the previous in python that i can use to answer the question $($Which top $5$ product categories have increased the most in sales year$-$over$-$year?$)$ The dataset given to me is in the following

olist$\_$customers$\_$dataset.csv $($includes customer$\_$id$,$ customer$\_$unique$\_$id$,$ customer$\_$zip$\_$code$\_$prefix, customer$\_$city, and customer$\_$state$)$

olist$\_$geolocation$\_$dataset.csv $($includes geolocation$\_$zip$\_$code$\_$prefix, geolocation$\_$lat, geolocation$\_$lng$,$ geolocation$\_$city, and geolocation$\_$state$)$

olist$\_$order$\_$items$\_$dataset.csv $($includes order$\_$id$,$ order$\_$item$\_$id$,$ product$\_$id$,$ seller$\_$id$,$ shipping$\_$limit$\_$date, and price, freight$\_$value$)$

olist$\_$order$\_$payments$\_$dataset.csv $($includes order$\_$id$,$ payment$\_$sequential, payment$\_$type, payment$\_$intallments, and payment$\_$value$)$

olist$\_$order$\_$reviews$\_$dataset.csv $($includes review$\_$id$,$ order$\_$id$,$ review$\_$score, review$\_$comment$\_$title, review$\_$comment$\_$message, review$\_$creation$\_$date, and review$\_$answer$\_$timestamp$)$

olist$\_$orders$\_$dataset.csv $($includes order$\_$id$,$ customer$\_$id$,$ order$\_$status, order$\_$purchase$\_$timestamp, order$\_$approved$\_$at$,$ order$\_$delivered$\_$carrier$\_$date, order$\_$delivered$\_$customer$\_$date, and order$\_$estimated$\_$deliver$\_$date$)$

olist$\_$products$\_$dataset.csv $($includes product$\_$id$,$ product$\_$category$\_$name, product$\_$name$\_$length, product$\_$description$\_$length, product$\_$photos$\_$qty$,$ product$\_$weight$\_$g$,$ product$\_$length$\_$cm$,$ product$\_$height$\_$cm$,$ and product$\_$width$\_$cm

olist$\_$sellers$\_$dataset.csv $($includes seller$\_$id$,$ seller$\_$zip$\_$code$\_$prefix, seller$\_$city, and seller$\_$state$)$

product$\_$category$\_$name$\_$translation.csv $($includes product$\_$category$\_$name and product$\_$category$\_$name$\_$english$)$