1 Programming, I chosen python. How to get top ten data (from last column) from comma separated flat file

Question

1 Programming, I chosen python.  How to get top ten data (from last column) from comma separated flat file

Anonymous · Accepted Answer

abc.csv - CSV file name 

import pandas as pd 

df = pd.read_csv('abc.csv')

df.iloc[:,-1].head(10)

Anonymous · Answer

unix: awk -F',' '{print $NF}' test.csv |sort -r -n |head
Python:
f = open(r"test.csv", "r")
res=[]
for i in f:
    res.append(int(i.split(',')[-1].split('
')[0]))
print(sorted(res,reverse=True)[:10])

Anonymous · Answer

Could I know what do you mean by "from last column" here? Thanks

Anonymous · Answer

Huh, I got it

cat file | awk -F',' '{print $NF}' | sort | head -n 10

Google

Google Interview Question

Interview Answers

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches