GITHUB . COM {}

Matching Content Categories {📚}

• Video & Online Content
• Technology & Computing
• Personal Finance

Content Management System {📝}

What CMS is github.com built with?

Github.com utilizes 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,634,219 visitors per month in the current month.

check SE Ranking
check Ahrefs
check Similarweb
check Ubersuggest
check Semrush

How Does Github.com Make Money? {💸}

Subscription Packages {💳}

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,306,347 paying customers.
The estimated monthly recurring revenue (MRR) is $22,286,656.
The estimated annual recurring revenues (ARR) are $267,439,867.

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 {🔍}

file, line, excel, apacha, bug, header, pandas, issue, import, crashes, simple, exception, venvlibpythonsitepackagespandasioparserspythonparserpy, return, commented, author, sheets, sign, valueerror, problem, phofl, rows, projects, version, loading, traceback, recent, call, venvlibpythonsitepackagespandasioexcelbasepy, readexcel, venvlibpythonsitepackagespandasioparsersreaderspy, passed, len, lines, expected, behavior, member, navigation, code, pull, requests, actions, security, closed, description, opened, confirmed, exists, pdreadexcelusersalexdesktopbrokenexcelxlsx, sheetnamenone,

Topics {✒️}

venv/bin/python /users/alex/library/application support/jetbrains/pycharm2022 /users/alex/library/application support/jetbrains/pycharm2022 9/site-packages/pandas/io/parsers/python_parser 9/site-packages/pandas/io/parsers/readers 9/site-packages/pandas/io/excel/_base 9/site-packages/pandas/util/_decorators /users/alex/desktop/brokenexcel apacha closed excel import crashes venv/lib/python3 returned weird results comment metadata assignees import pandas python engine personal information bug attached file produces extremely simplified file attached test-file apacha changed apacha reopened existing header rows existing header rows opened anymore excel documents type projects projects milestone triage issue issue type excel file latest version excel files excel document pandas pandas 1 bug exists removed bug expected behavior problem brokenexcel header rows main branch 2/scratches/scratch_5 recent call list index read_csv ignoring bit torn breaks lots current solution breaks compatibility immediately clear provided message

Payment Methods {📊}

• Braintree

Questions {❓}

• Already have an account?
• Why specifying non-existing header rows at all?

Schema {🗺️}

DiscussionForumPosting:
      context:https://schema.org
      headline:BUG: Excel import crashes on simple file
      articleBody:### Pandas version checks - [X] I have checked that this issue has not already been reported. - [X] I have confirmed this bug exists on the [latest version](https://pandas.pydata.org/docs/whatsnew/index.html) of pandas. - [x] I have confirmed this bug exists on the main branch of pandas. ### Reproducible Example ```python import pandas as pd file = pd.read_excel("/Users/alex/Desktop/BrokenExcel.xlsx", sheet_name=None, header=1) ``` ### Issue Description Loading the attached file produces an exception and crashes in 1.5.0 but worked in 1.4.3. ```bash venv/bin/python /Users/alex/Library/Application Support/JetBrains/PyCharm2022.2/scratches/scratch_5.py Traceback (most recent call last): File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 701, in _next_line line = self._check_comments([self.data[self.pos]])[0] IndexError: list index out of range During handling of the above exception, another exception occurred: Traceback (most recent call last): File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 386, in _infer_columns line = self._next_line() File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 714, in _next_line raise StopIteration StopIteration The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/alex/Library/Application Support/JetBrains/PyCharm2022.2/scratches/scratch_5.py", line 2, in <module> file = pd.read_excel("/Users/alex/Desktop/BrokenExcel.xlsx", sheet_name=None, header=1) File "venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 211, in wrapper return func(*args, **kwargs) File "venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 317, in wrapper return func(*args, **kwargs) File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 491, in read_excel data = io.parse( File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 1711, in parse return self._reader.parse( File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 867, in parse parser = TextParser( File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1870, in TextParser return TextFileReader(*args, **kwds) File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1442, in __init__ self._engine = self._make_engine(f, self.engine) File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1747, in _make_engine return mapping[engine](f, **self.options) File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 123, in __init__ ) = self._infer_columns() File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 396, in _infer_columns raise ValueError( ValueError: Passed header=[1], len of 1, but only 1 lines in file Process finished with exit code 1 ``` ### Expected Behavior Loading of the Excel file (as in 1.4.3) ### Installed Versions <details> INSTALLED VERSIONS ------------------ commit : 87cfe4e38bafe7300a6003a1d18bd80f3f77c763 python : 3.9.13.final.0 python-bits : 64 OS : Darwin OS-release : 21.6.0 Version : Darwin Kernel Version 21.6.0: Mon Aug 22 20:17:10 PDT 2022; root:xnu-8020.140.49~2/RELEASE_X86_64 machine : x86_64 processor : i386 byteorder : little LC_ALL : None LANG : None LOCALE : en_US.UTF-8 pandas : 1.5.0 numpy : 1.23.3 pytz : 2022.1 dateutil : 2.8.2 setuptools : 62.6.0 pip : 22.2.2 Cython : None pytest : 7.1.3 hypothesis : None sphinx : None blosc : None feather : None xlsxwriter : None lxml.etree : 4.9.1 html5lib : None pymysql : None psycopg2 : None jinja2 : 3.1.2 IPython : None pandas_datareader: None bs4 : None bottleneck : None brotli : None fastparquet : None fsspec : None gcsfs : None matplotlib : None numba : None numexpr : None odfpy : None openpyxl : 3.0.10 pandas_gbq : None pyarrow : None pyreadstat : None pyxlsb : None s3fs : None scipy : 1.9.0 snappy : None sqlalchemy : None tables : None tabulate : None xarray : None xlrd : None xlwt : None zstandard : None tzdata : None </details>
      author:
         url:https://github.com/apacha
         type:Person
         name:apacha
      datePublished:2022-09-22T08:09:26.000Z
      interactionStatistic:
         type:InteractionCounter
         interactionType:https://schema.org/CommentAction
         userInteractionCount:11
      url:https://github.com/48706/pandas/issues/48706
      context:https://schema.org
      headline:BUG: Excel import crashes on simple file
      articleBody:### Pandas version checks - [X] I have checked that this issue has not already been reported. - [X] I have confirmed this bug exists on the [latest version](https://pandas.pydata.org/docs/whatsnew/index.html) of pandas. - [x] I have confirmed this bug exists on the main branch of pandas. ### Reproducible Example ```python import pandas as pd file = pd.read_excel("/Users/alex/Desktop/BrokenExcel.xlsx", sheet_name=None, header=1) ``` ### Issue Description Loading the attached file produces an exception and crashes in 1.5.0 but worked in 1.4.3. ```bash venv/bin/python /Users/alex/Library/Application Support/JetBrains/PyCharm2022.2/scratches/scratch_5.py Traceback (most recent call last): File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 701, in _next_line line = self._check_comments([self.data[self.pos]])[0] IndexError: list index out of range During handling of the above exception, another exception occurred: Traceback (most recent call last): File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 386, in _infer_columns line = self._next_line() File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 714, in _next_line raise StopIteration StopIteration The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/alex/Library/Application Support/JetBrains/PyCharm2022.2/scratches/scratch_5.py", line 2, in <module> file = pd.read_excel("/Users/alex/Desktop/BrokenExcel.xlsx", sheet_name=None, header=1) File "venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 211, in wrapper return func(*args, **kwargs) File "venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 317, in wrapper return func(*args, **kwargs) File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 491, in read_excel data = io.parse( File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 1711, in parse return self._reader.parse( File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 867, in parse parser = TextParser( File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1870, in TextParser return TextFileReader(*args, **kwds) File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1442, in __init__ self._engine = self._make_engine(f, self.engine) File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1747, in _make_engine return mapping[engine](f, **self.options) File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 123, in __init__ ) = self._infer_columns() File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 396, in _infer_columns raise ValueError( ValueError: Passed header=[1], len of 1, but only 1 lines in file Process finished with exit code 1 ``` ### Expected Behavior Loading of the Excel file (as in 1.4.3) ### Installed Versions <details> INSTALLED VERSIONS ------------------ commit : 87cfe4e38bafe7300a6003a1d18bd80f3f77c763 python : 3.9.13.final.0 python-bits : 64 OS : Darwin OS-release : 21.6.0 Version : Darwin Kernel Version 21.6.0: Mon Aug 22 20:17:10 PDT 2022; root:xnu-8020.140.49~2/RELEASE_X86_64 machine : x86_64 processor : i386 byteorder : little LC_ALL : None LANG : None LOCALE : en_US.UTF-8 pandas : 1.5.0 numpy : 1.23.3 pytz : 2022.1 dateutil : 2.8.2 setuptools : 62.6.0 pip : 22.2.2 Cython : None pytest : 7.1.3 hypothesis : None sphinx : None blosc : None feather : None xlsxwriter : None lxml.etree : 4.9.1 html5lib : None pymysql : None psycopg2 : None jinja2 : 3.1.2 IPython : None pandas_datareader: None bs4 : None bottleneck : None brotli : None fastparquet : None fsspec : None gcsfs : None matplotlib : None numba : None numexpr : None odfpy : None openpyxl : 3.0.10 pandas_gbq : None pyarrow : None pyreadstat : None pyxlsb : None s3fs : None scipy : 1.9.0 snappy : None sqlalchemy : None tables : None tabulate : None xarray : None xlrd : None xlwt : None zstandard : None tzdata : None </details>
      author:
         url:https://github.com/apacha
         type:Person
         name:apacha
      datePublished:2022-09-22T08:09:26.000Z
      interactionStatistic:
         type:InteractionCounter
         interactionType:https://schema.org/CommentAction
         userInteractionCount:11
      url:https://github.com/48706/pandas/issues/48706
Person:
      url:https://github.com/apacha
      name:apacha
      url:https://github.com/apacha
      name:apacha
InteractionCounter:
      interactionType:https://schema.org/CommentAction
      userInteractionCount:11
      interactionType:https://schema.org/CommentAction
      userInteractionCount:11

External Links {🔗}(3)

• Discover the revenue of https://github.blog
• What is the monthly revenue of https://pandas.pydata.org/docs/whatsnew/index.html?
• What's the monthly money flow for https://www.githubstatus.com/?

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