When to Use Area Charts: Making the Most of Visualizing Trends Over Time
Learn when to choose an area chart and how to make it tell your data's story effectively.
Python Editor
Write your own Python Code
Use our custom editor with syntax highlighting. To output the results just use the print() function.
Output in spreadsheet
Output directly to the spreadsheet
Select a cell and click Pick Output Cell to print the results in a specific cell. You can manually enter the cell name if you want.
Print results
Print results into the spreadsheet
Click Run in Sheet to put the results in the spreadsheet.
Propagate results
Propagate the result in multiple cells
If the result is a list or a list of lists it will propagate through several cells.
Input Data
Use data directly from your spreadsheet
Select a cell or a range and click Pick Input Cell to get the data in the Python editor. You can manually enter the cell range if you want. The data will be stored in a variable called input_data.
Debug in Console
Use the Console for debugging
Use the console for debugging and quick testing. You can iterate before interacting with the spreadsheet.
Learn Data Transformation and Visualization
View all posts »This is your go-to guide for understanding data and data visualization. Each article will help you build your knowledge, making complex concepts simple and clear. Whether you’re just getting started or looking to improve your skills, you’ll find practical tips and tutorials to help you become confident in working with data visualizing it effectively.
Choosing the Right Data Visualization
You’ll learn practical tips to select the right visual to enhance your data story.
Mastering Data Storytelling: Techniques to Bring Your Data to Life
We'll explore the art of data storytelling, focusing on how to craft compelling stories that resonate with your audience using data.
Sankey Charts: How to Tell a Flowing Story with Your Data
We’ll explore the power of Sankey charts, a unique type of data visualization designed to display flows or transfers between categories. Learn how to use Sankey charts to tell a compelling story by visualizing the movement of data.