HNHacker News
TopNewBestAskShowJobs

danpelota

51 karma · joined January 28, 2015

submissionscomments
danpelota··on "None of These Books Are Obscene": Judge Strikes Down Much of FL's Book Ban Bill
Ezekiel 23:20 - "There she lusted after her lovers, whose genitals were like those of donkeys and whose emission was like that of horses."
danpelota··on Show HN: Visual SQL
I don't know about embedding, but I've been happy with the Metabase UI for building these kinds of queries:

https://www.metabase.com/docs/latest/users-guide/custom-ques...

danpelota··on Comprehensive Guide on Data Visualization with Pandas
On occasion, I've fired up pandas just to sanitize a CSV file and drop malformed rows as preparation to bulk ingesting into a database:

  import pandas as pd
  pd.read_csv('bad_file.csv', error_bad_lines=False).to_csv('good_file.csv')
It's not efficient (reads everything into memory), but read_csv is robust when it comes to handling embedded unescaped quotes/commas/etc., and supports dropping rows with the incorrect number of columns due to anomalies it can't handle.
danpelota··on Github search sucks (and how it could be better)
Unfortunately, you can search code by file extension and phrase, and you can use advanced search to search for repository descriptions filtering by stars, but I don't believe you can do both at once.

For instance, searching for "flask" and limiting the results to >1000 stars returns only the 27 repositories with a matching description[0], but the code search returns over 4 million results, ignoring the stars parameter[1].

https://github.com/search?l=&q=flask+stars%3A%3E1000&ref=adv...

https://github.com/search?l=&q=flask+stars%3A%3E1000&ref=adv...

danpelota··on Github search sucks (and how it could be better)
I would love to be able to search all code for a string and then either (1) sort the resulting repositories by stars/forks; or (2) limit the results to repositories with >X stars/forks. When learning a new framework or library I like to find popular projects that use it and read the code to get a sense of conventions, architecture, etc. For instance, it'd be fantastic to find all repositories with over 20 stars containing a *.py file with "import flask" or "from flask" in them.
danpelota··on Ask HN: Are there any systematic and scientific ways to develop a habit?
In addition, I haven't seen the third step in the "Cue -> Habit -> Reward" cycle mentioned yet. While the Reward may be the lingering endorphin rush from a hard workout or the feeling of accomplishment after finishing a chore, the author also suggests a simple, pleasurable behavior after the task that you're trying to make a habit of (like a small piece of chocolate immediately after a run or allowing yourself a few shameless minutes of cat videos after a focused study session). The idea is to allow your mind to associate the pleasure response with the habit each time it encounters the cue.
danpelota··on Europol chief warns on computer encryption
Really, we need to be rethinking the legality of combination safes and deadbolt locks - they're being leveraged in terrorist operations as well.