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
2 answers

Trying to turn multiple rows of categorical variables into single row with dummy variable columns

I have a dataset: ID Action Converted 567 Email True 567 Text True 567 Phone call True 432 Phone call False 432 Social Media False 432 Text False and i want the final table to look like ID Email Text…
1
vote
2 answers

EXPAND MULTIPLE COLUMNS POWER BI

I´ve been struggling with this: My table shows 3 records but when expanding there are like 100 columns. I used this code: #"Expanded Data" = Table.ExpandTableColumn(#"Source", "Document", List.Union(List.Transform(#"Source"[Document]), each…
1
vote
1 answer

how to add columns on pandas pivot table( multi-column)

Please tell me how to add columns? This DataFrame to pivot. |date |country|type|qty| |----------|-------|----|---| |2021/03/01|jp |A |10 | |2021/03/01|en |C |20 | |2021/03/01|jp |C |15 | |2021/03/02|jp |A |10…
1
vote
2 answers

Split character column value into 4 new value columns using gsub and drop values of original column

I have a column that holds values of arrays like this: [[["0.10", "35"], ["0.2", "36"]], [["5.1", "2"], ["90.2", "2"]]] I need the last two in 4 separate columns (in this case: [["5.1", "2"], ["90.2", "2"]]) but only their values: 5.1 2 90.2 and 2…
IndiPsi
  • 37
  • 5
1
vote
2 answers

Comparing One Column against Multiple

A bit complicated to explain this one (see example table below for reference). I have a dataframe with a 'Date Received' column (datetime) I want to compare the 'Date Received' with the date in the Stage columns to see if it was on-time or late. The…
NICode
  • 39
  • 4
1
vote
0 answers

I got error message 'Boolean array expected for the condition, not int64'. Can anybody help me solve this problem?

I have a dataset in .csv format. It has 136 columns and 15036 rows. I want to compute entropy and information gain of each column of dataset. Here my code: def calc_entropy(column): counts = np.bincount(column) prob = counts/(len(column)) entropy =…
1
vote
1 answer

Set position of columns in Beamer (R markdown)

I am creating a RMarkdown presentation using Szeged as beamer type. Does anyone know how to set the position of the columns so that there is less space between them? I have the following output: the code: --- title: | | Text author: | …
1
vote
1 answer

Call R apply-like function on each column of dataframe with the remained columns as argument?

I have a dataframe with multiple columns. For each column in the dataframe, I want to call a function on the column, and the input of the function is using the remained columns in the dataframe. For example, let's say I have this data and this…
1
vote
0 answers

How do I make an image fit css grid without the image expanding the size of the column?

So I want to add an image to one of the middle columns in my grid. The grid But when i add the image the column expands Grid with the image How do scale down the image so that its width is the same as the columns width? .game-box { …
user15236219
1
vote
2 answers

Selecting columns in Panda

Just curious, and quite new to Panda in Python, a b c d e f g h i j k l m n o p q r s t u v w x y z 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 …
John Ng
  • 35
  • 5
1
vote
2 answers

Columnar permutations in Python

How would I can find all the permutations of just the columns in a matrix. For example - if I had a square 6x6 matrix like so: a b c d e f 1: 75 62 82 85 91 85 2: 64 74 74 82 74 64 3: 85 81 91 83 91 62 4: 91 63 81 …
1
vote
1 answer

R: Use data frame names for columns after/before applying purrr reduce

I already checked this solution, but unfortunately, it does not fit my more complex data. Raw Data: I have a list named Total.Scores with eleven data frames named 2000-2020 each is containing annual data from 2000 till 2020. Each data frame has a…
GitTY095
  • 17
  • 4
1
vote
1 answer

Apply VBA code to multiple columns - to allow selection of multiple options from data validation list

I have set up a spreadsheet with several columns, some of which have data validation dropdown lists. I need users to be able to select multiple options from the dropdown list. I have achieved this for one column using the VBA below, however I am…
EEW13
  • 15
  • 1
  • 4
1
vote
2 answers

writing combinations in R

I have a dataframe (df) like this name col1 col2 pippo A;B;C E;F;G; pluto G;H X;Y;Z;E;O;D I'd like to write all possible combinations between 1 element of col1 and 1 element of col 2 and for each returned as a dataframe, for example name …
Nancy
  • 101
  • 1
  • 8
1
vote
1 answer

Get Range of Columns in data.frame for each row, based on two indexes in R

I have a fairly big data.frame with several thousand rows and some dozens of columns. Some rows have NA values in the final columns. Example df: pos1 pos2 pos3 pos4 pos5 pos6 case1 0.5 0.6 0.5 0.3 0.2…