Google Spreadsheet Query Function: Use real SQL on your spreadsheets


Just like this: =query(Yevmiye!$A$2:$I$1004;“select sum(H) WHERE D=’”&A11&“’ label sum(H) ”“) D is a column head. Ignore label statement. Sum(H) is the column which will be subject of query. The formula gives sometimes #N/A due to result of SQL query is null. To be able to overcome it just wrap your function with iferror(param1,param2) function. if…

Python for your digital errands


A programming language mostly considering as highly holy and celestial. No programmers want to do a trivial task with a programming language. For instance, there is no Java developer which resizes his photos with Java. However, for Python something is different. Due to its clear looking, you can perform some of your daily tasks with…

Apply Function in R: Apply same function to for each cell of a matrix


R provides powerful functions. Apply function is one of them. It keeps you from writing boring loops(while and for). For insance: # create a matrix of 10 rows x 2 columnsm <- matrix(c(1:10, 11:20), nrow = 10, ncol = 2) # divide all values by apply apply(m, 1:2, function(x) x/2) Thanks for nsaunders

Google Spreadsheet Query Function Makes your Spreadsheets DB which SQL-ready


When you want to make complex queries over Excel sheet that is almost impossible. Yet by Google Docs Spreadsheet Query() function you  can write SQL and retrieve whatever you want. For instance: =query(A2:I1000;“select sum(H)  WHERE D=‘mrkt’”)  Gets only expenditures which about ‘mrkt’ (market) from A2:ı10000 TABLE then gets sum. When you write function by this way,…