Questions tagged [multiple-columns]

Multiple-columns are when text is split into a number of parallel text columns, rather than one column of text. For CSS Multicolumn layout, use the [css-multicolumn-layout] tag.

Multiple-columns are often found in newspapers and magazines, where a single column of text would create a line length longer than the ideal width of optimal readability.

Text can be set to use multiple-columns in CSS by using the CSS Multiple-column layout module.

5872 questions
1
vote
1 answer

Create multiple columns with Pandas .apply()

I have two pandas DataFrames, both containing the same categories but different 'id' columns. In order to illustrate, the first table looks like this: df = pd.DataFrame({ 'id': list(np.arange(1, 12)), 'category': ['a', 'a', 'a', 'a', 'b',…
YanCosta
  • 13
  • 5
1
vote
2 answers

How to change a latitude (rows) x longitude (columns) data frame into a latitude (column 1), longitude (column 2), value (column 3) data frame in R?

I have a data frame where latitude (lat) values are the names of the rows, and longitude (lon) values are the names of the columns, and for each cell of the data frame is a temperature (temp) value of interest to me (or an NA value) such as: lon…
Jamie_B
  • 149
  • 6
1
vote
1 answer

Merging multiple columns based on conditions in R

I have a data frame with several columns I want to merge only 5 of…
Meli
  • 33
  • 6
1
vote
0 answers

How to approach long column names in R?

I have a large data-set comprised of many very specific variables. I am looking for a way to simplify the column names using a quick method rather than manually changing over 1000 columns. total.population.2020 <- c("1","2"…
asixet
  • 11
  • 2
1
vote
2 answers

How to create multiple columns from one column, maybe using dcast or tidyverse

I am learning R and attempting to figure out splitting a column. I am looking to spread my data from a single column in wide format. I was told to use dcast, but i haven't figured out the best way and was going to try to pipe it through tidyverse. #…
lziegs
  • 37
  • 5
1
vote
1 answer

Power BI: grouping items in one colum, other columns that have different values appear as several columns

I have a question for a table on Power BI. In fact, I have a first colums that is the name or the id of a process, the 2nd one, that is the number of the step of the process, and the 3rd one that is the time of the step. Example : Column 1: [A, A,…
Tam
  • 11
  • 1
1
vote
2 answers

Match between the columns

I have two files. First, I want to look at the column "Variant_Type" in the first file. If it is DEL, then I should look if there is a match between three columns in two files (Chromosome, vcf_pos, Reference_Allele) and append AC and AF columns from…
Anna
  • 53
  • 6
1
vote
1 answer

VBA For Loop - Adding certain input to a cell if row contains characters?

EDIT: Here I have updated Code that @k1dfr0std was kind enough to help me with: Dim lrow As Long Dim lLastRow As Long 'This is where the error is happening lLastRow = ThisWorkbook.Range(Cells(Rows.Count, "A").End(xlUp).Row) Dim i As Long 'Using Long…
1
vote
0 answers

How to make multiple insert in Inertia Vue js

I think not much people using Inertia jetstream lately and i just got stuck in making multiple insert(record) in my program. i know the concept is making array data in your form to make request to controller and save the data but maybe i still nob…
1
vote
1 answer

Ordering by multiple columns that match variables

I currently have this mysql statement: SELECT * FROM tablename WHERE column1 = 'yes' ORDER BY CASE column2 WHEN 'premium' THEN 1 WHEN 'basic' THEN 2 ELSE 999 END, customer_id ASC I'd…
KTJ
  • 11
  • 2
1
vote
2 answers

Pandas: Create a new column with coulmn name and cell of matching string

I am searching through a large spreadsheet with 300 columns and over 200k rows. I would like to create a column that has the the column header and matching cell value. Some thing that looks like "Column||Value." I have the search term and the…
ryda
  • 38
  • 5
1
vote
0 answers

Table size increasing in Latex

How Can I increase the entire size of this table to take large height and width in latex there is the code \begin{table}[htb] \centering \caption{Recognition rate $\pm$ Standad deviation $\%$ of RFME and SGRFME over 20 splits of…
userfh
  • 57
  • 1
  • 1
  • 9
1
vote
1 answer

Create a new column based on a combination of columns + conditions + thresholds in r

I have a problem with a piece of code, to start I share a dataset: df <- data.frame(PatientID = c("0002" ,"0002", "0005", "0005" ,"0009" ,"0009" ,"0018", "0018" ,"0039" ,"0039" , "0043" ,"0043", "0046", "0046" ,"0048" ,"0048"), sex=…
1
vote
3 answers

Dynamic comparison of values of n multiple Pandas columns

Let's say a user can input the columns and values to compare for a DF, so we can have: column_list = ['col1', 'col2', 'col3'] value_list = [val1, val2, val3] So to select the rows that satisfy where col1 >= val1 AND col2 >= val2 AND col3 >= val3 we…
juanman
  • 137
  • 1
  • 9
1
vote
1 answer

Sort a numpy array using multiple index and different order

I have an array of size 300x5 and I am trying to sort the array in such a way that column with index 4 is my primary index and in ascending order, index 1 is secondary index and in descending order, index 3 is tertiary index and in ascending…
Rohan
  • 43
  • 5