I want to export sql query result to excel file using Python. I queried the DB and able to retrieve the result set.Currently what im facing is like.Not able write the query result to Excel, Here is my Code, When im running this code,its skipping to the except block.Is there anyway to figure out the issue? …
Tag: excel
save data to new worksheet, in existing workbook using python
created a new dataframe named df3 and saved to excel workbook named masterdata.xlsx, later created another dataframe named table when I try to write that dataframe to sheet2 of masterdata.xlsx, it overrighted the first created dataframe. masterdata.xlsx have two sheets, sheet1 and sheet2. sheet1 have some dat…
Error while trying to get ReceivedTime from Win32com Python bib
I’m receiving an error while I’m trying to save a code that gets an outlook’s mail receivedTime. But I don’t know what possibly could done wrong. See the error below: Can anyone help me? The code: Answer The MailItem.ReceivedTime property returns a Date indicating the date and time at …
creating pandas function equivalent for EXCEL OFFSET function
Let’s say input was I want to create an additional column that looks like this: Basically each number in offset is telling you the number of columns to sum over (from col1 as ref point). Is there a vectorized way to do this without iterating through each value in offset? Answer You use np.select. To use…
Add pivot table in excel with python
I am trying to add a pivot table in excel using python script with pandas but not able to do so. I won’t to count number of missed and met entries for each priority. Excel script: Excel data: Priority SLA p1 Met p2 Missed p3 Missed p2 Missed p3 Missed desired output: Priority Met Missed p1 1 0 p2 1
Preserve formatting during excel file split with python
Hi I’m starting with python and have a question that sounds pretty simple, but at this point I don’t know how to solve it. I have a code for splitting some reports by columns. Unfortunately, I noticed that the format in output files changes during the split compared to the master file. __ Dates fo…
Find a Excel file in directory, compress and send it to another folder
I have an Excel file WK6 that is downloaded in the below folder: The Python script should first navigate till the above directory and then find the excel file WK6 (the name of the excel file changes as per week) and compress it. Then move it to some other directory. Please help me understand how can I find an…
df.drop does not work properly, pandas python
I have this excel file that I would like to “normalize” with the below code by dropping the A and B columns and then dropping the Rows 1,2,3,5 and making the row 4 as header. But I keep getting this weird df that I dont understand the reason why Also: Answer You must explicitely set the column nam…
split a workbook into different workbooks with worksheets using python pandas
I have a list of transactions from the last 7 years in one big excel file. I m trying to create an excel workbook for each year that includes each months as worksheet. Im using a column called ‘date’ that has each transactions recorded as MM/DD/YYY. I split that column to single out my years and m…
Plotting barchart in Excel with Python, dynamic categories
I try to get a chart in Excel using Python. The code below works for now but next month a new line will be added. As you can see I now only select until line 64 (categories and values) so if I want to add the next month to the chart, I have to change 64 into 65. Is there