GITHUB . COM {}

Detected CMS Systems:

Wordpress (2 occurrences)

Analyzed Page
Matching Content Categories
CMS
Monthly Traffic Estimate
How Does Github.com Make Money
How Much Does Github.com Make
Wordpress Themes And Plugins
Keywords
Topics
Payment Methods
Questions
Schema
External Links
Analytics And Tracking
Libraries
Hosting Providers

We are analyzing https://github.com/pandas-dev/pandas/issues/30107.

Title:
When applied as style in to_excel(), 'vertical-align: middle' works for OpenPyXL, but not for XlsxWriter engine · Issue #30107 · pandas-dev/pandas
Description:
Code sample, a copy-pastable example if possible import pandas as pd def align(data): return pd.DataFrame('text-align: center', index=data.index, columns=data.columns) def valign(data): ret...
Website Age:
17 years and 8 months (reg. 2007-10-09).

Matching Content Categories {📚}

Mobile Technology & AI
Automotive
Transportation

Content Management System {📝}

What CMS is github.com built with?

Github.com uses 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 {🔍}

engine, xlsxwriter, verticalalign, middle, tehunter, center, output, sign, pandas, toexcel, openpyxl, col, firstnsecond, sheet, projects, applied, issue, def, return, indexdataindex, columnsdatacolumns, pdexcelwritertestxlsx, writer, dftoexcelwriter, sheetnametest, alignment, expected, setting, added, bug, navigation, code, pull, requests, actions, security, style, works, closed, description, import, pddataframedatad, enginexlsxwriter, problem, vertical, correctly, doesnt, occur, generated, fmt,

Topics {✒️}

pandas/io/formats/excel pandas/io/excel/_xlsxwriter sheet_name='test sheet' handle vertical-align fix vertical-align import pandas pandas styling problem description type projects projects milestone bug engine='xlsxwriter' xlsxwriter engine vertical alignment workbook = writer middle' works horizontal alignment 'vertical-align 'vertical-align' github openpyxl engine engine='openpyxl' vcenter setting copy-pastable def whitespace 'white-space correctly generated generated solely correct names correct mapping properly translated top' generates milestone relationships personal information center setting return pd expected output proper output df = df whitespace/wrapping styler style type 'text-align def valign occur resp correctly applied index=data columns=data fmt middle'

Payment Methods {📊}

Braintree

Questions {❓}

Already have an account?

Schema {🗺️}

DiscussionForumPosting:
      context:https://schema.org
      headline:When applied as style in to_excel(), 'vertical-align: middle' works for OpenPyXL, but not for XlsxWriter engine
      articleBody:#### Code sample, a copy-pastable example if possible ```python import pandas as pd def align(data): return pd.DataFrame('text-align: center', index=data.index, columns=data.columns) def valign(data): return pd.DataFrame('vertical-align: middle', index=data.index, columns=data.columns) def whitespace(data): return pd.DataFrame('white-space: normal', index=data.index, columns=data.columns) d = {'col1': ['first\nsecond', 'only one'], 'col2': ['only one', 'first\nsecond']} df = pd.DataFrame(data=d) df = df.style.apply(align, axis=None).apply(valign, axis=None).apply(whitespace, axis=None) with pd.ExcelWriter('test.xlsx', engine='xlsxwriter') as writer: df.to_excel(writer, sheet_name='Test sheet') ``` #### Problem description When using the XlsxWriter engine, the vertical alignment is ignored, the text is aligned to the bottom. The horizontal alignment as well as the whitespace/wrapping are correctly applied. ![xlsxwriter](https://i.stack.imgur.com/IyT99.png) #### Expected output This doesn't occur, when the OpenPyXL engine is chosen, i.e. when using: ```python with pd.ExcelWriter('test.xlsx', engine='openpyxl') as writer: df.to_excel(writer, sheet_name='Test sheet') ``` The expected output is correctly generated: ![openpyxl](https://i.stack.imgur.com/P117n.png) #### Some observations The problem doesn't occur resp. the expected output can be generated solely using the XlsxWriter engine **without** using pandas styling: ```python import pandas as pd d = {'col1': ['first\nsecond', 'only one'], 'col2': ['only one', 'first\nsecond']} df = pd.DataFrame(data=d) with pd.ExcelWriter('test.xlsx', engine='xlsxwriter') as writer: df.to_excel(writer, sheet_name='Test sheet') workbook = writer.book worksheet = writer.sheets['Test sheet'] fmt = workbook.add_format({'align': 'center', 'valign': 'vcenter', 'text_wrap': True}) worksheet.set_column('B:C', None, fmt) ``` From [pandas/io/formats/excel.py](https://github.com/pandas-dev/pandas/blob/master/pandas/io/formats/excel.py#L109), I assume, that the vertical alignment setting `middle` is mapped to `center`, such that `'vertical-align': 'center'`. Furthermore, from [pandas/io/excel/_xlsxwriter.py](https://github.com/pandas-dev/pandas/blob/master/pandas/io/excel/_xlsxwriter.py#L8), I guess, that the corresponding settings from the OpenPyXL engine are used and (partially) mapped to the correct names used in the XlsxWriter engine, cf. the correct mapping to `valign`. Now, my assumption is, that the (OpenPyXL's) `center` setting isn't properly translated to the XlsxWriter's `vcenter` setting, because, for example, `'vertical-align: top'` generates the proper output also for the XlsxWriter engine. #### Output of ``pd.show_versions()`` <details> ```lang-none INSTALLED VERSIONS ------------------ commit : None python : 3.7.1.final.0 python-bits : 64 OS : Windows OS-release : 10 machine : AMD64 processor : Intel64 Family 6 Model 60 Stepping 3, GenuineIntel byteorder : little LC_ALL : None LANG : None LOCALE : None.None pandas : 0.25.3 numpy : 1.17.4 pytz : 2019.3 dateutil : 2.8.1 pip : 19.3.1 setuptools : 39.1.0 Cython : None pytest : None hypothesis : None sphinx : None blosc : None feather : None xlsxwriter : None lxml.etree : None html5lib : None pymysql : None psycopg2 : None jinja2 : None IPython : None pandas_datareader: None bs4 : 4.8.1 bottleneck : None fastparquet : None gcsfs : None lxml.etree : None matplotlib : 3.2.0rc1 numexpr : None odfpy : None openpyxl : 3.0.0 pandas_gbq : None pyarrow : None pytables : None s3fs : None scipy : 1.3.1 sqlalchemy : None tables : None xarray : None xlrd : None xlwt : None xlsxwriter : None ``` </details>
      author:
         url:https://github.com/HansHirse
         type:Person
         name:HansHirse
      datePublished:2019-12-06T10:47:20.000Z
      interactionStatistic:
         type:InteractionCounter
         interactionType:https://schema.org/CommentAction
         userInteractionCount:1
      url:https://github.com/30107/pandas/issues/30107
      context:https://schema.org
      headline:When applied as style in to_excel(), 'vertical-align: middle' works for OpenPyXL, but not for XlsxWriter engine
      articleBody:#### Code sample, a copy-pastable example if possible ```python import pandas as pd def align(data): return pd.DataFrame('text-align: center', index=data.index, columns=data.columns) def valign(data): return pd.DataFrame('vertical-align: middle', index=data.index, columns=data.columns) def whitespace(data): return pd.DataFrame('white-space: normal', index=data.index, columns=data.columns) d = {'col1': ['first\nsecond', 'only one'], 'col2': ['only one', 'first\nsecond']} df = pd.DataFrame(data=d) df = df.style.apply(align, axis=None).apply(valign, axis=None).apply(whitespace, axis=None) with pd.ExcelWriter('test.xlsx', engine='xlsxwriter') as writer: df.to_excel(writer, sheet_name='Test sheet') ``` #### Problem description When using the XlsxWriter engine, the vertical alignment is ignored, the text is aligned to the bottom. The horizontal alignment as well as the whitespace/wrapping are correctly applied. ![xlsxwriter](https://i.stack.imgur.com/IyT99.png) #### Expected output This doesn't occur, when the OpenPyXL engine is chosen, i.e. when using: ```python with pd.ExcelWriter('test.xlsx', engine='openpyxl') as writer: df.to_excel(writer, sheet_name='Test sheet') ``` The expected output is correctly generated: ![openpyxl](https://i.stack.imgur.com/P117n.png) #### Some observations The problem doesn't occur resp. the expected output can be generated solely using the XlsxWriter engine **without** using pandas styling: ```python import pandas as pd d = {'col1': ['first\nsecond', 'only one'], 'col2': ['only one', 'first\nsecond']} df = pd.DataFrame(data=d) with pd.ExcelWriter('test.xlsx', engine='xlsxwriter') as writer: df.to_excel(writer, sheet_name='Test sheet') workbook = writer.book worksheet = writer.sheets['Test sheet'] fmt = workbook.add_format({'align': 'center', 'valign': 'vcenter', 'text_wrap': True}) worksheet.set_column('B:C', None, fmt) ``` From [pandas/io/formats/excel.py](https://github.com/pandas-dev/pandas/blob/master/pandas/io/formats/excel.py#L109), I assume, that the vertical alignment setting `middle` is mapped to `center`, such that `'vertical-align': 'center'`. Furthermore, from [pandas/io/excel/_xlsxwriter.py](https://github.com/pandas-dev/pandas/blob/master/pandas/io/excel/_xlsxwriter.py#L8), I guess, that the corresponding settings from the OpenPyXL engine are used and (partially) mapped to the correct names used in the XlsxWriter engine, cf. the correct mapping to `valign`. Now, my assumption is, that the (OpenPyXL's) `center` setting isn't properly translated to the XlsxWriter's `vcenter` setting, because, for example, `'vertical-align: top'` generates the proper output also for the XlsxWriter engine. #### Output of ``pd.show_versions()`` <details> ```lang-none INSTALLED VERSIONS ------------------ commit : None python : 3.7.1.final.0 python-bits : 64 OS : Windows OS-release : 10 machine : AMD64 processor : Intel64 Family 6 Model 60 Stepping 3, GenuineIntel byteorder : little LC_ALL : None LANG : None LOCALE : None.None pandas : 0.25.3 numpy : 1.17.4 pytz : 2019.3 dateutil : 2.8.1 pip : 19.3.1 setuptools : 39.1.0 Cython : None pytest : None hypothesis : None sphinx : None blosc : None feather : None xlsxwriter : None lxml.etree : None html5lib : None pymysql : None psycopg2 : None jinja2 : None IPython : None pandas_datareader: None bs4 : 4.8.1 bottleneck : None fastparquet : None gcsfs : None lxml.etree : None matplotlib : 3.2.0rc1 numexpr : None odfpy : None openpyxl : 3.0.0 pandas_gbq : None pyarrow : None pytables : None s3fs : None scipy : 1.3.1 sqlalchemy : None tables : None xarray : None xlrd : None xlwt : None xlsxwriter : None ``` </details>
      author:
         url:https://github.com/HansHirse
         type:Person
         name:HansHirse
      datePublished:2019-12-06T10:47:20.000Z
      interactionStatistic:
         type:InteractionCounter
         interactionType:https://schema.org/CommentAction
         userInteractionCount:1
      url:https://github.com/30107/pandas/issues/30107
Person:
      url:https://github.com/HansHirse
      name:HansHirse
      url:https://github.com/HansHirse
      name:HansHirse
InteractionCounter:
      interactionType:https://schema.org/CommentAction
      userInteractionCount:1
      interactionType:https://schema.org/CommentAction
      userInteractionCount:1

External Links {🔗}(4)

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

8.8s.