Tag: column

Feed: R-bloggers. Author: rOpenSci - open tools for open science. Sharing data sets for collaboration or publication has always been challenging, but it’s become increasingly problematic as complex and high dimensional data sets have become ubiquitous in the life sciences. Studies are large and time consuming; data collection takes time, data analysis is a moving target, as is the software used to carry it out. In the vaccine space (where I work) we analyze collections of high-dimensional immunological data sets from a variety of different technologies (RNA sequencing, cytometry, multiplexed antibody binding, and others). These data often arise from clinical ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Many of you already know how to retrieve the size of your dataset, schemas and tables in MySQL. To summarize, below are the different queries you can run: Dataset Size I the past I was using something like this : But now with sys schema being installed by default, I encourage you to use some of the formatting functions provided with it. The query to calculate the dataset is now: SELECT sys.format_bytes(sum(data_length)) DATA, sys.format_bytes(sum(index_length)) INDEXES, sys.format_bytes(sum(data_length + index_length)) 'TOTAL SIZE' FROM information_schema.TABLES ORDER BY data_length + index_length; Let’s see an example: Engines Used and ... Read More

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; MySQL 8 is GA and it has a variety of new features. Recently, we happened to work with resource groups to restrict resource utilization for a MySQL thread. That’s why I thought of writing this blog post: to give you a quick introduction to resource groups, an idea of how to dynamically allocate them and to discuss a related bug report. Introduction To Resource Groups: A resource group, a new feature in MySQL 8, is the entity that defines the allowed resources consumption for threads pertaining to that group. Group attributes enable control over resources ... Read More

Feed: R-bloggers. Author: Adnan Fiaz. Nowadays whenever I do my work in R there is a constant nagging voice in the back of my head telling me “you should do this in Python”. And when I do my work in Python it’s telling me “you can do this faster in R”. So when the reticulate package came out I was overjoyed and in this blogpost I will explain to you why. re-tic-u-late (rĭ-tĭkˈyə-lĭt, -lātˌ) So what exactly does reticulate do? It’s goal is to facilitate interoperability between Python and R. It does this by embedding a Python session within the R session which enables ... Read More

Feed: R-bloggers. Author: Tim Bock. Explore 3D Correspondence Analysis! Back in the “olden days” of the 1970s it was apparently not unknown for statisticians to create 3D visualizations using tinkertoys. For some inexplicable reason, the advent of the PC led to a decline in this practice, with the result that 3D visualizations are now much less common. However, it is possible to create 3D-like visualizations digitally. Although they only show two dimensions at any one time, the user can understand the third dimension by interacting with the visualization. In this post I use Plotly’s excellent plotting package to create an interactive, 3D ... Read More

Feed: Planet MySQL; Author: Ivan Ma; MySQL Document Store Building Index SearchThis is a tutorial to go through setting Up MySQL 8.0 Document Store, Importing World_x Sample database and building GENERATED COLUMN with Index and lastly to show the QUERY PLAN using collection.find() that uses the INDEX built.INSTALLATION Pre-requisite 1. MySQL 8.0.11+ 2. MySQL Shell 8.0.11+ 3. Download  Sample Database "world_x database" from https://dev.mysql.com/doc/index-other.htmlMySQL Database Initialization   Using --initialize-insecure for this tutorial which means it initializes a database with empty password for root@localhost user. Assuming we have 'mysql', 'mysqld' setup properly.mysqld --initialize-insecure --datadir=Create my.cnf  (example E:/temp/data1/my.cnf)Startup MySQL Server  Connecting to MySQL ... Read More

Feed: Planet MySQL; Author: Øystein Grøvlen; One of the new JSON functions in MySQL 8.0 is JSON_TABLE. It is also MySQL’s first table function. That is, the return value is not a scalar value, but a result set. JSON_TABLE will convert (part of) a JSON document into a relational table. In this blog post, I will show you how to do this and discuss how JSON_TABLE enables new ways of processing JSON data with SQL. JSON_TABLE Example First, I will create a table t1 with a column of type JSON and insert a single JSON document into this table: CREATE ... Read More

Feed: R-bloggers. Author: Econometrics and Free Software. In a previous blog post I have showedhow you could use the {tidyxl} package to go from a human readable Excel Workbook to a tidydata set (or flat file, as they are also called). Some people then contributed their solutions,which is always something I really enjoy when it happens. This way, I also get to learn things! @expersso proposed a solution without {tidyxl}: Interesting data wrangling exercise in #rstats. My solution (without using {tidyxl}): https://t.co/VjuOoM82yX https://t.co/VsXFyowigu — Eric (@expersso) September 12, 2018 Ben Stenhaug also proposed a solution on his githubwhich is simpler ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | September 13, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Server for MongoDB, Percona Server for MySQL, Percona Toolkit PREVIOUS POST Percona announces the release of Percona Toolkit 3.0.12 on September 13, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona Toolkit supports Percona Server for MySQL, MySQL®, MariaDB®, Percona Server for MongoDB and ... Read More

Feed: Planet big data. Author: David Smith. President Trump is once again causing distress by downplaying the number of deaths caused by Hurricane Maria's devastation of Puerto Rico last year. Official estimates initially put the death toll at 15 before raising it to 64 months later, but it was clear even then that those numbers were absurdly low. The government of Puerto Rico commissioned an official report from the Millikan Institute of Public Health at George Washington University (GWU) to obtain a more accurate estimate, and with its interim publication official toll stands at 2,975.  Why were the initial estimates so low? I read ... Read More