Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Appending a row of data in an MS Excel file
Post: RE: Appending a row of data in an MS Excel file
Thanks both. I was using index=False but unfortunately in the wrong line, that's why it gave me an error.
 azizrasul General Coding Help 3 1,198 Nov-06-2022, 05:17 PM
    Thread: Appending a row of data in an MS Excel file
Post: Appending a row of data in an MS Excel file
I have the following working code which amalgamates excel file data into one Excel file. How do I amend the code so that I do not have an index column on the first column? import pandas as pd import ...
 azizrasul General Coding Help 3 1,198 Nov-05-2022, 08:27 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Will do.
 azizrasul General Coding Help 40 5,719 Nov-03-2022, 08:33 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Thanks deanhystad, I learnt something today. The code worked.
 azizrasul General Coding Help 40 5,719 Nov-03-2022, 07:22 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Agreed, this is as much to do with trying to understand the code in post #33 and try to learn Python as I am a beginner.
 azizrasul General Coding Help 40 5,719 Nov-03-2022, 04:10 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
It does work except that I get alternate blank lines that's all. I've fiddled with the code to get rid of the blank lines but can't figure it out.
 azizrasul General Coding Help 40 5,719 Nov-03-2022, 02:05 AM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Here's a solution (based on post #1) which kinda works (I get Sheet1.csv and Sheet2.csv corresponding to Sheet1 and Sheet2 respectively) except that I get single blank lines in between the data rows! ...
 azizrasul General Coding Help 40 5,719 Nov-02-2022, 11:23 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Here's an alternative solution which works except that I get single blank lines in between the data rows! I've fiddled with the code to see why it's doing that, but nothing works.
 azizrasul General Coding Help 40 5,719 Nov-02-2022, 11:13 PM
    Thread: Debugger
Post: RE: Debugger
Thanks will repost if I still have an issue.
 azizrasul General Coding Help 6 1,196 Nov-02-2022, 09:46 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Many thanks, that worked.
 azizrasul General Coding Help 40 5,719 Nov-02-2022, 09:23 PM
    Thread: Debugger
Post: RE: Debugger
When I select the Debug tab at the bottom, it automatically jumps to the Run tab!
 azizrasul General Coding Help 6 1,196 Nov-02-2022, 09:14 PM
    Thread: Debugger
Post: RE: Debugger
I'm running it on Run mode. The breakpoint is on line 7. import openpyxl from openpyxl import load_workbook folder = 'D:/Power BI & Python/' file = 'Test_Data.xlsx' wb = openpyxl.load_workbook(...
 azizrasul General Coding Help 6 1,196 Nov-02-2022, 08:35 PM
    Thread: Debugger
Post: Debugger
I am using PyCharm to run my Python code. When I place a breakpoint on a line, the whole code runs through to the end? What can I be doing wrong. Note, I am a newbie.
 azizrasul General Coding Help 6 1,196 Nov-02-2022, 08:04 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Sheet1 Segment|Country|Product Enterprise|Canada|Montana Small Business|Mexico|Montana Sheet2 Segment|Country|Product Government|Peru|Paseo Channel Partners|France|Carretera Hope that helps. Just 3 ...
 azizrasul General Coding Help 40 5,719 Nov-02-2022, 07:44 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
I don't know how to attach a file here. However, here is the sample data. You can use a couple of lines. Thanks. Sheet1 Segment Country Product Discount Band Units Sold Manufacturing Price Sale ...
 azizrasul General Coding Help 40 5,719 Nov-01-2022, 11:51 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Thanks, will have a look at that tomorrow.
 azizrasul General Coding Help 40 5,719 Nov-01-2022, 11:33 PM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Still can't get any csv files from the code in post #14. I get no errors.
 azizrasul General Coding Help 40 5,719 Oct-30-2022, 01:25 AM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
deanhystad, included a workbook name and got it to work. Ta.
 azizrasul General Coding Help 40 5,719 Oct-30-2022, 01:23 AM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
'exit 0' in PyCharm means there was no error.
 azizrasul General Coding Help 40 5,719 Oct-30-2022, 01:17 AM
    Thread: Creating csv files from Excel file
Post: RE: Creating csv files from Excel file
Changed the .py file as suggested and I get exit 0 but no output files!
 azizrasul General Coding Help 40 5,719 Oct-29-2022, 08:33 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020