Giter VIP home page Giter VIP logo

Comments (2)

l1t1 avatar l1t1 commented on September 26, 2024

if there is no express in group by column, it's ok

>>> df = pl.DataFrame(
...      {
...          "A": [1, 1, 3, 3, 5],
...          "fruits": ["banana", "banana", "apple", "apple", "banana"],
...          "B": [5, 4, 3, 2, 1],
...          "cars": ["beetle", "audi", "beetle", "beetle", "beetle"],
...      }
...  )
>>>
>>> sql = pl.SQLContext(t=df)
>>> sql.execute("select A, count(*)from t group by A", eager=True)
shape: (3, 2)
┌─────┬─────┐
│ Alen │
│ ------ │
│ i64u32 │
╞═════╪═════╡
│ 12   │
│ 32   │
│ 51   │
└─────┴─────┘
>>> sql.execute("select A as o, count(*)from t group by A", eager=True)
shape: (3, 2)
┌─────┬─────┐
│ olen │
│ ------ │
│ i64u32 │
╞═════╪═════╡
│ 51   │
│ 12   │
│ 32   │
└─────┴─────┘
>>> sql.execute("select A%3 as o, count(*)from t group by A%3", eager=True)
shape: (3, 2)
┌───────────┬─────┐
│ olen │
│ ------ │
│ list[i64] ┆ u32 │
╞═══════════╪═════╡
│ [0, 0]    ┆ 2   │
│ [2]       ┆ 1   │
│ [1, 1]    ┆ 2   │
└───────────┴─────┘
>>> sql.execute("select A%3 , count(*)from t group by A%3", eager=True)
shape: (3, 2)
┌─────┬─────┐
│ Alen │
│ ------ │
│ i64u32 │
╞═════╪═════╡
│ 12   │
│ 21   │
│ 02   │
└─────┴─────┘

from polars.

l1t1 avatar l1t1 commented on September 26, 2024

0.20.15 has the same issue

from polars.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.