Getting duplicate data from csv file

Question

def general_number(request):
    csvfilename = 'algo/generalnumber.csv'
    csvfile = open(csvfilename, 'r')
    reader = csv.DictReader(csvfile)
    fieldnames = ("Ticker","Company","Industry","PreviousClose","Open","Bid","Ask","DaysRange","ftWeekRange","Volume","AvgVolume","MarketCap","Beta","PERatioTTM","EPSTTM","EarningsDate","ForwardDividendYield","ExDividendDate","OneyTargetEst","ticker_company")
    output = []
    for each in reader:
      row = {}
      for field in fieldnames:
        row[field] = each[field]
        output.append(row)
    return JsonResponse(output[20:30],safe=False)

Here I am getting duplicate data in json from csv. Each datum is showing 10 times. What is wrong in this?

no. here it will give error if i will put indentation afetr row[field] — Soubhagya Pradhan
– Soubhagya Pradhan, Commented Oct 1, 2018 at 16:45

Irfanuddin · Accepted Answer · 2018-10-01 17:01:44Z

1

It's just an indentation problem. Fixed it, try now!

def general_number(request):
    csvfilename = 'algo/generalnumber.csv'
    csvfile = open(csvfilename, 'r')
    reader = csv.DictReader(csvfile)
    fieldnames = ("Ticker","Company","Industry","PreviousClose","Open","Bid","Ask","DaysRange","ftWeekRange","Volume","AvgVolume","MarketCap","Beta","PERatioTTM","EPSTTM","EarningsDate","ForwardDividendYield","ExDividendDate","OneyTargetEst","ticker_company")
    output = []
    for each in reader:
      row = {}
      for field in fieldnames:
        row[field] = each[field]
      output.append(row)
    return JsonResponse(output[20:30],safe=False)

edited Oct 1, 2018 at 17:01

answered Oct 1, 2018 at 16:46

Irfanuddin

2,6353 gold badges18 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting duplicate data from csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related