python

Quick and easy file dialog in Python?

by

I have a simple script which parses a file and loads it’s contents to a database. I don’t need a UI, but right now I’m prompting the user for the file to parse using raw_input which is most unfriendly, especially because the user can’t copy/paste the path. I would like a quick and easy way to present a file selection dialog to the user, they can select the file, and then it’s loaded to the database. (In my use case, if they happened to chose the wrong file, it would fail parsing, and wouldn’t be a problem even if it was loaded to the database.)

How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?

by

I need to create a data frame by reading in data from a file, using read_csv method. However, the separators are not very regular: some columns are separated by tabs (t), other are separated by spaces. Moreover, some columns can be separated by 2 or 3 or more spaces or even by a combination of spaces and tabs (for example 3 spaces, two tabs and then 1 space).

How to prevent numbers being changed to exponential form in Python matplotlib figure

by

I’m using Matplotlib in Python to plot simple x-y datasets. This produces nice-looking graphs, although when I “zoom in” too close on various sections of the plotted graph using the Figure View (which appears when you execute plt.show() ), the x-axis values change from standard number form (1050, 1060, 1070 etc.) to scientific form with exponential notation (e.g. 1, 1.5, 2.0 with the x-axis label given as +1.057e3).