- Home
- Tag: column
Posts tagged column
Column – A single unit of named data that has a particular data type (e.g., number, text, or date). Columns only exist in tables.
Tag: column
Excess Deaths February Update
Feed: R-bloggers. Author: R on kieranhealy.org. [This article was first published on R on kieranhealy.org, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. The CDC continues to update its counts of deaths by cause for 2020 as data comes in from the jurisdictions that report to it. The data are by now fairly complete, though there are still significant gaps in several states due to delayed reporting. North Carolina, in particular, has yet ... Read More
Make way for the High Performance Parallel Dump & Load Utilities + How to use them

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More
SAS graphs for R programmers – bubble maps

Feed: SAS Blogs. Author: Robert Allison. This is another in my series of blog posts where I take a deep dive into converting customized R graphs into SAS graphs. Today we'll be working on bubble maps - specifically, plotting earthquake data as bubbles on a map. R bubble map, created using geom_polygon() and geom_point() SAS bubble map, created using Proc SGmap My Approach I will be showing the R code (in blue) first, and then the equivalent SAS code (in red) that I used to create both of the maps. Note that there are many different ways to accomplish the same things in ... Read More
MySQL Query Profiling Using Performance Schema

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction In this article, I’m going to explain how to do query profiling using the MySQL Performance Schema. The Performance Schema has been available since MySQL 5.5.3 and allows MySQL to instrument SQL queries and store their trace information in various tables that you can later inspect in order to determine why a given SQL statement is slow. On older versions of MySQL, you might have used the SHOW PROFILE command, but since this feature has been deprecated, you should now use the Performance Schema for SQL query profiling. Enabling the MySQL Performance Schema ... Read More
Quantifing changes of spatial patterns
Feed: R-bloggers. Author: Rstats on Jakub Nowosad's website. TLTR: Quantifing changes of spatial patterns requires two datasets for the same variable in the same area. Both datasets are divided into many sub-areas, and spatial signatures are derived for each sub-area for each dataset. Next, distances for each pair of areas are calculated. Sub-areas with the largest distances represent the largest change. To reproduce the calculations in the following post, you need to download all of relevant datasets using the code below: library(osfr) dir.create("data") osf_retrieve_node("xykzv") %>% osf_ls_files(n_max = Inf) %>% osf_download(path = "data", conflicts = "overwrite") You should also attach the ... Read More
January 2020: “Top 40” New CRAN Packages
Feed: R-bloggers. Author: R Views. [This article was first published on R Views, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Two hundred thirty new packages made it to CRAN in January. Here are my “Top 40” selections in ten categories: Data, Finance, Genomics, Machine Learning, Medicine, Science, Statistics, Time Series, Utilities, and Visualization. Data igoR v0.1.1: Provides tools to extract information from the Intergovernmental Organizations (‘IGO’) Database , version 3, provided by ... Read More
Doing Row-wise Operations the Column-wise Way With tidyr pivot_longer
Feed: R-bloggers. Author: Pascal Schmidt. [This article was first published on R, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Row-wise operation always feel a bit strange and awkward to me. At the same time they are really fascinating as well because we mostly deal with column-wise operations. In this blog post, we will be going through a #tidytuesday data set that is about plastic and we will be doing row-wise operations the ... Read More
Point-In-Time Recovery in Kubernetes Operator for Percona XtraDB Cluster – Architecture Decisions

Feed: Planet MySQL; Author: MySQL Performance Blog; Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) added support for PITR in version 1.7, and in this blog post we are going to look into the technical details and decisions we made to implement this feature. Architecture Decisions Store Binary Logs on Object Storage MySQL uses binary logs to perform point-in-time recovery ... Read More
Introducing JumpeR – For Track and Field Data
Feed: R-bloggers. Author: Welcome to Swimming + Data Science on Swimming + Data Science. Introducing JumpeR – For Track and Field Data | R-bloggers % bold(part = "header") %>% # bolds header bg(bg = "#D3D3D3", part = "header") %>% # puts gray background behind the header row autofit() } What does JumpeR do? JumpeR is very similar to SwimmeR. They both mostly serve to convert results from human readable documents to machine & human readable data frames in the context of the R programming environment. Supported Results Format JumpeR currently supports single column Hy-Tek results, like these, and Flash Results ... Read More
SAS graphs for R programmers – paneled graphs

Feed: SAS Blogs. Author: Robert Allison. This is another in my series of blogs where I take a deep dive into converting customized R graphs into SAS graphs. Today I show how to combine several graphs with shared axes, which we'll call paneled graphs. This time I'll be plotting the Job Openings Rate by Industry, similar to how Len Kiefer graphed them in this Twitter post. Len is always posting interesting (and nice looking) graphs, and was kind enough to share his R code, which I consulted while creating my R graph. Thanks Len! R paneled graphs, created using geom_bar() ... Read More
Recent Comments