Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Pandas Series should provide to_excel method #8825

Closed
scls19fr opened this issue Nov 15, 2014 · 1 comment · Fixed by #14780
Closed

Pandas Series should provide to_excel method #8825

scls19fr opened this issue Nov 15, 2014 · 1 comment · Fixed by #14780
Labels
API Design Compat pandas objects compatability with Numpy or Python functions IO Excel read_excel, to_excel
Milestone

Comments

@scls19fr
Copy link
Contributor

Hello,

Pandas Series provide to_csvmethod but they doesn't provide to_excel method.
Adding to_excel will avoid user to convert a pandas.core.series.Series to a pandas.core.frame.DataFrame in order to output Excel file

DataFrames provide

df.to_clipboard  df.to_hdf        df.to_period     df.to_string
df.to_csv        df.to_html       df.to_pickle     df.to_timestamp
df.to_dense      df.to_json       df.to_records    df.to_wide
df.to_dict       df.to_latex      df.to_sparse
df.to_excel      df.to_msgpack    df.to_sql
df.to_gbq        df.to_panel      df.to_stata

Series provide

ts.to_clipboard  ts.to_frame      ts.to_period     ts.to_string
ts.to_csv        ts.to_hdf        ts.to_pickle     ts.to_timestamp
ts.to_dense      ts.to_json       ts.to_sparse     ts.tolist
ts.to_dict       ts.to_msgpack    ts.to_sql

Kind regards

@jreback jreback added API Design Compat pandas objects compatability with Numpy or Python functions IO Excel read_excel, to_excel labels Nov 15, 2014
@jreback jreback added this to the 0.16.0 milestone Nov 15, 2014
@jreback
Copy link
Contributor

jreback commented Nov 15, 2014

ok, current work-around is:

s.to_frame().to_excel()

pulll-requests welcome

@jreback jreback modified the milestones: 0.16.0, Next Major Release Mar 6, 2015
scls19fr added a commit to scls19fr/pandas that referenced this issue Dec 1, 2016
scls19fr added a commit to scls19fr/pandas that referenced this issue Dec 2, 2016
scls19fr added a commit to scls19fr/pandas that referenced this issue Dec 4, 2016
scls19fr added a commit to scls19fr/pandas that referenced this issue Dec 4, 2016
@jorisvandenbossche jorisvandenbossche modified the milestones: 0.20.0, Next Major Release Dec 5, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
API Design Compat pandas objects compatability with Numpy or Python functions IO Excel read_excel, to_excel
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants