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....
command line data how-to

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...
con conference programming

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...
how-to programming python

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...
how-to notepad++ programming