Mdthbs

Can Fabled Passage generate two mana with Amulet of Vigor?

Manager told a colleague of mine I was getting fired soon

Where does the image of a data connector as a sharp metal spike originate from?

In search of a pedagogically simple example of asymmetric encryption routine?

What would the EU’s position be with respect to a United Ireland?

Driving test in New Zealand?

Why is my vegetable stock bitter, but the chicken stock not?

Did S. Lang prove Kuratowski–Zorn lemma without Axiom of choice or Well-ordering theorem?

SHA3-255, one bit less

Are there manual checks for non EU citizens in airports when travelling inside the EU?

Can I voluntarily exit from the US after a 20 year overstay, or could I be detained at the airport?

Anonymous reviewer disclosed his identity. Should I thank him by name?

Determining if auto stats update is in progress

Advices to added homemade symbols

Was Smaug sealed inside the Lonely Mountain?

Does it require less energy to reach the Sun from Pluto's orbit than from Earth's orbit?

Notation clarity question for a conglomerate of accidentals

Quote to show students don't have to fear making mistakes

Has Boris Johnson ever referred to any of his opponents as "traitors"?

Lighthouse Alternatives

Search for something difficult to count/estimate

Why do many websites hide input when entering a OTP

How dangerous are my worn rims?

Bothered by watching coworkers slacking off

Error while counting the unique values in all columns in csv file

CSV file + set CSV parameters and values in bash scriptcsv file with multiple columns to zenityError while counting characters in a fileRemove Columns from a CSV FileBash-search and replace-Merge columns in CSV fileFind count of unique values in columns based on date in column 1extract columns from csv to a text fileCounting unique values in all columns of a csv file

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{
margin-bottom:0;
}

0

I have a dataset student.csv which contains details of 1000 students i.e with 1000 rows and 10 columns.

The sample data is given below:

s_id,S_name,S_dob,s_class,s_marks,

   1,abc,1/1/18,5,49,

   2,xyz,1/1/17,4,85,

   3,pqr,1/2/18,2,78,

So I want to count unique values in all the columns. I tried to use

csvstat --unique student.csv

It gave an error "Your file is not utf-8 encoded". When I tried to convert the encoding to utf-8 using "iconv", it is then giving an error "illegal input sequence" which i'm unable to solve.

Any help regarding this matter would be great.
The expected out is

s_id 3

s_name 3

.

.

.

Thanks.

linux bash awk csv

share|improve this question

asked 27 mins ago

ramu suriramu suri

1

New contributor

ramu suri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment
 | 

0

I have a dataset student.csv which contains details of 1000 students i.e with 1000 rows and 10 columns.

The sample data is given below:

s_id,S_name,S_dob,s_class,s_marks,

   1,abc,1/1/18,5,49,

   2,xyz,1/1/17,4,85,

   3,pqr,1/2/18,2,78,

So I want to count unique values in all the columns. I tried to use

csvstat --unique student.csv

It gave an error "Your file is not utf-8 encoded". When I tried to convert the encoding to utf-8 using "iconv", it is then giving an error "illegal input sequence" which i'm unable to solve.

Any help regarding this matter would be great.
The expected out is

s_id 3

s_name 3

.

.

.

Thanks.

linux bash awk csv

share|improve this question

asked 27 mins ago

ramu suriramu suri

1

New contributor

ramu suri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment
 | 

I have a dataset student.csv which contains details of 1000 students i.e with 1000 rows and 10 columns.

The sample data is given below:

s_id,S_name,S_dob,s_class,s_marks,

   1,abc,1/1/18,5,49,

   2,xyz,1/1/17,4,85,

   3,pqr,1/2/18,2,78,

So I want to count unique values in all the columns. I tried to use

csvstat --unique student.csv

It gave an error "Your file is not utf-8 encoded". When I tried to convert the encoding to utf-8 using "iconv", it is then giving an error "illegal input sequence" which i'm unable to solve.

Any help regarding this matter would be great.
The expected out is

s_id 3

s_name 3

.

.

.

Thanks.

linux bash awk csv

share|improve this question

asked 27 mins ago

ramu suriramu suri

1

New contributor

ramu suri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

s_id,S_name,S_dob,s_class,s_marks,

   1,abc,1/1/18,5,49,

   2,xyz,1/1/17,4,85,

   3,pqr,1/2/18,2,78,

s_id 3

s_name 3

.

.

.

share|improve this question

asked 27 mins ago

ramu suriramu suri

1

New contributor

ramu suri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 27 mins ago

ramu suriramu suri

1

New contributor

ramu suri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 27 mins ago

ramu suriramu suri

1

New contributor

ramu suri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 27 mins ago

ramu suriramu suri

1