Quadratic Docs
  • Getting started
  • Examples
  • Open Quadratic
  • Quadratic AI
    • Getting started
    • Generate code
    • Generate data
    • Import PDFs
    • Import images
    • Security
  • Connections
    • SQL - getting started
    • PostgreSQL
    • MySQL
    • MS SQL Server
    • Parametrize queries
    • SQL AI assistant
    • Security
    • API requests
    • Request a connection
  • Python
    • Getting started
    • Reference cells
    • Return data to the sheet
    • Packages
    • Make an API request
    • Clean data
    • Charts/visualizations
    • Manipulate data
  • Javascript
    • Getting started
    • Reference cells
    • Return data to the sheet
    • API Requests
    • Charts/visualizations
    • Packages
  • Formulas
    • Getting started
    • AI assistant
    • Reference cells
    • Functions and operators
    • Arrays
    • Criteria
    • Wildcards
  • Spreadsheet
    • Navigating
    • Files
    • Shortcuts
    • Insert/delete rows and columns
    • Data validation
    • Present & share
    • Date-time formatting
    • Browser compatibility
  • Teams
    • Manage your team
    • Private files
    • Collaboration
    • Embedded sheets
  • Import data
    • SQL connections
    • API requests
    • Drag and drop .CSV
    • Drag and drop .Parquet
    • Import Excel files
  • Self hosting
    • Getting started
    • Docker
    • AWS
    • Azure
    • Google Cloud Platform
    • Bring your own AI
    • Other hosting
  • Quadratic for Education
    • Overview
    • Enrolling in the education plan
    • Teachers
    • Students
    • Researchers
    • Education FAQ
  • Company
    • About
    • Quadratic is source available
    • Brand assets
  • GitHub
  • Blog
  • Twitter
  • Discord
Powered by GitBook
On this page
  • Quick start
  • Learn more

Was this helpful?

  1. Python

Getting started

Get started writing rich Python code inside the spreadsheet.

PreviousRequest a connectionNextReference cells

Last updated 5 months ago

Was this helpful?

Python is a first-class citizen in Quadratic that integrates seamlessly with the spreadsheet. Below is a quick start to get going with Python in Quadratic.

Quick start

  1. Select the cell where you want to write Python code.

  1. Press / to bring up the cell type menu. Select Python.

  1. Write Python in the code editor. The last line of code is returned to the sheet at the cell position.

Learn more

The following is a list of essential information for learning how Python works in Quadratic.

- get data from the sheet into Python with cell references

- return Python outputs from code to the sheet

- import packages for use in your Python code

- use the Requests library to query APIs

- turn your data into beautiful charts and graphs with Plotly

The most common starting point is

Reference cells
Return data to the sheet
Import packages
Make API requests
Visualize data
learning how to reference spreadsheet cells from Python in Quadratic.

Learn how to: Reference cells in the sheet from Python

Learn how to: Display data in the sheet from Python

Learn how to: Ingest data using Python

Learn how to: Visualize data using Python

Learn how to: Use Python packages in Quadratic

Learn how to: Clean data using Python

Learn how to: Manipulate data using Python

๐Ÿ‘‰
๐Ÿ“ฅ
๐Ÿ“ˆ
๐Ÿ“Š
๐Ÿ“ฆ
๐Ÿงน
๐ŸŽฅ