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

Utilisateur anonyme · Accepted Answer

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

Utilisateur anonyme · 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])

Utilisateur anonyme · Answer

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

Utilisateur anonyme · Answer

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

Google

Question d’entretien chez Google

Réponses aux questions d'entretien

Entreprises suivies

Recherche d’emplois