Questions tagged [consolidation]
160 questions
4
votes
2 answers
Multiple Input Validation Consolidation Java
when I get an input from the user I want to make sure that it is both:
a numbergreater than a minimum value
I wrote the following code to achieve this but it seems more convoluted than it has to be. Is there a way to consolidate the question is the…
Matt
- 47
- 3
4
votes
3 answers
Reduce array of month names by creating hyphenated expressions from consecutive months
I have an array like:
Array
(
[0] => Jan
[1] => Feb
[2] => Mar
[3] => Apr
[4] => May
[5] => Jun
[6] => Sep
[7] => Oct
[8] => Dec
)
I need to convert it to
Array
(
[0] => "Jan - Jun"
[1] => "Sep - Oct"
…
Bluemagica
- 5,000
- 12
- 47
- 73
3
votes
3 answers
Consolidate SQL Server databases into 1
I need to consolidate 20 databases that have the same structure into 1 database. I saw this post:
Consolidate data from many different databases into one with minimum latency
I didn't understand all of this so let me ask like this: There are some…
ilija veselica
- 9,414
- 39
- 93
- 147
3
votes
1 answer
Pandas - Using groupby to combine columns with strings - problem with TypeError message
I've got a pretty simple case that, for some reason, is giving me problems.
I'm combining multiple dataframes. As a result, I'll often have the same key, but different comments for each key value.
KeyValue Comment
1235 This is…
TroublesomeQuarry
- 165
- 5
3
votes
2 answers
Python consolidate dictionary keys and values using comprehension
How do I CONSOLIDATE the following using python COMPREHENSION
FROM (list of dicts)
[
{'server':'serv1','os':'Linux','archive':'/my/folder1'}
,{'server':'serv2','os':'Linux','archive':'/my/folder1'}
…
MaxGrand
- 113
- 1
- 9
3
votes
3 answers
Creating master array from multiple arrays
I have 2 arrays(which could be more too) and they might have scattering data.
Date | Apple Date | Banana
----------------- -------------------
1 | 5 1 | 3
4…
Purus
- 5,701
- 9
- 50
- 89
2
votes
3 answers
How to combine rows in excel? (Large dataset)
I have a large dataset (>79000 rows). My dataset looks like this:
Col1
Sampl1
Sampl2
Sampl3
sp1
0.1
0.5
1.2
sp2
1
2.1
4
sp3
2
3
0.75
sp1
1
4
1
I want to combine the duplicate columns in the species column while also summing the…
Alex Gomez
- 21
- 2
2
votes
1 answer
Does git mv folder and merge afterward new file from feature branch to the modified path, deletes its history?
I have the below scenario:
main branch before consolidation:
│ └── dir1
│ │ └── python1
│ │ │ └── test1.py
│ └── dir2
│ │ └── python2
│ │ │ └── test2.py
│ └── dir3
│ │ └── python3
│ │ │ └── test3.py
main branch…
arielma
- 1,308
- 1
- 11
- 29
2
votes
1 answer
Simplified "Bin Packing Problem" to consolidate/sum numeric entries in a 1d array with a specified upper limit per element
I wanted to get the sum of values and limit them with a maximum value. My maximum value is 500.
My array:
array:11 [
0 => 100
1 => 100
2 => 100
3 => 100
4 => 100
5 => 100
6 => 300
7 => 300
8 => 300
9 => 300
10 => 300
11 =>…
the_lorem_ipsum_guy
- 452
- 1
- 12
- 27
2
votes
1 answer
Design Pattern for Data Consolidation Layer (ETL)
I have to design a software using asp .net core which collects data from various datasources (s. picture below).
E.g. DataSource1 and DataSource2 are including product data like attributes. DataSource 3 is including the assets of those products.
I…
M. Haider
- 35
- 4
2
votes
2 answers
Script that consolidates multiple rows of phone data into single rows showing start and end dates
For the below table, I will like to:
i. Consolidate the rows such that for each phone type, the sets of the same phone numbers are consolidated into unique phone numbers with a singular Start and End Date
ii. The consolidated phone number's START…
cmomah
- 165
- 2
- 9
2
votes
4 answers
Design - Consolidating my PHP files?
My understanding is that "name".class.php is standard convention for creating classes in PHP, and consequently I have a separate file for each class. What I would like to do is consolidate my small php class hierarchy into one single file... say…
user656925
2
votes
2 answers
Consolidate similar patterns into single consensus pattern
In the previous post, I did not clarify the questions properly, therefore, I would like to start a new topic here.
I have the following items:
a sorted list of 59,000 protein patterns (range from 3 characters "FFK" to 152 characters long);
some…
Kenny
- 221
- 2
- 5
2
votes
1 answer
Is there a way to host Azure Worker code within an Azure Web role?
I have a relatively low bandwidth Azure Web Role application and also several processes that run under a Worker Role. My worker role also spends most of its time idle as well.
Is there a way to do a Poll of something like my Worker Role loop within…
JTew
- 3,149
- 3
- 31
- 39
2
votes
3 answers
Merge data with varying headers in Python or R
I have an excel file with multiple sheets which need to be consolidated. However the column headers are varying from one another. Currently the data looks like this.
Sheet 1
+-------------+--------------+----------+--------+---------+---------+
|…
Shubhankar Dash
- 31
- 5