Getting "newline inside string" while reading the csv file in Python?

csv, django, python, python-2.7

Solution

You can preprocess the csv by removing the newline like below.

import csv

content = open("GeoIPCountryWhois.csv", "r").read().replace('\r\n','\n')

with open("GeoIPCountryWhois2.csv", "w") as g:
    g.write(content)

Then Use GeoIPCountryWhois2 for csv reader.

A wild Guess using a lineterminator may solve your problem

for num,row in enumerate(csv.reader(f,lineterminator='\n'))

See also: http://docs.python.org/lib/csv-fmt-params.html

Problem

I have this utils.py file in Django Architecture: ``` def range_data(ip): r = [] f = open(os.path.join(settings.PROJECT_ROOT, 'static', 'csv ', 'GeoIPCountryWhois.csv')) for num,row in enumerate(csv.reader(f)): if row[0] <= ip <= row[1]: r.append([r[4]]) return r else: continue return r ``` Here the ip parameter is just the IPv4 Address, I am using open source MAXMIND `GeoIPCountrywhois.csv` file. Some starting content of `GeopIOCountrywhois.csv`: ``` "1.0.0.0","1.0.0.255","16777216","16777471","AU","Australia" "1.0.1.0","1.0.3.255","16777472","16778239","CN","China" "1.0.4.0","1.0.7.255","16778240","16779263","AU","Australia" "1.0.8.0","1.0.15.255","16779264","16781311","CN","China" "1.0.16.0","1.0.31.255","16781312","16785407","JP","Japan" "1.0.32.0","1.0.63.255","16785408","16793599","CN","China" "1.0.64.0","1.0.127.255","16793600","16809983","JP","Japan" "1.0.128.0","1.0.255.255","16809984","16842751","TH","Thailand" ``` I have also read about the issue, But didn't found so much understandable. Would you please help me to solve that error? According to my method in utils, I am checking country name of paasing parameter `IP` address to the method.

Original source