Trjtdtk

Why are prions in animal diets not destroyed by the digestive system?

ContentVersion: System.DmlException: Insert failed. STRING_TOO_LONG, Body: data value too large

What are the spoon bit of a spoon and fork bit of a fork called?

Is it cheaper to drop cargo than to land it?

Using DeleteCases with a defined function with two arguments as a pattern

Have I damaged my car by attempting to reverse with hand/park brake up?

I drew a randomly colored grid of points with tikz, how do I force it to remember the first grid from then on?

Unknowingly ran an infinite loop in terminal

Why do money exchangers give different rates to different bills?

Manager is threatning to grade me poorly if I don't complete the project

When boost::lexical_cast to std::string fails?

Is there formal test of non-linearity in linear regression?

Junior developer struggles: how to communicate with management?

Can I get a paladin's steed by True Polymorphing into a monster that can cast Find Steed?

Why Isn’t SQL More Refactorable?

What was the state of the German rail system in 1944?

Would a 1/1 token with persist dying trigger on death effects a second time?

Can the 歳 counter be used for architecture, furniture etc to tell its age?

Virus Detected - Please execute anti-virus code

In Avengers 1, why does Thanos need Loki?

Is this homebrew life-stealing melee cantrip unbalanced?

How did Arya get her dagger back from Sansa?

How to get a product new from and to date in phtml file in magento 2

What happens to the Time Stone?

How can I cluster data by using multiple views of the data with a common column using OpenRefine?

Instances vs. cores when using EC2Data transposition code in RTidying Time Intervals for Plotting a Histogram in RDetermine what data, does certain column have in commonPreprocessing in Data mining?Fixing data inconsistenciesHow to extract paragraphs from text document?Do modern R and/or Python libraries make SQL obsolete?Storing engineered features in a databaseHow to create clusters based on sentence similarity?

0

$begingroup$

I need to cluster my data, but there are multiple ways to view the data such that I can't really place it all into a single table. I have been working with Open Refine to cluster this data but I keep running into a limitation.

I have two tables that share a common column ID. The first table is a list of cars:

CarId | Make | Model | Year | 
0 | Toyota | ... | 2018 |
etc ...

And a second table:

CarId | Part | Color | Weight | 
0 | Driver Door| Green | 123 |
etc ...

So Open Refine only works with a single table of data at at time. This is an issue because obviously the data I want to cluster by is in two different tables.

How would I be able to ask, say, show me all cars that don't have a Green Driver Door, or all cars that do have a Green Driver Door?

I could join these all into a single table using an SQL join, but what if the data set doesn't practically fit into a single table? I could "ask the question" by using an SQL query, but at that point I am not interactively clustering with open refine, I have to go back to sql and re-export the data whenever I want to ask a different question...

Thanks!

data-mining data-cleaning clusters

share|improve this question

asked Apr 9 at 18:37

user71208user71208

11

$endgroup$

add a comment | 

0

$begingroup$

I need to cluster my data, but there are multiple ways to view the data such that I can't really place it all into a single table. I have been working with Open Refine to cluster this data but I keep running into a limitation.

I have two tables that share a common column ID. The first table is a list of cars:

CarId | Make | Model | Year | 
0 | Toyota | ... | 2018 |
etc ...

And a second table:

CarId | Part | Color | Weight | 
0 | Driver Door| Green | 123 |
etc ...

So Open Refine only works with a single table of data at at time. This is an issue because obviously the data I want to cluster by is in two different tables.

How would I be able to ask, say, show me all cars that don't have a Green Driver Door, or all cars that do have a Green Driver Door?

I could join these all into a single table using an SQL join, but what if the data set doesn't practically fit into a single table? I could "ask the question" by using an SQL query, but at that point I am not interactively clustering with open refine, I have to go back to sql and re-export the data whenever I want to ask a different question...

Thanks!

data-mining data-cleaning clusters

share|improve this question

asked Apr 9 at 18:37

user71208user71208

11

$endgroup$

add a comment | 

$begingroup$

I need to cluster my data, but there are multiple ways to view the data such that I can't really place it all into a single table. I have been working with Open Refine to cluster this data but I keep running into a limitation.

I have two tables that share a common column ID. The first table is a list of cars:

CarId | Make | Model | Year | 
0 | Toyota | ... | 2018 |
etc ...

And a second table:

CarId | Part | Color | Weight | 
0 | Driver Door| Green | 123 |
etc ...

So Open Refine only works with a single table of data at at time. This is an issue because obviously the data I want to cluster by is in two different tables.

How would I be able to ask, say, show me all cars that don't have a Green Driver Door, or all cars that do have a Green Driver Door?

I could join these all into a single table using an SQL join, but what if the data set doesn't practically fit into a single table? I could "ask the question" by using an SQL query, but at that point I am not interactively clustering with open refine, I have to go back to sql and re-export the data whenever I want to ask a different question...

Thanks!

data-mining data-cleaning clusters

share|improve this question

asked Apr 9 at 18:37

user71208user71208

11

$endgroup$

CarId | Make | Model | Year | 
0 | Toyota | ... | 2018 |
etc ...

CarId | Part | Color | Weight | 
0 | Driver Door| Green | 123 |
etc ...

share|improve this question

asked Apr 9 at 18:37

user71208user71208

11

share|improve this question

asked Apr 9 at 18:37

user71208user71208

11

asked Apr 9 at 18:37

user71208user71208

11

asked Apr 9 at 18:37

user71208user71208

11