parquet - Im using polars library, but I'm getting 'NameError: name 'PyLazyFrame' is not defined

Im trying to get data from a parquet file using SQL syntax.

The code:

import polars as pl

# Ensure the variables are defined
parquet_file = r'C:\Users\Kperez\Documents\md_curated_20250115.parquet'
date = "2024-12-13"

df3 = pl.read_parquet(parquet_file)

# Register the DataFrame as a table and execute the SQL query
ctx = pl.SQLContext()
ctx.register("data", df3)
result = ctx.execute(f"SELECT Identifier, IQ_CLOSEPRICE FROM data where Date = '{date}'").collect()
print(result)

But I got an error like this:

NameError: name 'PyLazyFrame' is not defined

View:

Any ideas?

Im trying to get data from a parquet file using SQL syntax.

The code:

import polars as pl

# Ensure the variables are defined
parquet_file = r'C:\Users\Kperez\Documents\md_curated_20250115.parquet'
date = "2024-12-13"

df3 = pl.read_parquet(parquet_file)

# Register the DataFrame as a table and execute the SQL query
ctx = pl.SQLContext()
ctx.register("data", df3)
result = ctx.execute(f"SELECT Identifier, IQ_CLOSEPRICE FROM data where Date = '{date}'").collect()
print(result)

But I got an error like this:

NameError: name 'PyLazyFrame' is not defined

View:

Any ideas?

• python
• parquet
• python-polars
• python-3.9
• polars

Share Improve this question Follow edited Jan 30 at 19:07 jqurious 22.2k55 gold badges2020 silver badges3939 bronze badges asked Jan 30 at 19:05 qarly_blueqarly_blue 42044 silver badges88 bronze badges 1

• 1 I used 'pip install polars' but the problem was the python version. Thank you! – qarly_blue Commented Jan 30 at 19:47

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 1

The problem was Python version

Polars doesn't work with Python 3.9, when I changed to Python 3.13 (latest at this moment) my code was executed successfully:

View:

The latest version of polars i.e. 1.21.0 actually supports Python 3.9 - 3.13 and has wheels for Python 3.9+ on all major platforms.

This seems to be an issue with your Windows OS and specific polars version. As was quoted in the linked issue:

This error message only appears on Windows 7 systems. It works fine on Windows 11 systems. Based on my testing, installing a version higher than 0.20.16 on Windows 7 results in this error, while installing version 0.20.16 works correctly.