Siuba

Latest version: v0.4.4

Safety actively analyzes 628903 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 6 of 6

0.0.12

User Facing Changes

* Arrange correctly resets index. https://github.com/machow/siuba/pull/106
* Filter correctly resets index. https://github.com/machow/siuba/pull/130
* Switch to MIT license
* SqlTranslator is now mutable, so it's easier to tweak them on the fly (e.g. in a notebook. b9c81d77975a87b0f860dfb594f26c2d82e1052c
* pandas join feats / fixes
- **the implementation of `semi_join` was duplicating rows** as standard joins do.
this resulted in some very large results.... https://github.com/machow/siuba/pull/115
- implement anti_join
- fix failures when the on arg received a mapping
- fix `full_join` failing for pandas, since pandas calls it an 'outer' join
* implement sql transmute. https://github.com/machow/siuba/pull/108
* clean up, document, add docstring tests for vector funcs and forcats. https://github.com/machow/siuba/pull/120
* add full tests for forcats (thanks bakera81!) .https://github.com/machow/siuba/pull/121
* clean up and document `separate()`. https://github.com/machow/siuba/pull/119
* allow raw SQL. https://github.com/machow/siuba/pull/123
* generalize spread and gather. https://github.com/machow/siuba/pull/129
* mutate generates fewer subqueries now. https://github.com/machow/siuba/pull/127

As an experimental feature, I shortened the stacktraces for SQL translator errors! https://github.com/machow/siuba/pull/125

![image](https://user-images.githubusercontent.com/2574498/65356161-c0b88500-dbc1-11e9-92e2-b86603220626.png)



Chores

* clean up pytest. https://github.com/machow/siuba/pull/116

0.0.11

Small fix, supporting count without args. This is a very common case against SQL dbs, since it lets you know how big (how many rows) a table has.

e.g.


tbl_something >> count()

0.0.10

* all case_when values to be Calls (e.g. `case_when({True: _.a + 1}`) https://github.com/machow/siuba/pull/103
* add gather function
* add developer docs

0.0.9

* Allow custom specification of table columns (78) - this was preventing people from working with SQL when SqlAlchemy couldn't reflect column names from a database.
* Add some intro docs

0.0.8

0.0.7

This release implements extensive testing for postgres and sqlite. It also sets up (but skips) pandas unit tests.

It follows from this PR: https://github.com/machow/siuba/pull/36

SQL Improvements:

* fix distinct when following an arrange (65)
* move collect and show_query into dply.verbs (23)
* mutate now doesn't put redefined columns at end of table (42)
* full join gets all values in joining columns, even if unique to only 1 table (57)
* complete implementation of joins, including anti_ and semi_join (58, 55, 53)
* allow mutate to accept only scalar values, e.g. mutate(a = 1). (39)
* handle arbitrary siu expressions inside arrange (30)
* track arrange expressions, in order to allow cumulative functions (30)
* clearer messaging that summarize can't refer to just defined column (49)
* summarize, and mutate better identify when referencing a variable requires a CTE (46, 45)
* allow keyword args to group_by (52)

Page 6 of 6

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.