Comments (2)
Just to expand a bit, this is specific to group_by_dynamic
and the problem is index_column
being duplicated.
(lf.group_by_dynamic("time", every="1h", closed="right")
.last()
.collect()
)
# DuplicateError: column with name 'time' has more than one occurrences
pl.all()
in this case includes the index_column
(which differs to how .group_by()
and by=
behaves)
(lf.group_by_dynamic("time", every="1h", closed="right")
.agg(pl.all().last())
.collect()
)
# DuplicateError: column with name 'time' has more than one occurrences
In this case index_column
needs to be excluded.
(lf.group_by_dynamic("time", every="1h", closed="right")
.agg(pl.exclude("time").last())
.collect()
)
# shape: (4, 3)
# ┌─────────────────────┬─────┬─────┐
# │ time ┆ n ┆ m │
# │ --- ┆ --- ┆ --- │
# │ datetime[μs] ┆ i64 ┆ i64 │
# ╞═════════════════════╪═════╪═════╡
# │ 2021-12-15 23:00:00 ┆ 0 ┆ 0 │
# │ 2021-12-16 00:00:00 ┆ 2 ┆ 2 │
# │ 2021-12-16 01:00:00 ┆ 4 ┆ 4 │
# │ 2021-12-16 02:00:00 ┆ 6 ┆ 6 │
# └─────────────────────┴─────┴─────┘
(I'm not entirely sure if these GroupBy.foo()
shorthand methods are supposed to be allowed for group_by_dynamic
)
from polars.
Thanks for that. The type is polars.lazyframe.group_by.LazyGroupBy
so I assumed it should work (according to the docs). It would help if e.g. your example would be part of the docs to help understand where the DuplicateError
comes from.
from polars.
Related Issues (20)
- Add a `newline` parameter to `read_csv` HOT 3
- `sort_by` + `struct` + `exclude` index out of bounds PanicException HOT 1
- CSV Downloads Fail for ADLS Gen2 with Azure CLI Authentication HOT 3
- Panic on datetime column min() HOT 1
- High memory usage after `collect()` despite using `limit(1)`
- Conda package outdated HOT 1
- DateFrame.describe() reports datetime as str HOT 2
- pl.list,len() - pl.list,len() always returning u32 no matter the results HOT 3
- [FEA]: Allow specifying null location in `set_sorted`
- Expose the individual parameters from fastexcel.load_sheet in pl.read_excel HOT 1
- Provide native and fast Series slice assignment (currently slower than Pandas) HOT 6
- Supporting multidimensional array style operations, by specifying metadata columns
- struct field access returns incorrect values HOT 3
- pl.struct with no arguments triggers a panic
- Multiple expr.head(n).max()/min()/etc operations in with_columns causing ShapeError
- Add `repeat` and `tile` for Series/Expr
- `SchemaFieldNotFoundError` when chaining `select` and `collect`
- Series is ignoring the dtype argument, series.to_numpy() dtype depends on values passed
- Problem filtering categorical string columns with lazy frame and scan_parquet HOT 1
- PanicException: validity must be equal to the array's length
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from polars.