Data Science Blogs around the Interwebs

So many great data science/machine learning blogs, so little time!

Company Blogs

http://googleresearch.blogspot.com.au/

https://research.facebook.com/blog/ai/
https://research.facebook.com/blog/datascience/

https://blog.twitter.com/data

http://data.quora.com/

https://engineering.linkedin.com/big-data
http://blog.linkedin.com/topic/economic-graph/

http://www.ebaytechblog.com/category/machine-learning/

http://blogs.aws.amazon.com/bigdata/

http://nerds.airbnb.com/data/

https://codeascraft.com/category/data/  (Etsy)

http://blog.kaggle.com/


Personal Blogs

http://blog.echen.me/ (Edward Chen)

http://fastml.com/ (Zygmunt Zając)

http://flowingdata.com/ (Nathan Yau)

http://simplystatistics.org/ (Jeff Leek, Roger Peng, and Rafa Irizarry)

http://hunch.net/ (John Langford et al.)

http://www.walkingrandomly.com/ (Mike Croucher)


Aggregators and other links

http://www.r-bloggers.com/

https://www.reddit.com/r/machinelearning

http://www.datatau.com/

http://stats.stackexchange.com/

Excel Macro to apply data filter, autosize cols etc

I've been working with a lot of hadoop output files lately and inspecting the top results with Excel.

Consequently this is a useful Excel macro to prepare the data for browsing - Applies data filter for sorting, bold headings, freeze top row, autosize columns.

Good to map it to Ctrl + Shift + D as well.


Sub ApplyDataFilter()
'
' Excel 2013 ApplyDataFilter Macro
' Applies data filter, bold headings, freeze top row, autosize columns.
'
    Rows("1:1").Select
    Selection.Font.Bold = True
    With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 1
    End With
    ActiveWindow.FreezePanes = True
    Cells.Select
    Selection.AutoFilter
    Range("A2").Select
   
    Cells.Select
    Cells.EntireColumn.AutoFit
End Sub

Background download of wikipedia dump on Linux

A handy way to download a wikipedia dump in the background in such a way that it continues after ending a terminal session:

$ nohup wget -bqc http://dumps.wikimedia.org/enwiki/20140707/enwiki-20140707-pages-articles-multistream.xml.bz2

Latest wiki dump url can be found here:
http://dumps.wikimedia.org/backup-index.html

References:
http://www.cyberciti.biz/tips/nohup-execute-commands-after-you-exit-from-a-shell-prompt.html
http://www.cyberciti.biz/tips/linux-wget-your-ultimate-command-line-downloader.html