Questions tagged [table-splitting]
32 questions
1
vote
1 answer
data.frame and splitting rows... not found a suitable solution for my data
I am struggling a bit with my tables. I am trying to split some variables (using R), but I am having difficulties with one specific column.
My dataset is like this:
test<-data.frame(
Chrom_no=c(1,1,2,3),
…
MadMax
- 11
- 3
0
votes
1 answer
Power Query - (1) Get Column Name (2) Split Table
how do I get the queries for the following scenarios.
Scenario 1:
I have a column MAX which contains the max value out of defined columns.
Q1: How do I get the column name for this value?
(A solution I had in the past was based on dynamic column…
user13940869
0
votes
1 answer
Fast splitting a MySQL table based on the values of a column
I have a fairly large MySQL table (~600G) on my own computer (Win10) with the following structure.
id var1 var2 var3
a val1 1 5
b val1 2 6
c var2 3 7
d var2 4 8
both id and var1 are indexed. I want to split this…
Ding Li
- 673
- 1
- 7
- 19
0
votes
1 answer
Separating a table into two at a row containing a particular string
I have a table shown below that I would like to separate into two. The catch is the number of rows varies and I need the table to separate at the third row that contains the string 'CPT'. This row is not always the 10th row. The table is represented…
Jean123
- 129
- 9
0
votes
1 answer
EF6 Table Splitting and exception "A dependent property in a ReferentialConstraint is mapped to a store-generated column. Column: 'Id'."
For some time I've been following the "First Class Collections" rule from Object Calisthenics in my domain design. In order to avoid creating a useless "Collection" table though, I use the table splitting configuration from Entity Framework.
But if…
Marcos Dimitrio
- 6,651
- 5
- 38
- 62
0
votes
2 answers
EF Core Table Splitting - One table to multiple classes
My table has four columns and I want to split it between multiple classes.
table1
key
col1
col2
col3
col4
Class ClassA
key
col1
col2
class ClassB
key
col3
…
Tejas Patel
- 1,289
- 13
- 25
0
votes
2 answers
How to split a table in a text file in python?
Suppose there is a table in a file:
VLan Interface State
Vlan1 Fa0/0 Up
Vlan2 Fa0/1 Down
Vlan3 Fa0/3 Up
Now I actually need to get the name of the VLan & Interface whose state is up.
But for that I…
Asish
- 93
- 2
- 9
0
votes
0 answers
The column name is changed when use table splitting and with join other table
My English is not good, so i just can describe the problem i got as what as I can. I got 2 entities which are WORK_ORDER and INVENTORY_TRANS, and i have join these tables for querying, before I do the table splitting on WORK_ORDER, everything is…
peter
- 1
0
votes
2 answers
Splitting a dataframe if rows are numeric or not in R
I have a data frame (let's call it 'df') it consists of two columns
Name Contact
A 34552325
B 423424
C 4324234242
D hello1@company.com
I want to split the dataframe into two dataframe based on whether a row in column…
Anubhav Dikshit
- 1,729
- 6
- 25
- 48
0
votes
2 answers
HTML/CSS Splitting container into 3 parts
I want to split container into three sections and it's already done but I can't figure out how to align all these sections vertically.
HTML:
|
…
Suprido
0
votes
2 answers
EF6: Table Splitting Not WorkingI am trying to create an EF6 database where two tables, Addresses and Visits, share the same values as primary keys. Visits, conceptually, is an extension of Addresses. I'm splitting the tables because most of the records in Addresses don't require…
Mark Olbert
0
votes
0 answers
T-SQL: Splitting a OTLT table into many-to-many relationshipI have an entity framework application. There is a table that is starting to cause a lot of problems, mostly because it doesn't follow EF conventions:
The two important columns are RequestType and RequestDetailId. Each type of request has its own…
Travis Parks
0
votes
1 answer
Splitting Values in new column in rapidminer 5In rapidminer 5 I would like to split values of a column and put the new values in a new column. I.e:
BIC|"Cognome"|"Nome"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
50417273|"ACCROCIA"|"ALESSANDRO"|"VIA…
Friso
0
votes
2 answers
Table splitting in MySQLI have an unusual situation regarding DB table splitting; I have a table named 'message' holding info for messages to be sent via email:
Message Status
-------------------------------- -------------
id | subject |…
icemanblas
0
votes
1 answer
D3js getting just a part of a value and converting it to decimalI'm trying to get a decimal value for a value that is expressed in a date. My problem is that I need only the time in the date, not the actual date itself. So here part of my .json data:
var data = [
{
"Id":"1390794254991",
…
Yonker
|