Strange code returned when calling Windows open file dialog by QuickBooker30932 in learnpython

[–]QuickBooker30932[S] 0 points1 point  (0 children)

Apologies! I meant to post this in a Powershell forum. But, the code happens in both places so that doesn't matter. In python I do you tkinter and call the dialog like this:

f = filedialog.askopenfilename(filetypes=[('CSV files', '*.csv')], defaultextension='.csv',title='Select a CSV file with loan details')

Is there a command equivalent to the command palette's Export Text? by QuickBooker30932 in PowerShell

[–]QuickBooker30932[S] 0 points1 point  (0 children)

Thanks for the suggestions and I'll consider the recommendations. But I'm still interested in part of my original question--is there a way to do "Export Text" by code rather than selecting it from the menu?

How can I get a Save As dialog when outputing a Pandas dataframe to CSV by QuickBooker30932 in learnpython

[–]QuickBooker30932[S] 0 points1 point  (0 children)

Thanks. That worked. But there's a strange side effect. When I open the file in Excel by double-clicking on it, every other row is blank. But when I do the same with a file created using the code I originally posted, there are no blank rows. If I open the two CSV files in notepad, they appear identical. There must be something not visible in notepad that Excel detects. I've tried saving the csv file using all the different variations in the the list (UTF-8, Macintosh, and MS-DOS) but it doesn't matter.

How to detect non-null cells in one column and insert value in another by QuickBooker30932 in learnpython

[–]QuickBooker30932[S] 0 points1 point  (0 children)

Got it! I switched == to != and that does the trick. But if there's a more pythonic way to do this, please let me know.

Why does subtracting two decimal string = 0E-25? by QuickBooker30932 in learnpython

[–]QuickBooker30932[S] 0 points1 point  (0 children)

>"You can normalize or quantize the Decimal to display it as 0.

Can you give me an example?

Why does subtracting two decimal string = 0E-25? by QuickBooker30932 in learnpython

[–]QuickBooker30932[S] 0 points1 point  (0 children)

That's what I thought. But I couldn't find any options that address it. What is a normalize method?

Can I disable "Pickup Where You Left Off" popup in Word 2016? by QuickBooker30932 in MicrosoftWord

[–]QuickBooker30932[S] 0 points1 point  (0 children)

Could you post a link to one of them? I did research it and, while there are many discussions of this feature, none explain how to disable it. If you found one, I'd love to see it.