Questions tagged [columnsorting]

Column sorting refers to any columns based technique that sorts a list of data based on its individual column values.

Column sorting refers to any columns based technique that sorts a list of data based on its individual column values.

375 questions
-1
votes
2 answers

Swift - Sorting NSMutableArray with objects in it

I have a fruit object in swift with var title: String? var desc: String? variables I have it in a fruitsArray which is an NSMutableArray. I want to sort out these fruit objects alphabetically depending on their title. I need to do this both…
Big Green Alligator
  • 1,015
  • 2
  • 16
  • 30
-1
votes
1 answer

How to insert all unique symbols ever used in all rows from one column into another

I am looking to find what unique symbols are used in values of 2 table columns and I'd like to extract them in a .csv format. I have a table with lots of names and codes and I'd like to see each unique character ever used for each column printed…
-1
votes
1 answer

Sorting currency in VB.NET

I'm having difficulty addressing the issue of a currency sorting problem within our in-house software package. The software in question is written using VB.NET and the values are contained within DataGridView, the relevant code is: SQLReader.Read()…
-1
votes
2 answers

sorting not all of columns in datagridview

It is possible to sort a DataGridView by clicking on one of its ColumnHeaderCell. But I would like one column, containing the index of each row, to remain fixed. What I mean is that when I click on another column header the grid rows should be…
AhmadReza
  • 21
  • 1
-1
votes
1 answer

Sort a column in Listview Vb.net?

Sorry i think this might be duplicate question. I think so. Well i have done datagrid columns and it was able to sort with the code below but i tried to to this for lisview but it dosent seem to work. I want to sort list view based on a button click…
shaik ibrahim
  • 187
  • 5
  • 10
  • 30
-2
votes
1 answer

Manually Sorting Strings in Column in Dataframe

I would like to sort these strings in this column in my dataframe. I want to sort by income either lowest to high or high to low - doesn't matter. Minimal Reproducible Sample K_INCOME COFFEE_CONSUMER_CATEGORY HHID_COUNT 1 100,000−…
Greg
  • 23
  • 4
-2
votes
1 answer

Sorting alphanumeric text in MS excel using VBA or manually

I have alphanumeric text in a column in Excel. I need to sort them in alphabetic order and also numerically. The only way I could do this is by extract number to another column and then sort it, but it is not feasible for me as there same number may…
Ash Sooraj
  • 35
  • 8
-2
votes
2 answers

Python filter array objects

I pull the following data from a Database EventTime UserID SubAddr 2018-05-04 16:47:56.000 113 1 2018-05-04 16:48:45.000 113 2 2018-05-04 16:49:17.000 113 1 2018-05-04 16:49:27.000 113 2 2018-05-04 16:49:48.000 113 1 2018-05-04 16:49:57.000 113…
Laurens
  • 23
  • 5
-2
votes
1 answer

sorting and cleaning of data

I am new to this group and I am a budding python programmer. I am stuck with a small assignment which I have to finish. Below are the issues I am facing. Also please see the code which I have written. import pandas as pd import numpy as np data =…
Nancy
  • 1
  • 1
-2
votes
2 answers

How to sort multiple columns in Excel by matching value

I am doing data clean up. I collected data from multiple excel spreadsheets. I am trying to achieve sorting on the basis on exact match i.e. **Original dataset** FirstName_Store1 FirstName_Store2 FirstName_Store3 Aat Cat …
gaten
  • 59
  • 10
-2
votes
1 answer

Get values from columns excel

i have 2 columns A and B with names. I want in column C to have all the names from columns A and B in alphabetic order no matter if are present in more than one cell. So if i have mike1 in more than one cell in A or/and B it should be only one time…
wittman
  • 225
  • 5
  • 25
-3
votes
1 answer

In R, how can I label/rename all variables in a column that begin with a particular letter/word?

I am trying to group certain products based on their brands. Even after cleaning the data, there are a large number of spelling/spacing errors under the product name. Which makes it hard to categorise into a brand. Can anyone please guide me here ?…
Urb_Ink
  • 23
  • 5
-3
votes
2 answers

MySql: Group By with sorting

i've got some trouble in group by Table VS Wanted Result //table ID | Quantity | Price ----+----------+--------- 1902| 2 | 100 1915| 1 | 20 2010| 2 | 30 2052| 3 | 20 //Wanted result ID | Quantity |…
-3
votes
1 answer

Other column order than expected

I got a tables MPDAT_ALT with columns R_ID, CUSTOMER, ORDER_DATE, ORDER_ID. CUSTOMER has column_id '1', R_ID '2', ORDER_DATE '3', ORDER_ID '4'. But the data is shown with the the following column order: R_ID, CUSTOMER, ORDER_DATE, ORDER_ID. Why is…
Ben C.
  • 291
  • 2
  • 11
-5
votes
2 answers

Matrix sorting in C

I have a matrix like the below Col1 Col2 Col3 5 10 3 2 4 0 7 14 0 2 6 1 1 2 1 4 8 2 6 12 3 I want to sort the matrix based in ascending order based on the Col2. The matrix should look like Col1…
Anil Pediredla
  • 483
  • 5
  • 17
1 2 3
24
25