data management Evaluating Google Cloud Spanner and BigTable – Engineering Fitness 11 Mar 2020 Good summary on BigTable vs Google Cloud Spanner. In short, use Cloud Spanner for relational style database and query when you have extremely large data. BigTable might be less efficient…
data management… Data Governance Framework 23 Sep 2019 Data Governance Framework publish by Thai DGA. — Read on www.dga.or.th/th/profile/2108/
data management… Import data from Excel to R using gdata library 31 Jan 201722 Jan 2017 There are several ways to import data into R. The standard way, what it used to be, is from a text file using read.table() function. For excel files, the most…
data management… Transpose Table Sideway 1 Nov 20151 Nov 2015 I've come across a problem needing to transpose to wide table into a long format. I'm not talking about the longitudinal data quite yet, the one where you have one…
data management… UCSC genome browser human gene location? 2 Jul 201215 Jul 2012 To download UCSC RefSeq Gene info with HUGO gene name, start and stop codon or transcription start-end site, locate the refflat.txt.gz file on the annotation database - Hg18: http://hgdownload.cse.ucsc.edu/goldenPath/hg18/database/refFlat.txt.gz -…
data management… Convert plink format to vcf 6 Apr 201211 Apr 2012 So, I recently got to work with vcf file format for the first time. It is been quite a mess to start with, but after all the helps I can…
data management… R FAQ: How can I format a string containing a date into R “Date” object?? 5 Apr 20125 Apr 2012 This sounds like a problem that statisticians occasionally have to deal with. It is quite simple, just convert the string to date or time if you remember what command to…
bash… Calculating heritability using SOLAR 11 Mar 2012 As a not to myself, I occasionally have to do this occasionally. This time, simply preparing file for calculation of heritability in SOLAR. This is based on a variance-component analysis,…
bash… Print from here to there with “awk” 29 Sep 201111 Mar 2012 This does sound like a common thing to do. You have a length text file that you only want to get some part of it. For example, I have a…
data management… Convert Column to Table in Excel 17 Aug 2011 Copy and paste is pretty simple and easy to do, but it is sometimes more error prone than writing a function to do it (that assumes the function written does…
You must be logged in to post a comment.