
GITHUB . COM {
}
Detected CMS Systems:
- Wordpress (2 occurrences)
Title:
pivot_table not displaying values columns in expected order Β· Issue #17041 Β· pandas-dev/pandas
Description:
Code Sample, a copy-pastable example if possible # Your code here column_order = ['Year', 'Month', 'Currency', 'Total Net', 'Fees'] df_fills = df_fills.reind...
Website Age:
17 years and 9 months (reg. 2007-10-09).
Matching Content Categories {π}
- Cryptocurrency
- Mobile Technology & AI
- Technology & Computing
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 5,013,426 paying customers.
The estimated monthly recurring revenue (MRR) is $21,056,387.
The estimated annual recurring revenues (ARR) are $252,676,649.
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 {π}
ericbhanson, net, dffillsdffillsside, fees, commented, code, total, gfyoung, jreback, columns, expected, currency, dffills, true, data, values, order, year, month, pivottable, issue, axis, output, author, source, sign, column, pivot, import, inplace, dffillsbuynet, dffillssellnet, pandas, projects, description, columnorder, dffillsreindexaxiscolumnorder, pdpivottabledffills, index, aggfunc, npsum, margins, fillvalue, creating, dataframe, table, reshaping, concat, mergejoin, stackunstack,
Topics {βοΈ}
original issue description original data source listed total net id=0b5qzk8ir7q-ytejvogdpewtyz1u comment metadata assignees ]['fees'] df_fills['sell_net'] = column marked fees external data set pd import numpy fees column shows personal information pivot_table df_fills['year'] = pd copy-pastable minimal displaying values columns df_fills['fees'] = pd import pandas 'total net' total net df_fills['size'] = pd explode type pls post df_fills['buy_net'] = problem description /open type projects projects milestone 1 data removed screen shot df_fills = df_fills fees column expected order copy-pastable df_fills['price'] df_fills['fees'] np pd index = ['year' issue order entered sensitive information source opposite order simple copy bug df_fills['created_at'] df_fills['size'] expected output column_order = ['year' columns = {'product_id' aggfunc = np margins = true
Payment Methods {π}
- Braintree
Questions {β}
- @gfyoung happy to - are you looking for a simple copy and paste of what I'm seeing in Jupyter versus what I'm expecting to see?
- @jreback in the screen shot I enclosed above, do you see how the column marked Fees is displayed before the column marked Total Net?
- Already have an account?
- Could you put pictures of what is currently output and what you expected in your original issue description?
- Com/open?
Schema {πΊοΈ}
DiscussionForumPosting:
context:https://schema.org
headline:pivot_table not displaying values columns in expected order
articleBody:#### Code Sample, a copy-pastable example if possible
```python
# Your code here
column_order = ['Year', 'Month', 'Currency', 'Total Net', 'Fees']
df_fills = df_fills.reindex_axis(column_order, axis = 1)
pd.pivot_table(df_fills, values = ['Total Net', 'Fees'], index = ['Year', 'Month'],
columns = ['Currency'], aggfunc = np.sum, margins = True, fill_value = 0)
```
#### Problem description
When creating the dataframe, Fees column comes first (it's from an external data set), while Total Net comes second (it's calculated). I reordered them using reindex_axis and when asking Python to show the dataframe, I get the expected order. However, when creating a pivot table, Fees always comes first, no matter what.
#### Expected Output
pivot_table should display columns of values in the order entered in the function.
#### Output of ``pd.show_versions()``
<details>
# Paste the output here pd.show_versions() here
INSTALLED VERSIONS
------------------
commit: None
python: 2.7.13.final.0
python-bits: 64
OS: Darwin
OS-release: 16.7.0
machine: x86_64
processor: i386
byteorder: little
LC_ALL: None
LANG: en_US.UTF-8
LOCALE: None.None
pandas: 0.20.2
pytest: 3.0.7
pip: 9.0.1
setuptools: 27.2.0
Cython: 0.25.2
numpy: 1.12.1
scipy: 0.19.0
xarray: None
IPython: 5.3.0
sphinx: 1.5.6
patsy: 0.4.1
dateutil: 2.6.0
pytz: 2017.2
blosc: None
bottleneck: 1.2.1
tables: 3.3.0
numexpr: 2.6.2
feather: None
matplotlib: 2.0.2
openpyxl: 2.4.7
xlrd: 1.0.0
xlwt: 1.2.0
xlsxwriter: 0.9.6
lxml: 3.7.3
bs4: 4.6.0
html5lib: 0.999
sqlalchemy: 1.1.9
pymysql: None
psycopg2: None
jinja2: 2.9.6
s3fs: None
pandas_gbq: None
pandas_datareader: None
</details>
author:
url:https://github.com/ericbhanson
type:Person
name:ericbhanson
datePublished:2017-07-20T19:14:16.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:25
url:https://github.com/17041/pandas/issues/17041
context:https://schema.org
headline:pivot_table not displaying values columns in expected order
articleBody:#### Code Sample, a copy-pastable example if possible
```python
# Your code here
column_order = ['Year', 'Month', 'Currency', 'Total Net', 'Fees']
df_fills = df_fills.reindex_axis(column_order, axis = 1)
pd.pivot_table(df_fills, values = ['Total Net', 'Fees'], index = ['Year', 'Month'],
columns = ['Currency'], aggfunc = np.sum, margins = True, fill_value = 0)
```
#### Problem description
When creating the dataframe, Fees column comes first (it's from an external data set), while Total Net comes second (it's calculated). I reordered them using reindex_axis and when asking Python to show the dataframe, I get the expected order. However, when creating a pivot table, Fees always comes first, no matter what.
#### Expected Output
pivot_table should display columns of values in the order entered in the function.
#### Output of ``pd.show_versions()``
<details>
# Paste the output here pd.show_versions() here
INSTALLED VERSIONS
------------------
commit: None
python: 2.7.13.final.0
python-bits: 64
OS: Darwin
OS-release: 16.7.0
machine: x86_64
processor: i386
byteorder: little
LC_ALL: None
LANG: en_US.UTF-8
LOCALE: None.None
pandas: 0.20.2
pytest: 3.0.7
pip: 9.0.1
setuptools: 27.2.0
Cython: 0.25.2
numpy: 1.12.1
scipy: 0.19.0
xarray: None
IPython: 5.3.0
sphinx: 1.5.6
patsy: 0.4.1
dateutil: 2.6.0
pytz: 2017.2
blosc: None
bottleneck: 1.2.1
tables: 3.3.0
numexpr: 2.6.2
feather: None
matplotlib: 2.0.2
openpyxl: 2.4.7
xlrd: 1.0.0
xlwt: 1.2.0
xlsxwriter: 0.9.6
lxml: 3.7.3
bs4: 4.6.0
html5lib: 0.999
sqlalchemy: 1.1.9
pymysql: None
psycopg2: None
jinja2: 2.9.6
s3fs: None
pandas_gbq: None
pandas_datareader: None
</details>
author:
url:https://github.com/ericbhanson
type:Person
name:ericbhanson
datePublished:2017-07-20T19:14:16.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:25
url:https://github.com/17041/pandas/issues/17041
Person:
url:https://github.com/ericbhanson
name:ericbhanson
url:https://github.com/ericbhanson
name:ericbhanson
InteractionCounter:
interactionType:https://schema.org/CommentAction
userInteractionCount:25
interactionType:https://schema.org/CommentAction
userInteractionCount:25
External Links {π}(4)
- How profitable is https://github.blog?
- What's the financial gain of https://user-images.githubusercontent.com/7453426/28436967-e3670eda-6d66-11e7-9753-549fbe519be1.png?
- How much does https://drive.google.com/open?id=0B5QZk8ir7q-yTEJVOGdPeWtyZ1U gross monthly?
- How much money does https://www.githubstatus.com/ generate?
Analytics and Tracking {π}
- Site Verification - Google
Libraries {π}
- Clipboard.js
- D3.js
- GSAP
- 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