If you are following my progress in the Data Science Learning Club you might know that I am using NFL data for the tasks. For predicting sports events I think it is not only important to have statistics about the players, teams and previous games but also about the weather. From when I was a … Continue reading Use rvest to scrape NFL weather data
Category: Tech & Science
Learning Club 01: Find and explore a dataset
The first activity of the data science learning club I am participating in is to find and explore a dataset. I already described the data I found and will use in the last post. You can follow all my learning club related activities here. The tasks of this activity are (quoted from the thread above): … Continue reading Learning Club 01: Find and explore a dataset
Learning Club 00.b: Setup your development environment (Get started with python package nfldb)
So, just a few days ago I posted Learning Club 00: Set up your development environment (Getting started with R). There I made a mistake and decided to use R without thinking about the data set I would use. I am still happy I wrote the post because it can give all the R users … Continue reading Learning Club 00.b: Setup your development environment (Get started with python package nfldb)
Learning Club 00: Set up your development environment (Getting started with R)
A few weeks ago I became aware of Renee’s (owner of the blog Becoming a data scientist) plan to start a data science learning club and I thought it was a cool idea. In the learning club she will post activities and the first one was about setting up your development environment: Activity 00: Set … Continue reading Learning Club 00: Set up your development environment (Getting started with R)
Downgrading an ETL project from SSIS 2014 to SSIS 2012
Recently I came into the situation that I had a SSIS package built with Visual Studio 2013 and SQL Server Data Tools (SSDT) 2014 which should be deployed to SQL Server 2012. Running the packages from Visual Studio 2013 and inserting data in a database on SQL Server 2012 worked, it also worked to deploy … Continue reading Downgrading an ETL project from SSIS 2014 to SSIS 2012
Microsoft Product Launch @ K.47 in Wien
Vor wenigen Wochen haben Patrick und ich eine Einladung zum Microsoft Product Launch in Wien bekommen (danke Ambassador Base!). Deshalb haben wir uns am Dienstag, den 17.11. früh morgens Richtung Wien aufgemacht. Dort haben wir uns mit einer Freundin und Patrick’s Cousine getroffen und das Katzencafé Neko besucht (das hat sich allerdings einen eigenen Post … Continue reading Microsoft Product Launch @ K.47 in Wien
How the Surface 3 replaced my MacBook Pro as my main device
As some of you might already know some weeks ago I won the Surface 3 and already wrote that I loved it. Since then the Surface 3 has more and more replaced my MacBook Pro and in this post I’ll tell you the reasons why. Status Quo To give you a short insight in my … Continue reading How the Surface 3 replaced my MacBook Pro as my main device
![[Howto] Using Google URL builder, Google Analytics and R to create trackable QR codes](https://www.katzentante.at/wp-content/uploads/2015/10/qrcode_ga.png)
[Howto] Using Google URL builder, Google Analytics and R to create trackable QR codes
Some time ago I needed a QR code for a project and also wanted to find out how many people used that QR code. Googling returns many, many options, too many in my opinion. Each web site has different features, some provide counters, every web site has different data types you can export (from bad … Continue reading [Howto] Using Google URL builder, Google Analytics and R to create trackable QR codes
[SSIS tips] Error when file path variable is not set at design time
A few weeks ago I had to create a foreach container in an ETL package to loop over subdirectories of a folder. There are many tutorials out there for this purpose: microsoft-ssis.blogspot.co.at blogs.msdn.com/b/changliw/ In each iteration of the loop some files of each subdirectory where read. And since the path of these files were created … Continue reading [SSIS tips] Error when file path variable is not set at design time
Add non-overlapping labels to a plot using {wordcloud} in R
Several times when I create a plot I want to add labels for some dots directly on the plot. For this purpose I have looked for a solution to do this, because implementing it with text would probably take a lot of work. Luckily I found this two links: [stackoverflow] How do I avoid overlapping … Continue reading Add non-overlapping labels to a plot using {wordcloud} in R