Challenge #208: COVIZ-19

A solution to last week’s challenge can be found here. DNA Carousel Image.png

This week - let's do an interesting viz! We have sourced the RNA sequencing of SARS-CoV-2 (which is responsible for COVID-19) and would like to put it into a gridded visualization.

Since RNA is made of up the base pairs of G,T,A, and C, your visualization should have four colors. When creating the grid, try to order the sequencing from left to right: For example, the first base pairs are A-T-T-A. Make sure that A is row 1 column 1, T is row 1 column 2, and so on...

Make note of how many columns make up a row or what colors you select are entirely up to you (our solution has 178 columns)!

If you want to take it a step further, let's see if you can create something new entirely!

Data sourced from: https://www.ncbi.nlm.nih.gov/nuccore/MN908947.3

Inspired by:
https://www.reddit.com/r/dataisbeautiful/comments/fkwova/oc_rna_sequence_of_covid19_this_8kb_of_data_is/

challlenge_208_start_file.yxmd

challlenge_208_solution.yxmd

Reporting

Parse

Join

Preparation

Advanced

Data Analysis

Difficult

Accepted answers

All comments

patrick_digan

I went for a black and white pattern

Spoiler

challlenge_208_start_file.yxmd

johnemery

Took me a few tries to land on this solution. Glad to see that my thought process matched @patrick_digan's excellent first solution.

Spoiler

Weekly Challenge 95 (the apple one) helped here.
The .4 mile grid was found iteratively: it provides the nearest larger number of grids than we have rows in the tokenized data set.

https://youtu.be/lxCS3vs1Bwk

Challenge 208 Solution jve.yxmd

Aaron_Harter

Certainly a topical weekly challenge:

Spoiler

challenge_208_solution_AB Data Consulting_Aaron.yxmd

philipmannering

Stuck indoors is a good time learn some Python

Spoiler

output

workflow

Code

Challenge 208 - COVIZ-19.yxmd

RolandSchubert

I have chosen a slightly different (and relatively simple) approach.

Spoiler

challenge_208_solution_rsc.yxmd

RWvanLeeuwen

As a molecular biologist, I think that this is a good challenge to get to know Alteryx and reporting but it holds no additional value.

Result in Alteryx

Spoiler

Result in Tableau

Spoiler

Workflow:

Spoiler

challlenge_208_start_file - RWvL.yxmd

JennyMartin

Spoiler

Not 100% sure if I've approached this correctly but here's my video solution for it: https://www.youtube.com/watch?v=0RuHrWjVtWs&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=13&t=0s

AWC208.yxmd

Kenda

Spoiler

challlenge_208_start_file.yxmd

TonyA

My solution attached. Went a different route from most of the other solutions I've seen.

Spoiler

I tried the grid approach and it worked but seemed to take a long time (15 seconds or so). So I went for brute force and this runs in two seconds or less.Still can't figure out why the grid approach was slower but I saw the same thing when I downloaded some of the other solutions.

challlenge_208_TonyAv2.yxmd

hbraunius

My solution attached. Stay safe, everyone!

challlenge_208_solution_hb.yxmd

huynv96

I have not worked with map report/spatial more. Solved the challenge by other spoils. Haha. Thanks, all.

Spoiler

challenge_208_huynv96.yxmd

rmassambane

Not sure what I was supposed to do.

challlenge_208.yxmd

AngelosPachis

My solution attached

challlenge_208_solved_AP.yxmd

kelvin_law1

Here is the solution using the Interactive Charts:

Spoiler

challlenge_208_solution.yxmd

OllieClarke

Tried for a long time with the table tool, but couldn't get it how I wanted

Spoiler

In the end went down the spatial route

Screenshot 2020-03-25 at 10.02.45.png

challlenge_208_OC_solution.yxmd

Jonathan-Sherman

Challenge 208 is done!

Spoiler

challenge_208_JMS_solution.yxmd

reply_mueller

My take on this, using a naive approach with the interactive chart tool.

Spoiler

Producing the follwing result:

The colormap is a bit off, due to a bug in 2018.3, which I use for compatibility reasons. See this post.

challlenge_208_reply_mueller.yxzp

ggruccio

Spoiler

Was excited to use the interactive chart to build this one! However didn't realize that it wouldn't allow me to assign color to a string value on the chart....experimented with 1=a etc...and got it to work.

challlenge_208_gg_finish.yxmd

mbogusz

I used the table tool, but only for 4 columns though. It would've been a nightmare setting up with 65 columns.

Spoiler

challlenge_208_solution_mbogusz.yxmd

T_Willins

Went a different visualization route and kept each base pairs separated. When rendered using the layout tool it gives a image like a magic picture.

Spoiler

White base pairs added to force an extra set of white 50 at the bottom so it renders correctly.
Workflow 208.png

challlenge_208_solution.yxmd

delilah

Get it done but have no idea what is the point for making this figure.

challlenge_208_delilah.yxmd

kelly_gilbert

I love an opportunity to get creative with the interactive chart tool!

Spoiler

challlenge_208_solution_klg.yxmd

AkimasaKajitani

My Solution.

Spoiler

challlenge_208_start_file_kajitani.yxmd

Jean-Balteryx

Here is my solution !

challlenge_208_workflow.yxmd

knlekash

First time using many of these map tools, great learnings

challlenge_208_finish_file.yxmd

cplewis90

Not sure I like the colors I chose, but here is my solution

Spoiler

challlenge_208_CL.yxmd

RichoBsJ

Really nice challenge, thanks!

Spoiler

where 1 means "a" and color is dark red, 2 is "c" and orange, 3 is "g" and green and 4 is "t" and dark green

challlenge_208_richobsj.yxmd

KevinTang

Never thought report map tool can be used in this way

challlenge_208_KT.yxmd

MOHAMMEDAFZAL

Here's my solution. Check it out!

Challenge_208_solution_MA.yxmd

pasccout

Here is my solution... must admit I needed a hint at the tool to use 🙂 But everything is mine...

challlenge_208_my_solution.yxmd

dsmdavid

Was determined to make this work purely with reporting tools (table). Definitely not the most intuitive tools to use (getting the size right seems a trial and error approach to me).

Spoiler

Table output:

Scatter output:

Workflow:

david_208.yxmd

LiD

Since there are 29903 pairs in total and prime factorization of 29903 = 17 * 1759, it is illustrated in 17 rows and 1759 columns. However, through the text input tool, an individual number of columns may be set. If the number of columns is adjusted, the axes ranges of the chart may have to be adjusted accordingly.

Spoiler

challenge_208_COVIZ-19.yxmd

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335