Stack Overflow
Stack Overflow

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

How to call a specific word from csv file using python

Supposed if I have a .csv file with two columns A, B so if I call column A row 3 then how to print column B row 3 data . Please help me out as I am beginner at code. I just want to call a input value and print same row value form next column. This…
ellie_ Abhi
  • 17
  • 4
1
vote
1 answer

pySpark join dataframe on multiple columns

I'm using the code below to join and drop duplicated between two dataframes. However, get error AnalysisException: Detected implicit cartesian product for LEFT OUTER join between logical plans...Either: use the CROSS JOIN syntax to allow cartesian…
jgtrz
  • 365
  • 6
  • 19
1
vote
1 answer

How to copy data between two vectors faster?

I have a data frame with 3 columns (username, IP_Address, IP_type). The column IP_Address has some NA values. for each row in IP_Address, if the value is NA, I want to copy the corresponding value from the column, username. I am using the following…
Yaswanth
  • 41
  • 1
  • 5
1
vote
2 answers

How to edit the values in one column when a certain value is realised in another in pandas DataFrame?

I have the following DataFrame with several columns beyond the ones included here: Col2 Col3 Col4 0 3682 US91892 US 1 7568 US91234 US 2 3546 UKIPD GB 3 7892 UKI43 GB 4 1243 US92345 US For…
Philip09
  • 85
  • 9
1
vote
1 answer

Split into new columns

In order to split cell into new columns, I use the following code: | Column1 | Column2 | a;b;c;d;e;f | 1;2;3;4 df = pd.read_excel('FileName.xlsx') new = df["Column1"].str.split(";", n=5, expand=True). df['1st'] = new[0] df['2nd'] =…
YIPYIP
  • 57
  • 4
1
vote
2 answers

Is there an R function that reads a specific value and move to the next column?

I would like to know if R could read a specific value by column in the matrix (the value will only read one specific value (more than x) before moving to the next column). This values can only be acknowledged once before moving to the next column.…
Fincoder07
  • 85
  • 7
1
vote
1 answer

Expanding all columns simultaneously in Power Query

Need help expanding all columns in a spreadsheet simultaneously using Power Query. I have transposed the spreadsheet from this: to this: Each table is a long column of values (9,000+ rows). I would like each column to be a separate ID. Expanding…
Patricia P
  • 25
  • 5
1
vote
1 answer

T test using column variable from 2 different data frames in R

I am attempting to conduct a t test in R to try and determine whether there is a statistically significant difference in salary between US and foreign born workers in the Western US. I have 2 different data frames for the two groups based on…
juliah0494
  • 175
  • 11
1
vote
1 answer

How to compare and assign/sort multiple columns with bash?

unfortunately I could not find any post for my specific issue. Maybe I used the wrong strings for the search. Nevertheless, here is the problem: I have a file with 3 columns. I would like to sort the columns in the following way: This is my sorted…
Jules
  • 11
  • 1
1
vote
1 answer

Unique values two columns combobox vba

I need to display two columns A and B listed in a combobox with unique values. So if two rows have the same A but not the same B, it is not a duplicate, both column need to be duplicate. I found a code that list one column (A) with unique values but…
Lawrence231
  • 31
  • 7
1
vote
1 answer

Summarise groups across columns and rows

I have a dataframe df where: Year Score x1 x2 x3 2006 102 K P 8 2006 89 L K P 2006 46 P 3 0 2007 76 L 2 1 2007 29 L K 6 2008 …
keaton
  • 47
  • 4
1
vote
2 answers

Count values across multiple columns

I have a dataframe df where: a b x 4 102 K 6 89 L, K, P 7 46 P 9 76 L 0 29 L, K 1 690 P 0 301 K I have used recast() to transform it where: a K P L L, K, P L, K 4 102 6 89 7 46 9 …
keaton
  • 47
  • 4
1
vote
2 answers

Adding Multiple Columns at Specific Locations in CSV file using Pandas

I am trying to place multiple columns (Score1, Score2, Score3 etc) before columns whose name begins with a certain text e.g.: Certainty. I can insert columns at fixed locations using: df.insert(17, "Score1", " ") Adding a column then changes the…
astro
  • 39
  • 4
1
vote
1 answer

Compare multiple columns and create new ones in R

I have a big dataset of measured data at the Start (A) and the end(B) in replicates. Now I want to sort my datarows into "appeared in the end"(appeard) and "still present"(present) and pass the data into new columns. data<-data.frame(A1=c(1,2,4), …
MKnK
  • 25
  • 3
1
vote
1 answer

Copying column that have NaN value in it and adding prefix

I have x number of columns that contain NaN value With the following code i can check that for index,value in df.iteritems(): if value.isnull().values.any() == True: this will show me with Boolean values which volumns have NaN. If true I need…
Mihael Brkić
  • 23
  • 2
1 2 3
…
99
100