Question: Are there any tools that can help me automate repetitive tasks in data science without requiring extensive Python programming knowledge?

Mito is a Python automation tool that lets you generate Python code from changes to a spreadsheet, using an interface you're already familiar with. It can be used to automate data transformation, visualization and pivot tables without having to know much about Python. It works well with Jupyter, Streamlit and Dash environments and can generate code with AI assistance, so it's a good option for data scientists.

Another good option is Morph, an AI data assistant that makes data accessible and usable for everyone involved. It can ingest data from many sources, process it and export the results without any programming. Morph can be used for querying, visualization and reporting, and it can connect to several SQL databases like Snowflake, BigQuery and MySQL. It's good for automating complex data processing and making business decisions.

If you spend a lot of time in Excel or Google Sheets, ManyExcel offers an AI tool to generate formulas, regex patterns and scripts. It can turn plain text into complex formulas and regular expressions, and even generate VBA scripts for Excel and Apps Scripts for Google Workspace. It can be a big boost to productivity by automating mundane tasks in the spreadsheet.