-
-
Notifications
You must be signed in to change notification settings - Fork 17.6k
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
Excel output in non-ascii encodings #3710
Conversation
…using xlwt, also for output without ExcelWriter - just filename
…using xlwt, also for output without ExcelWriter - just filename - final
@jtornero this is nice, but a couple of things.
|
couple of things
|
also...need to rebase off of master
then merge conflcts the excel stuff has been moved to fix and proceed thanks |
First, I think I should learn this git stuff a bit before doing the big mess. I have to recognize that git overwhelmes me a little. I tried to do what you said and no way. Maybe it is better for me (and for all) to start in git from scratch (delete my fork and start again) Anyway, about your suggest has two optionals parameters:ions (will be followed in the future)
Best regards, Jorge Tornero |
@jtornero the encoding my default in
these are easy enough to test without an actual data file; this will temporarily create a file and clean it up when done. you will get read_excel if you rebase off of master (or start over), up to u, git is an animal!
|
@jtornero how's this coming along? |
Hello again. Sorry for the time been away. I'll be on holiday in a week, and I think I'll have some spare time to try to cope with it. I really need to start over with my git forking etc., because I made sort of mess with my repository. Maybe it's a big thing for my level of knowledge, but I'll try to do it again. Best regards |
ping! |
Yes, I'm still alive. I've started again and I'm going to try to make it work this weekend. Sorry. |
Well I've made it and it passes the tests. But I can't manage to commit my changes in this *****+ of git. I know it's my fault but I am sooooo disappointed... need help about this. Also, the changes are so simle after the new code of excel output. But I'm so stuck... guess I'll be able to put my changes here some time. I don't know if it's the thing about Travis IC or what, but 've done this: git clone https://github.com/jtornero/pandas.git git checkout -b excelout_encodings after my changes: git add . git status I've got this: On branch excelout_encodings
Then and then: git push origin master Well... then nothing happens. I guess I should be able to see my commit in my repository... but nothing happens!!! I don't know how to do it... maybe it is related to Travis IC? Thank yo very much |
@jtornero it looks like you aren't making that many changes. Might be easier to go back and checkout pydata/master then apply just your changes to it. |
merged via 268ee80 |
First, I would like to thank the developers for this excellent work.
My patch is about the possibility of specify the workbook encoding when making output to excel xls files. By default, pandas hasn't it, so say-so non ascii language speakers weren't able to save files with special characters, receiving an error like, for instance:
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 2: ordinal not in range(128)
My change makes possible to specify both in ExcelWriter and DataFrame.to_excel the parameter encoding which is passed by both the ExcelWriter init and DataFrame.to_excel functions to the appropiate xlwt function to make the trick.
I'm sorry my explanations aren't very proffesional, but I think they are enough for this purpose.
Also I have to apologize in the sense that I've run the tests with nosetests and I lack of knowledge about tests interpretation, but I have checked the log and no error comes from the modules/files I've worked with.
Best regards,
Jorge Tornero