Additionally, we can truncate any customer names that get too long.
Our Success team is only assigned to certain segments like Enterprise (ENT), so we filter for those here. We’ll use pandas to quickly sort, transform, and clean the data. Instead, after doing a generic SQL query, we can handle the transformation and filtering in pandas. But if your reports need to be customized to each user, generating user-specific SQL queries can get annoying fast. Getting the base-level data using SQL is always a great first step, and with Retool, you can use your existing SQL resources to quickly query your database. First, let’s start with writing the base query to our dataset: in this case, our table is called fct_sfdc_account_health. Say we want to create a weekly report for our Customer Success team, tracking their healthiest and least healthy accounts.
CODEBLOCKS WONT BUILD CODE
Now, I can swap between JavaScript and Python any time I want to use code blocks in Workflows, meaning I can reach for the right tool for the job at each step in any automation process. Applying normalization to a multi-dimensional dataset feels needlessly complex in JavaScript when, in Python, I could simply call np.linalg.norm. We’ve preinstalled 20 libraries and packages-like numpy, pandas, scipy, and plotting libraries like seaborn-so that you don't lose access to the powerful packages you’re used to writing within your IDE or notebook.Ī more powerful toolkit for ETL and reportingĪs someone who does a fair bit of analytics work, there are times I find myself wanting to reach for something other than JavaScript or SQL when building in Workflows.
Don’t worry about importing your favorite libraries, either. When writing Python in Workflows, you automatically get auto-completion, context, and linting. Just drag a block out onto the canvas, select “Code”, and then select the Python tab to start writing. Now, when running code blocks, you can select either JavaScript or Python as your language. (GitHub’s State of the Octoverse ranks it the second most popular programming language used in 2022, behind JavaScript.) And for good reason-Python comes with a rich library ecosystem, which you can now leverage when building automation projects in Workflows.
CODEBLOCKS WONT BUILD SOFTWARE
How it worksĪ lot of software today is written in Python. So we’re doing just that, starting with Python support in Workflows. We want Retool to be the fastest way for your team to build, maintain, and extend business software. We heard from customers that building business software is a collaborative effort, and support for the languages that their teams already use helps them build apps faster. Every Retool plan includes 1GB/month of Workflows data for free. Now, you can run Python code blocks as steps in your automations to more elegantly ingest, analyze, and visualize data-with preinstalled dev tools like autocomplete, linting, and 20+ libraries (like numpy and pandas). Additionally, the auto-completion feature wasn't always reliable and would sometimes cause more confusion than assistance.Today, we’re introducing support for Python in Retool Workflows. The debugging feature wasn't as robust as other IDEs I've used, so it took a bit more effort to track down and fix errors in my code. One of the things I liked least about Code::Blocks was that it sometimes had issues with debugging. Additionally, its ability to handle large projects made it perfect for my assignments and final projects. I also appreciated that it supported multiple compilers, which allowed me to work with different programming languages (mostly when I was working with C and C++ in my first-year courses). It had a user-friendly interface and was easy to navigate. PROSĪs a college student studying computer science, I found that Code::Blocks was a great tool for my programming projects. Overall, it was a good tool for my college projects and assignments, but I found some other IDEs had better debugging and auto-completion features. However, it had some limitations with debugging and the auto-completion feature was not always reliable. It had a good interface and was easy to navigate. As a student pursuing a degree in CS at the college level, I found Code::Blocks to be a useful and user-friendly IDE for my programming projects.
0 kommentar(er)
