Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Python is one easy / flexible way to wrangle Excel files


Yes, there are multiple Python libraries for wrangling Excel files as well as good built-in CSV support via the stdlib's csv module - which, despite its name, can actually support DSV (Delimited Separated Values), which is a generalization of CSV. The csv module also has a dialects feature with attributes like settable delimiters (which is how you get the DSV support) and quoting. And since Python's built-in data structures like lists, dicts, tuples and sets are great for munging data, you can get a lot done with just that, plus the benefit of Python's readability and productivity.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: