Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ggrothendieck
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
31.
▲
by
ggrothendieck
10y ago
There is also the iCompare trial which is underway and to be completed in 2019.
32.
▲
by
ggrothendieck
10y ago
The ACALM study found an association between high cholesterol and sharply reduced risk of death from 4 cancers. The numbers were large -- 22%, 43%, 47% and 30% lower risk of death. This may be due to wide-spread use of statins among those
33.
▲
by
ggrothendieck
10y ago
Actually the sqldf R package supports 4 backend databases (sqlite, h2, postgresql, mysql), not just sqlite, and postgresql does support window functions.
34.
▲
by
ggrothendieck
10y ago
The HN title misquotes the actual FTC site's title. The FTC title says it "failed to adquately disclose", not that it "failed to disclose". Omitting the word adequately changes the meaning substantially. In fact,
35.
▲
by
ggrothendieck
11y ago
The author of the Checklist Manifesto also wrote an article about this in the New Yorker: http://www.newyorker.com/magazine/2007/12/10/the-checklist
36.
▲
by
ggrothendieck
11y ago
The abstract of this paper provides a good summary: http://www.ncbi.nlm.nih.gov/pubmed/26504236
37.
▲
by
ggrothendieck
11y ago
> Is there a similar site that does the same for climate change? It's not in Q&A form but NASA's site summarizes what is known: http://climate.nasa.gov/evidence/
38.
▲
by
ggrothendieck
11y ago
The image beside each node is nice but the meaning of the edges needs to be well defined for this chart to be useful. An interactive graphic of 76 probability distributions which does define the edges and also links each node to a descript
39.
▲
by
ggrothendieck
11y ago
The following link is another review of the same book by Paul Mason http://www.paecon.net/PAEReview/issue73/Gillies73.pdf but it focuses more on the economic idea, apparently discussed in his book, that the digita
40.
▲
by
ggrothendieck
11y ago
The link is set to start at 3:22 but its the whole Humans video if you start from the beginning.
41.
▲
by
ggrothendieck
11y ago
This video discusses horse unemployment and more: https://www.youtube.com/watch?v=7Pq-S557XQU&t=3m32s
42.
▲
by
ggrothendieck
11y ago
For R: (1) instead of `sapply(nba, mean, na.rm = TRUE)` use `colMeans(nba, na.rm = TRUE)`. (2) instead of `nba[, c("ast", "fg", "trb")]` use `nba[c("ast", "fg", "trb")]`, (3) inste
43.
▲
by
ggrothendieck
11y ago
Enter the disease name in google and one of the first results will likely be the medical association that deals with the disease. Check out its web site. Others in the same situation are a good source of info so google for the disease nam
44.
▲
by
ggrothendieck
11y ago
Regarding quoting support, check out https://github.com/dbro/csvquote
45.
▲
by
ggrothendieck
11y ago
Not the same but there exists a microphone which can be thought of as an audio version of this: https://www.acousticmagic.com/ It senses the direction of the speaker and outputs audio from that direction filtering out audio
46.
▲
by
ggrothendieck
11y ago
Regarding rice, Consumer Reports (CR) has been urging the FDA to set limits on rice consumpton due to the arsenic levels in rice that they have measured. A certain amount of this is due to naturally occurring arsenic but pollution from ind
47.
▲
by
ggrothendieck
12y ago
Note link between Yerba Mate and esophageal cancer: http://www.ncbi.nlm.nih.gov/pmc/articles/PMC3947123/ and http://preventcancer.aicr.org/site/News2?page=NewsArticle&id...
48.
▲
by
ggrothendieck
12y ago
Leonard Cohen managed to monetize his poetry through his music.
49.
▲
by
ggrothendieck
12y ago
There is a site and free self published e-book of about 60 pages (hard copy is available too) on an IF diet in which one fasts for all but 5 hours a day for the purpose of weight loss. The book describes the author as a retired medical doct
50.
▲
by
ggrothendieck
12y ago
The fact that species with more cells don't get more cancer is known as Peto's paradox. Perhaps it is also true at the tissue level. See http://en.wikipedia.org/wiki/Peto%27s_paradox
51.
▲
by
ggrothendieck
12y ago
Over the years that I have looked at Science Daily it has always provided sources and citations. I don't think there has been any change.
52.
▲
by
ggrothendieck
12y ago
This is a bit harsh on Science Daily. In fact, Science Daily is much better than many other sites of its kind because it does consistently give its sources and provides citations as it did here.
53.
▲
by
ggrothendieck
12y ago
To be clear this applies to data frames, not the language as a whole. If you are creating a data frame by reading in data then `read.table(...whatever..., as.is = TRUE)` will read in character columns as character strings and not as factor
54.
▲
by
ggrothendieck
12y ago
(!) sqldf works with H2, MySQL and PostgreSQL too - its not limited to SQLite. (2) Most alternatives to SQL available in R don't work well with complex multi-way joins. You wind up materializing the full outer join first which can be
55.
▲
by
ggrothendieck
12y ago
To run a python function you do need to write one line of VBA code and you also need a vba file that comes with the package so although its not very much to add on the VBA side the title here seems a bit misleading.
56.
▲
by
ggrothendieck
13y ago
The R package sqldf together with backend packages RSQLite (the default), RH2, RMySQL and RPostgreSQL can be used in a somewhat similar manner automatically generating create statements, uploading referenced tables to a database and perfor