5,908 questions
0
votes
0
answers
105
views
x "! Package longtable Error: longtable not in 1-column mode." from twocolumn article (extarticle) and longtable for (raw) markdown tables
My little demo example is given as follows:
---
output:
pdf_document:
latex_engine: xelatex
keep_tex: no
documentclass: extarticle
classoption: "a4paper,8pt,oneside,twocolumn"
...
- 711
1
vote
1
answer
37
views
Using sort with numeric columns separated by letters & underscores
I'm trying to sort phrases such as the following:
a12_b7
a12_b11
a5_b3
a5_b30
a12_b10
using the numbers following the letters, lexicographically. For the example above, I expect the result to be:
...
- 138k
3
votes
1
answer
69
views
Assign column status retrospectively in pandas
I have created the following pandas dataframe:
import pandas as pd
import numpy as np
ds = {'col1' : [234,321,284,286,287,300,301,303,305,299,288,300,299,287,286,280,279,270,269,301]}
df = pd....
- 1,762
1
vote
0
answers
44
views
Small Multiple Project by Phase with Status Icon
SampleData
I am trying to create a custom visual in power bi using Deneb and Vega code.
I need a small multiple chart that groups the Projects in columns by phase. I also have to add an icon to show ...
- 13
3
votes
6
answers
166
views
how to select matching rows in multiple files with AWK
I have over forty files with the following structure:
file1 first 21 lines
8191 M0
139559 M1
79 M10
1 M10007
1 M1006
1 M10123
file2 first 21 lines
8584 M0
119837 M1
72 M10
1 M10003
1 M10045
1 M1014
...
- 537
0
votes
3
answers
135
views
How to combine certain columns based on names into one for each line in an output file which contains a list of filenames and their respective values
Output file contains below values.
-rw-rwx--- 1 user1 group1 name with spaces 1G May 1 2025 file_1
-rw-rwx--- 1 user1 group1 name with spaces 2G May 1 2025 file_2
...
- 11
1
vote
2
answers
62
views
Align columns using grid-template-columns
I have two sections using CSS grid and grid-template-columns. The 1st one shows 4 boxes per row, while the 2nd one shows 3.
Since the first element of this 2nd section has 50%, I'd like the space/gap ...
- 135
-1
votes
1
answer
55
views
Multi-column style in `<fieldset>` does not work in Microsoft Edge, but works with Firefox; why?
Disclaimer: I'm not a CSS professional, just iterate over reading examples and specs and trying.
Specifically I'm unsure whether display: flow-rootis the best possible choice, but interactive trying ...
- 4,784
3
votes
2
answers
175
views
How to make the column width constant in a multi-column layout? (NOT a table)
I want to display some textual contents with a constant line width (or rather, a maximum line width), regardless of the available width. If that was my only requirement, I would set width: 30ex; (or ...
- 4,427
1
vote
2
answers
76
views
Laravel case insensitive unique validation rule on multiple columns
I'm trying to validate a form, where there are two mandatory columns whose combination must be unique in the table. Validator should also ignore the case of the input.
$data = request()->validate([
...
0
votes
1
answer
30
views
KeyError using Astropy .differentials code
I keep getting KeyError: 'd_ρ' on my d_rho = ... line. I am trying to run the differentials so that I can put them in a table column (or single column per variable), to use for calculating velocity. ...
- 1
0
votes
1
answer
97
views
css column-count fails on html table in Firefox
The following code works on most browsers, but fails on Firefox, i.e. displays everything in one column. What do I do?
The bottom of this post contains 2 screenshots. The first is my code in Chrome, ...
- 629
1
vote
1
answer
70
views
boxplot across multiple columns in R
I'm new to R and having next to nothing experience with it I'm struggling with what may be a pretty easy problem. I have a dataset of acceptability judgments provided by a group of 30 participants on ...
1
vote
2
answers
110
views
How to remove only one column, when there are multiple columns with same in name in dataframe
I'm trying to remove one column even though if there multiple columns with same name in Spark dataframe after join operation performed.
df.printSchema()
--- Id String
--- Name String
--- Country ...
- 297
5
votes
5
answers
128
views
Matching pair-wise columns from left to right across rows in one dataframe to another dataframe and adding new columns with matching values
I've got a dataset like this:
df1 <- data.frame(
col1 = c(1, 2, 3),
col2 = c(4, 5, 6),
col3 = c(2, 8, 9),
col4 = c(5, 11, 12),
col5 = c(13, 14, 15),
col6 = c(16, 17, 18),
...
- 321
0
votes
1
answer
350
views
Returning Multiple Columns With Xlookup With Multiple Lookup Values
I've been trying to return multiple columns with Xlookup with multiple lookup values, but only the first column is returned. Nevertheless when I provide only one lookup_value it works well.
=xlookup(...
1
vote
1
answer
58
views
Tracking variable name changes within group in Excel
I am annually tracking the names of car models, which may or may not change each year (its random).
Suppose I start with three models in 2023 that all changes name in 2024 and 2025, thus producing the ...
- 153
0
votes
2
answers
123
views
Excel. How to get an one row data (multiple columns) from every three rows
Please need your help.
I have an excel file with this following structure, that one row is divided into the next two rows:
initial
And need finally get this one. Every third row need to be combined ...
0
votes
1
answer
67
views
Is it possible to synchronize y-axis of three different stacked column plots in Power BI?
I have a Power BI page in which I want to visualize installed capacity of 3 scenarios at the same time with 3 different plots. I have filtered scenario to visualize results in each plot.
However, the ...
- 1,820
0
votes
1
answer
68
views
Invisible or triplicated : ) columns while reading multiple files
So I'm reading multiple files (30 exactly). Some of them has the same columns, some has different or so.
mycsvdir = r'C:\t\...\dict_full'
csvfiles = glob.glob(os.path.join(mycsvdir, '*.csv'))
...
- 23
0
votes
0
answers
23
views
How to divide submenu in 2 columns
How to divide submenu in 2 columns, speccificaly 22 items how can I to divide submenu, I need to have these icons.
If there is any explanation for my website, please answer me, this is my website www....
0
votes
1
answer
61
views
How to change the columns in dataframe on two level header in R code?
I need to change the order (dynamically) of the columns in a dataframe from this:
[![current dataframe]]
to this:
[![required dataframe]
The problem is, that I have a lot of NA in the vales and also ...
- 93
1
vote
1
answer
171
views
Sorting the order of legend and stacked column in the same order in Power BI
I have data1 which looks as shown below:
My data2 looks as shown:
I want to create a stacked column chart for data1.
I create two measures for Installed Capacity and SentOut Demand in Power BI as ...
- 1,820
1
vote
3
answers
139
views
Create a new column for each value in another column
I would like to transform table like this:
Fixed
Part
Original column
U
1
b
U
1
c
U
1
d
X
4
e
Y
5
f
Z
6
g
Z
6
h
W
8
i
to table like this:
Fixed
Part
New column 1
New column 2
New column 3
U
1
b
c
d
X
...
- 21
0
votes
1
answer
69
views
How make this text consistently line up? [duplicate]
I'm trying to display a row of data, I want to display the data neatly. I used \t, but using tab is inconsistent:
Current output (roughly):
Location City Price ...
- 3
0
votes
1
answer
1k
views
How to deal with a column position change when inserting data to iceberg table?
Suppose I have a table with three columns A, B, C. if source stops sending B data (Which we assume that it got deleted in file, Not in table schema). Few days later, if source wants to add that column ...
- 13
5
votes
3
answers
107
views
Using awk and inverse grep for specific columns across files
Assume a tab-separated file as input file 1 ($IN1):
$ cat input1.tsv
HEAD1 HEAD2 HEAD3 HEAD4 HEAD5 HEAD6
Qux ZX_999876 Bar Foo MN111111 Quux
Foo AB_123456 Bar Baz CD789123 Qux
Bar ...
- 1,793
-2
votes
1
answer
76
views
How to copy two rows of data into one column and delete duplicates
Need assistance on copying two rows of data into one and delete duplicates - The data begins in column B4 & L4. I would like to copy both columns starting at cell E4. Thereafter, I will need to ...
- 29
0
votes
1
answer
51
views
Pivot data values to row
I have a pivot table from the below data. I need to write a program or develop a formula to get the data into the below format.
Data ___________________My pivot _______ Desired result
_ _
A formula ...
0
votes
1
answer
86
views
Consolidate multiple column questions into a question column with answers and comments
I am currently trying to create an auditing application for report writing findings from a series of Sharepoint tables featuring a series of question columns (Choice type column) and associated ...
- 61
1
vote
1
answer
73
views
How to wrap a css grid in both column and a certain amount of rows, while following logical alphabetical order?
So i have a grid setup like this
<div class="grid-container">
<div>a</div>
<div>b</div>
<div>c</div>
<div>d</div>
<div>e&...
- 13
1
vote
1
answer
86
views
Arranging character values of multiple columns that contain the same name with R
I use R and I am merging mutiple data sets horizontically (by column), where each data set has one same column. For example, consider
`df1=data.frame('name'=c('9504','07123','40355','59003'),
...
- 215
0
votes
2
answers
189
views
Find a table based on multiple criteria in Google sheets
I have a google sheets with thousands of table. Here is the link text
In this table I want to find a table based on two value. Such I want to find a table that is include
Fleece & NUMBER 260.
How ...
0
votes
1
answer
123
views
VBA code to rotate a list of positions/names on two columns, one row up (top row will fall last) but not to include blank cells
VBA code that can rotate in sync up one row two columns with positions/names so that the top row will always fall down on last position. The code should ignore the blank cells and only rotate the ...
- 11
0
votes
2
answers
52
views
How to show the quantities of a column depending on the maximum or minimum values within another column in Scilab?
My problem is related to unfamiliarness with the program as a whole. An attempt has been made to display the values of time at the maximum and minimum values, but I'm not sure how to approach the ...
0
votes
1
answer
52
views
Trouble splitting column with date and time Value Error: Columns must be same length as key
I'm trying to split a column that has a date and a time into two separate columns. They are objects, not datetime objects. It appears in the column as mm/dd/yyy 00:00:00 AM/PM. To try splitting I ...
0
votes
1
answer
79
views
Merge multiple columns based on match rows using loop by Python
I have two excel files:
excel file 1 which is shown on image 1, contains standard time series data.
excel file 2 which is shown on image 2, contains time series recording of different geographical ...
0
votes
2
answers
78
views
Consolidating Excel Data With Dynamic Arrays
I'm working in Excel with data that contains multiple columns of criteria and sometimes this criteria has redundant identifiers. In my process, I'm trying to use dynamic arrays as much as possible so ...
- 15
1
vote
0
answers
183
views
How to Create Multi-Column Layout with Varying Widths in CSS or tailwind if it is possible?
I'm working on a web-based text layout styled as an old-style journal.
My goal is to create a multi-column text layout where the text automatically flows from one column to the next, but with each ...
- 11
0
votes
0
answers
66
views
SSRS Multi-Column Reporting in Sub-Report Not Rendering in PDF
I have a functional multi-column SSRS report that when saved to PDF displays correctly. However, when used as a sub-report and saved to PDF it does not display correctly.
Steps (Stand alone report):
...
0
votes
0
answers
58
views
WPF Datagrid - Custom Column Layout
I'm looking to create a custom layout for a datagrid column. I want to stack some columns like you can with Infragistics (one above another), but I want to do it myself. Is this possible? I've ...
- 11
0
votes
1
answer
113
views
Index or xlookup needed - looking to return multiple critera xlookup to same row
Thank you in advance for your assistance. Looking to do either a index/match formula or xlookup (open to any other solutions) to create this view in my sheet.
I am wanting excel to look at column N ...
2
votes
1
answer
99
views
Apache POI Word - Line between columns
I already have the columns created. I would like to put a line between them, as is possible in Word.
Line Between
How do I set it using Apache POI?
CTColumns coluna1 = sectPr.addNewCols();
coluna1....
- 33
0
votes
1
answer
113
views
Count If Meets Multiple Criteria and Unique
I have read several other relatable questions with responses, including referenced suggestions, but they do not appear to be similar in my requirements or I'm having troubles understanding what they'...
- 107
0
votes
1
answer
46
views
Compare multiple columns in the dataframe and return column names with different values in a new column
Consider this df:
data = [{'name': 'Muhammad', 'age_x': 20, 'city_x': 'Karachi', 'age_y': 20, 'city_y': 'Karachi'},
{'name': 'Ali', 'age_x': 19, 'city_x': 'Lahore', 'age_y': 30, 'city_y': None}...
- 165
0
votes
2
answers
40
views
How to get a value from a column from a dataframe if the id is present in multiple columns in another dataframe?
I have 2 dataframes, df1 which are ID numbers of participants (some have more than one ID but is the same person)
df1 <-data.frame(hospid_1=c("A", "B", "C"),
...
1
vote
1
answer
39
views
Issue with Box Cutting Off When Using Count-column and Fixed Width
I'm working on a design using the count-column property. Everything is mostly fine, but I'm encountering an issue where some of my boxes are getting cut off. Here is the URL to the screenshot (https://...
-1
votes
1
answer
563
views
Search & Match 2 sheets & 2 columns, return value from 3rd column
I am trying to find a formula that will search for identical data in Column A (Sheet 1) and Column B (Sheet 2), when the matching data is found, I need the data from Sheet 1 Column B to be returned / ...
2
votes
3
answers
68
views
Conditional sum of multiple columns based on multiple (other) columns
I have a data frame of the form below:
ID <- c(1, 2, 3, 4, 5)
Type1 <- c("A", "", "A", "B", "C")
Count1 <- c(40, NA, 10, 5, 100)
Type2 <- ...
- 21
0
votes
0
answers
51
views
Remove headers from being summed in SQL
I am working to sum columns of data by a given category e.g. public spend by country from my file expenditure
SELECT SUM(public spending) AS public spending,
country FROM expenditure
group by country
...
- 11