
GITHUB . COM {
}
Detected CMS Systems:
- Wordpress (2 occurrences)
Title:
API: Consistent handling of duplicate input columns Β· Issue #47718 Β· pandas-dev/pandas
Description:
When loading data into pandas with pandas.read_X() methods, the behavior when duplicate columns exist changes depending on the format. For read_csv, read_fwf and read_excel we have a mangle_dupe_cols parameter that we can provide. By def...
Website Age:
17 years and 8 months (reg. 2007-10-09).
Matching Content Categories {π}
- Graphic Design
- Technology & Computing
- Mobile Technology & AI
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 {π}
column, names, columns, duplicate, datapythonista, commented, option, raise, api, member, col, coli, str, data, format, readcsv, mangledupecols, default, duplicated, exception, consistency, drop, react, mycol, sign, methods, exist, cases, load, good, functions, discussion, jreback, author, case, mroeschke, dont, note, phofl, pull, requests, projects, handling, input, issue, behavior, argument, read, options, single,
Topics {βοΈ}
api/behavior api design {col_label}{any_string}{autoincrementing int} api makes sense personal information api input column names discussion requires discussion comment metadata assignees duplicate columns exist duplicate column names duplicate columns names final column names data apis consortium repeated column names makes things note duplicated column names support mangle_dupe_cols=false datapythonista mentioned current api type projects projects milestone make things duplicate columns columns exist eventually deprecate action type load data column names repeated names pandas consistent handling operation results make obsolete consistency mangle_dupe_cols parameter simply remove mangle_dupe_cols add implemented mangle_dupe_cols andthe code duplicated columns loading data loads data column {col} orient='split' read_xml drops backward compatibility deprecation period core team errors keyword understanding correctly jeff suggested
Payment Methods {π}
- Braintree
Questions {β}
- ) sound good to you?
- Already have an account?
- So to clarify, an example docstring would be?
- Thoughts?
Schema {πΊοΈ}
DiscussionForumPosting:
context:https://schema.org
headline:API: Consistent handling of duplicate input columns
articleBody:When loading data into pandas with `pandas.read_X()` methods, the behavior when duplicate columns exist changes depending on the format.
For `read_csv`, `read_fwf` and `read_excel` we have a `mangle_dupe_cols` parameter that we can provide. By default it appends `.1`, `.2`... to duplicated column names. Setting it to `False` raises an exception about not being implemented.
`html` also appends `.1`... but the option is not provided.
`read_json(orient='split')` loads data with the duplicate column names.
`read_xml` drops the columns if they are duplicated (I assume one columns keeps overwriting the previous with the same name).
Personally, I think we should have consistency among all them. What I would do is to control this with an option (e.g. `io.duplicate_columns`. Could also be an argument for all the `read_` methods, but I think these methods have already too many arguments, and I think the number of cases when users want to change this to be small, and very unlikely that they want to have different ways of handling duplicate column names in different calls to read methods.
Whether it's an option or an argument, we could allow the next options (feel free to propose better names):
- `raise`: If duplicate column names exist, raise an exception
- `drop`: Keep one (maybe the first) and ignore the rest
- `allow` Load data with duplicate columns. Based on discussions in the data apis consortium and #13262, I'd add this for backward compatibility only, but we shouldn't probably allow duplicate column names after a deprecation period. Or we can simply remove this option
- `{col}.{i}`, `{col}_{i}`...: Allow appending an autonumeric with a custom format. By default, `'{col}.{i}'` could be used, as this seems to be the preferred way based on the current API. This would address #8908,
I think it'd be good to have a single function that receives the input column names and return the final column names (indices of columns to use may also be needed, for cases like `drop`), or raises when appropriate. And all `read_` functions should use it if the format can have duplicate columns names.
Thoughts?
author:
url:https://github.com/datapythonista
type:Person
name:datapythonista
datePublished:2022-07-14T10:54:45.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:15
url:https://github.com/47718/pandas/issues/47718
context:https://schema.org
headline:API: Consistent handling of duplicate input columns
articleBody:When loading data into pandas with `pandas.read_X()` methods, the behavior when duplicate columns exist changes depending on the format.
For `read_csv`, `read_fwf` and `read_excel` we have a `mangle_dupe_cols` parameter that we can provide. By default it appends `.1`, `.2`... to duplicated column names. Setting it to `False` raises an exception about not being implemented.
`html` also appends `.1`... but the option is not provided.
`read_json(orient='split')` loads data with the duplicate column names.
`read_xml` drops the columns if they are duplicated (I assume one columns keeps overwriting the previous with the same name).
Personally, I think we should have consistency among all them. What I would do is to control this with an option (e.g. `io.duplicate_columns`. Could also be an argument for all the `read_` methods, but I think these methods have already too many arguments, and I think the number of cases when users want to change this to be small, and very unlikely that they want to have different ways of handling duplicate column names in different calls to read methods.
Whether it's an option or an argument, we could allow the next options (feel free to propose better names):
- `raise`: If duplicate column names exist, raise an exception
- `drop`: Keep one (maybe the first) and ignore the rest
- `allow` Load data with duplicate columns. Based on discussions in the data apis consortium and #13262, I'd add this for backward compatibility only, but we shouldn't probably allow duplicate column names after a deprecation period. Or we can simply remove this option
- `{col}.{i}`, `{col}_{i}`...: Allow appending an autonumeric with a custom format. By default, `'{col}.{i}'` could be used, as this seems to be the preferred way based on the current API. This would address #8908,
I think it'd be good to have a single function that receives the input column names and return the final column names (indices of columns to use may also be needed, for cases like `drop`), or raises when appropriate. And all `read_` functions should use it if the format can have duplicate columns names.
Thoughts?
author:
url:https://github.com/datapythonista
type:Person
name:datapythonista
datePublished:2022-07-14T10:54:45.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:15
url:https://github.com/47718/pandas/issues/47718
Person:
url:https://github.com/datapythonista
name:datapythonista
url:https://github.com/datapythonista
name:datapythonista
InteractionCounter:
interactionType:https://schema.org/CommentAction
userInteractionCount:15
interactionType:https://schema.org/CommentAction
userInteractionCount:15
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