Tag: column

Feed: R-bloggers. Author: John Mount. As of cdata version 1.0.8 cdata implements an operator notation for data transform. The idea is simple, yet powerful. First let’s start with some data. d wrapr::build_frame( "id", "measure", "value" | 1 , "AUC" , 0.7 | 1 , "R2" , 0.4 | 2 , "AUC" , 0.8 | 2 , "R2" , 0.5 ) knitr::kable(d) 1 AUC 0.7 1 R2 0.4 2 AUC 0.8 2 R2 0.5 In the above data we have two measurements each for two individuals (individuals identified by the "id" column). Using cdata‘s new_record_spec() method we can capture a description ... Read More

Feed: R-bloggers. Author: Ryan Sheehy. Hugo Bowne-Anderson, the host of DataFramed, the DataCamp podcast, recently interviewed Debbie Berebichez, a physicist, TV host and data scientist and is currently the Chief Data Scientist at Metis in NY. Hugo: Hi there, Debbie, and welcome to DataFramed. Debbie: Hi, Hugo. It’s a pleasure of mine to be here. Hugo: It is such a pleasure to have you on this show, and I’m really excited to be here today to talk in particular about critical thinking in data science, and what that actually means, and as we know, to get critical about critical thinking ... Read More

Feed: Teradata Blog. Have you ever gone on an unscripted road trip?  You know your desired destination, but you decide on the details of your route as you travel along. Is the scenic by-way jammed with tourists?  Is there road work up ahead?  No problem. You just adapt to the unexpected conditions and consider alternate ways to get to your destination.After going on a few road trips where everything was planned in advance, I have learned the hard way that it is better to stay flexible and open to adapting to the conditions that arise along the way. Taking a ... Read More

Feed: R-bloggers. Author: Laran Ikal. Introduction: We will identify anomalous products on the production line by using measurements from testing stations and deep learning models. Anomalous products are not failures, these anomalies are products close to the measurement limits, so we can display warnings before the process starts to make failed products and in this way the stations get maintenance.  Before starting we need the next software installed and working: – R language installed.– All the R packages mentioned in the R sources.– Testing stations data, I suggest to go station by station.– H2O open source framework.– Java 8 ( ... Read More

Feed: R-bloggers. Author: Peter Prevos. The post Decode Lyrics in Pop Music: Visualise Prose with the Songsim algorithm appeared first on The Lucid Manager. Music is an inherently mathematical form of art. Ancient Greek mathematician Pythagoras was the first to describe the logic of the scales that form melody and harmony. Numbers can also represent the rhythm of the music. Even the lyrics have a mathematical structure. Poets structure syllables and repeat words to create pleasing sounding prose. This article shows how to decode lyrics from pop songs and visualise them using the Songsim method to analyse their metre. Decode ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . What is Multivariate Reporting and when is it helpful? Multivariate Reporting (also known as Small Multiples) uses a series of visuals with the same measure and same scales but showcases various partitions of the data. The benefit is that you can allow your report consumers to easily compare the same measure across dimensions and all in a single view! To better understand the value of multivariate report let’s look at following report: Company Revenue by State Here I have a visual that is NOT with multivariate mode OFF: You ... Read More

Feed: R-bloggers. Author: quantixed. Our lab is international. People born all over the world have come to work in my group. I’m proud of this fact, especially in the current political climate. I’ve previously used the GoogleMaps API to display a heat map on our lab webpage. It shows where in the world people in the lab come from. This was OK, but I wanted to get an R based solution to make this graphic to make it easier to automate updates. This post is an explainer and “how to” guide. Code and some example data are here. The idea ... Read More

Feed: Planet PostgreSQL. tl;dr; SELECT COUNT(*) FROM (SELECT DISTINCT my_not_unique_indexed_column FROM my_table) t;I have a table that looks like this: songsearch=# d main_songtexthash Table "public.main_songtexthash" Column | Type | Collation | Nullable | -----------+--------------------------+-----------+----------+ id | integer | | not null | text_hash | character varying(32) | | not null | created | timestamp with time zone | | not null | modified | timestamp with time zone | | not null | song_id | integer | | not null | Indexes: "main_songtexthash_pkey" PRIMARY KEY, btree (id) "main_songtexthash_song_id_key" UNIQUE CONSTRAINT, btree (song_id) "main_songtexthash_text_hash_c2771f1f" btree (text_hash) "main_songtexthash_text_hash_c2771f1f_like" btree (text_hash varchar_pattern_ops) Foreign-key ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Sagar Khasnis. By Sagar Khasnis, Partner Solutions Architect at AWSBy Awaneendra Tiwari, Cloud Architect at BrillioSome of the customers we work with have a central database where they keep tag values, and they want to enforce tags at provisioning using the tag enforcement capability of AWS Service Catalog. For example, a customer can have a central location where they keep all of their constantly-updated cost center information, and they use that information as tag values in their AWS Service Catalog portfolios. In this post, we’ll show you how to implement tag options so the ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Your production database environment stores personally identifiable information in an encrypted form, limits access to these fields and masks them when displayed. However, some types of data encryption create potential performance problems as well as security issues. Your data may be at risk unless you mask it effectively. The State of Database Security The European Union’s General Data Protection Regulation (GDPR) became effective worldwide in May 2018. It applies to any company that obtains data from any customer in the European Union and provides for extremely harsh penalties for companies that breach ... Read More