Best Claude prompts for Mathematicians

Given a dataset of 10 million records, with 20 columns and a complex query that involves multiple joins and subqueries, write a Python script using the Pandas library to optimize the query performance by reducing the number of joins and subqueries, and then visualize the results using Tableau to identify any bottlenecks or areas for further optimization. Assume the dataset is stored in a Snowflake database and the query is currently taking over an hour to run. Provide a step-by-step breakdown of the optimization process and the resulting performance gain.

Suppose we have a regression model with 10 predictors and a response variable, and we want to select the best subset of predictors to include in the model. Using R, write a script that implements a backward elimination procedure to select the optimal subset of predictors, and then compares the performance of the resulting model to a model with all 10 predictors using metrics such as mean squared error and R-squared. Provide a detailed analysis of the results, including any insights into the relationships between the predictors and the response variable.

Given a large dataset with missing values, outliers, and inconsistent formatting, write a SQL script to identify and document the data quality issues, including the number and percentage of missing values, the distribution of outliers, and any inconsistencies in formatting. Then, using Python, write a data cleaning script to address these issues, including imputing missing values, removing outliers, and standardizing formatting. Finally, provide a summary report of the data quality issues and the steps taken to address them, including any visualizations or metrics that illustrate the improvement in data quality.

Design and implement an ETL pipeline using Python and the Pandas library to extract data from a relational database, transform the data into a standardized format, and load the data into a data warehouse. Assume the pipeline must handle multiple data sources, including CSV files, JSON files, and database tables, and that the data must be transformed to conform to a specific schema. Provide a detailed diagram of the pipeline architecture, including any data flows, transformations, and loading processes, as well as a discussion of any potential issues or bottlenecks and how they can be addressed.