
GITHUB . COM {
}
Detected CMS Systems:
- Wordpress (2 occurrences)
Title:
BUG: groupby with nans always places nans last Β· Issue #46584 Β· pandas-dev/pandas
Description:
Marking as milestone 1.5 because this issue was introduced by #45953. While the output of the transform op below was also incorrect prior to this PR, we are reporting this kind of op as being fixed in the whatsnew. When specifying sort=F...
Website Age:
17 years and 8 months (reg. 2007-10-09).
Matching Content Categories {π}
- Mobile Technology & AI
- Technology & Computing
- Social Networks
Content Management System {π}
What CMS is github.com built with?
Github.com employs WORDPRESS.
Traffic Estimate {π}
What is the average monthly size of github.com audience?
ππ Tremendous Traffic: 10M - 20M visitors per month
Based on our best estimate, this website will receive around 10,000,019 visitors per month in the current month.
However, some sources were not loaded, we suggest to reload the page to get complete results.
check SE Ranking
check Ahrefs
check Similarweb
check Ubersuggest
check Semrush
How Does Github.com Make Money? {πΈ}
Subscription Packages {π³}
We've located a dedicated page on github.com that might include details about subscription plans or recurring payments. We identified it based on the word pricing in one of its internal links. Below, you'll find additional estimates for its monthly recurring revenues.How Much Does Github.com Make? {π°}
Subscription Packages {π³}
Prices on github.com are in US Dollars ($).
They range from $4.00/month to $21.00/month.
We estimate that the site has approximately 4,989,889 paying customers.
The estimated monthly recurring revenue (MRR) is $20,957,532.
The estimated annual recurring revenues (ARR) are $251,490,385.
Wordpress Themes and Plugins {π¨}
What WordPress theme does this site use?
It is strange but we were not able to detect any theme on the page.
What WordPress plugins does this website use?
It is strange but we were not able to detect any plugins on the page.
Keywords {π}
sortfalse, rhshadrach, code, bug, groupby, issue, printdfgroupbya, sign, nans, transform, nan, algos, apply, projects, closed, milestone, npnan, factorize, added, navigation, pull, requests, actions, security, places, null, dropnafalsegrouperresultindex, floatindex, dtypefloat, namea, missingdata, pdnat, pdna, dropna, isnull, interpolate, nonarithmetic, valuecounts, sorting, isin, clip, shift, diff, aggregate, map, mentioned, github, type, footer, skip,
Topics {βοΈ}
personal information bug comment metadata assignees diff apply apply assigned labels algos projects milestone 1 type projects minor issue null groupers bug sort=false sort=true arithmetic algos incorrect prior dtype='float64' group encountered properly ordered interpolate type 100% complete relationships dropna=false issue np 5 closed largest code places nans github transform depends milestone 1 transform op df = pd groupby factorize dropna code code 2 sign nans op transform pd df skip jump introduced output pr reporting kind fixed whatsnew moved
Payment Methods {π}
- Braintree
Questions {β}
- Already have an account?
Schema {πΊοΈ}
DiscussionForumPosting:
context:https://schema.org
headline:BUG: groupby with nans always places nans last
articleBody:Marking as milestone 1.5 because this issue was introduced by #45953. While the output of the transform op below was also incorrect prior to this PR, we are reporting this kind of op as being fixed in the whatsnew.
When specifying `sort=False` and `dropna=False` in groupby, any null groupers are moved to the end, even when `sort=False`:
```
df = pd.DataFrame({'a': [1, 3, np.nan, 1, 2], 'b': [3, 4, 5, 6, 7]})
print(df.groupby('a', sort=False, dropna=False).grouper.result_index)
print(df.groupby('a', sort=True, dropna=False).grouper.result_index)
print(df.groupby('a', sort=False, dropna=False).sum())
```
gives
```
Float64Index([1.0, 3.0, 2.0, nan], dtype='float64', name='a')
Float64Index([1.0, 2.0, 3.0, nan], dtype='float64', name='a')
b
a
1.0 9
3.0 4
2.0 7
NaN 5
```
This is because nan is always given the largest code from factorize:
```
print(df.groupby('a', sort=False, dropna=False).codes)
# np.nan's code is 3, even though it is the third group encountered and so should be code 2.
[array([0, 1, 3, 0, 2])]
```
While only a minor issue for aggregations, transform depends on the code being properly ordered.
```
print(df.groupby('a', sort=False, dropna=False).transform(lambda x: x))
# Should be 3, 4, 5, 6, 7
b
0 3
1 4
2 7
3 6
4 5
```
author:
url:https://github.com/rhshadrach
type:Person
name:rhshadrach
datePublished:2022-03-31T12:31:51.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:0
url:https://github.com/46584/pandas/issues/46584
context:https://schema.org
headline:BUG: groupby with nans always places nans last
articleBody:Marking as milestone 1.5 because this issue was introduced by #45953. While the output of the transform op below was also incorrect prior to this PR, we are reporting this kind of op as being fixed in the whatsnew.
When specifying `sort=False` and `dropna=False` in groupby, any null groupers are moved to the end, even when `sort=False`:
```
df = pd.DataFrame({'a': [1, 3, np.nan, 1, 2], 'b': [3, 4, 5, 6, 7]})
print(df.groupby('a', sort=False, dropna=False).grouper.result_index)
print(df.groupby('a', sort=True, dropna=False).grouper.result_index)
print(df.groupby('a', sort=False, dropna=False).sum())
```
gives
```
Float64Index([1.0, 3.0, 2.0, nan], dtype='float64', name='a')
Float64Index([1.0, 2.0, 3.0, nan], dtype='float64', name='a')
b
a
1.0 9
3.0 4
2.0 7
NaN 5
```
This is because nan is always given the largest code from factorize:
```
print(df.groupby('a', sort=False, dropna=False).codes)
# np.nan's code is 3, even though it is the third group encountered and so should be code 2.
[array([0, 1, 3, 0, 2])]
```
While only a minor issue for aggregations, transform depends on the code being properly ordered.
```
print(df.groupby('a', sort=False, dropna=False).transform(lambda x: x))
# Should be 3, 4, 5, 6, 7
b
0 3
1 4
2 7
3 6
4 5
```
author:
url:https://github.com/rhshadrach
type:Person
name:rhshadrach
datePublished:2022-03-31T12:31:51.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:0
url:https://github.com/46584/pandas/issues/46584
Person:
url:https://github.com/rhshadrach
name:rhshadrach
url:https://github.com/rhshadrach
name:rhshadrach
InteractionCounter:
interactionType:https://schema.org/CommentAction
userInteractionCount:0
interactionType:https://schema.org/CommentAction
userInteractionCount:0
External Links {π}(2)
Analytics and Tracking {π}
- Site Verification - Google
Libraries {π}
- Clipboard.js
- D3.js
- Lodash
Emails and Hosting {βοΈ}
Mail Servers:
- aspmx.l.google.com
- alt1.aspmx.l.google.com
- alt2.aspmx.l.google.com
- alt3.aspmx.l.google.com
- alt4.aspmx.l.google.com
Name Servers:
- dns1.p08.nsone.net
- dns2.p08.nsone.net
- dns3.p08.nsone.net
- dns4.p08.nsone.net
- ns-1283.awsdns-32.org
- ns-1707.awsdns-21.co.uk
- ns-421.awsdns-52.com
- ns-520.awsdns-01.net