Skip to content

Instantly share code, notes, and snippets.

View felixlindemann's full-sized avatar

Felix Lindemann felixlindemann

  • Lime-Tree
  • Wuppertal, Germany
View GitHub Profile
@felixlindemann
felixlindemann / setwd.r
Created January 16, 2014 10:57
set working directory to parent directory
setwd("/Volumes/Daten/FelixLindemann/Documents/git")
@felixlindemann
felixlindemann / foo.R
Created January 16, 2014 10:53
foo.r
foo <-
function(value) {
return (3+value)
}
@felixlindemann
felixlindemann / Marion Funk 2.r
Created January 10, 2014 12:54
Get.Reliabilitätssample
get.ReliabilitätsSample<-function(n , min , max , seed ){
set.seed(seed) # Wähle eine bestimmte Zufallszahlenliste aus --> Für Reproduzierbarkeit
x<-sample(min:max, n) # Ziehe eine Stichproben von n Elementen
return (x[order(x)]) # gib eine sortierte Liste zurück
}
n <- 30
min <- 1
max <- 576
@felixlindemann
felixlindemann / get.SampleSize.r
Created January 9, 2014 12:45
Ermittlung von Stichprobengrößen
# Based on formula by
# Cochran, W. G. 1963. Sampling Techniques, 2nd Ed., New York: John Wiley and Sons, Inc.
# see also http://statistikberatung.blogspot.de/2008/03/samplesizer-kostenloses-tool-zur.html
get.SampleSize <- function(N, Z, p, e){
n <- (
Z^2 * p * (1-p) / e^2
@felixlindemann
felixlindemann / testpi.py
Created September 29, 2013 19:43
test pi
from time import sleep
import RPi.GPIO as GPIO
GPIO.setmode(GPIO.BOARD)
gpios = {
1: "3.3 v",
2: "5.5 v",
3: "GPIO 0 (SDA)",
@felixlindemann
felixlindemann / getColumns.sql
Created September 9, 2013 09:10
Get All Columns from a table as Query.
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='TABLE_SCHEMA'
AND TABLE_NAME='TABLE_NAME';
@felixlindemann
felixlindemann / RMySQL-Select.r
Created August 26, 2013 15:58
RMySQL Select Statement
data.nst <- dbGetQuery(con, "select * from NST2007Abteilungen")
data.nst[,1:3]
@felixlindemann
felixlindemann / ConnectRMysql.r
Created August 26, 2013 15:52
Connect to database with RMySQL
library(RMySQL)
dbhost<-"192.168.0.104"
dbsuer<-"windowsparallels"
dbpass<-""
dbcatalog<-"db"
con <-dbConnect(MySQL(),
host=dbhost,
@felixlindemann
felixlindemann / installRMySQL.r
Created August 26, 2013 15:44
install RMySQL
install.packages('RMySQL',type='source')
library(RMySQL)
Option Compare Database
Public Sub createMySqlDump2()
Dim Filename As String
Filename = "Y:\mypath\myfilePrefix-" ' Tablename.sql will be attached
createMySqlDump Filename
End Sub