Rapture in Everything

Posts tagged "python"

csv-to-sqlite - copying from CSV files to a SQLite database

csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....

PyCon SK 2016

The famous PyCon came to Slovakia for the first time. Quite frankly: I’m impressed. For those who don’t know: PyCon means Python Conference, and it’s meant for anyone interested in the programming language. I can’t say I have much experience with community-organized dev events, but the organizers clearly did their homework. I’m not exactly an avid tweeter, but I couldn’t resist: It was obvious immediately after entering #PyConSK that I hadn't seen this many nerds in one place in quite a while. I've missed it. — zblesk (@zblesk) March 11, 2016 That was prompted by...

WinPython doesn't start?

I ran across PyBrain, a “modular machine learning library for Python.” It needs the whole Scientific Python stack and since setting it up manually seemed like a pain, I decided to try one of the pre-packaged distributions. I tried more of them with little success. WinPython looked the best, but didn’t work on the two computers I tried it on, regardless of version or bitness. When I tried running the WinPython Control Panel, Spyder or IPython, the program either just didn’t start (the first one) or briefly flashed a console window without anything useful in it and died...

Scripted text processing

When working on the last project at work, my tasks were often defined poorly. I had to make web services that would accept complicated data structures, but I only had one example file to go by. The file got updated from time to time, but never came as a valid XML – some can hardly be convinced you can’t just write strings instead of numbers or put a “-” anywhere in the file and expect it to be valid. So I had to process every file by hand. And by “hand”, I of course mean regexes or Python, just as...