python csv

[KINGLEBRON]

y the data for movies with a rank above 9 for a new file.

The dataset that im analyze contains rating on many movies obtained from IMDB.
The data fields are:

Votes: the number of people rating the movie
Rank: the averate rating of the movie
Title: the name of the movie
Year: the year in which the movie was released

the code i tried is:

1 2 3 4 5 6 7 8 9 10 11 12

import csv          filename = "IMDB.txt"    with open(filename, 'rt', encoding='utf-8-sig') as imdb_file:        imdb_reader = csv.DictReader(imdb_file, delimiter = '\t')        with open('new file.csv', 'w', newline='') as high_rank:            fieldnames = ['Votes', 'Rank', 'Title', 'Year']            writer = csv.DictWriter(high_rank, fieldnames=fieldnames)            writer.writeheader()            for line_number, current_row in enumerate (imdb_reader):                if(float(current_row['Rank']) > 9.0):                    csv_writer.writerow(dict(current_row))

but unfortunately its not working, what should i do ?

[heiner55]

We need a link to the imdb.txt.

[KINGLEBRON]

https://www.dropbox.com/s/65y4pi9o0kczz98/IMDB.txt?dl=0

[heiner55]

Your code is ok, except last line.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

#!/usr/bin/python3 import csv   filename = "IMDB.txt" with open(filename, 'rt', encoding='utf-8-sig') as imdb_file:    imdb_reader = csv.DictReader(imdb_file, delimiter = '\t')      with open('new file.csv', 'w', newline='') as high_rank:        fieldnames = ['Votes', 'Rank', 'Title', 'Year']        writer = csv.DictWriter(high_rank, fieldnames=fieldnames)        writer.writeheader()          for line_number, current_row in enumerate (imdb_reader):            if(float(current_row['Rank']) > 9.0):                writer.writerow(dict(current_row))

[KINGLEBRON]

[Image: 33008433.png]

still not working...

[heiner55]

I add: errors=replace: (https://docs.python.org/3/library/functions.html#open)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

#!/usr/bin/python3 import csv   filename = "IMDB.txt" with open(filename, 'rt', encoding='utf-8-sig', errors='replace') as imdb_file:    imdb_reader = csv.DictReader(imdb_file, delimiter = '\t')      with open('new file.csv', 'w', newline='') as high_rank:        fieldnames = ['Votes', 'Rank', 'Title', 'Year']        writer = csv.DictWriter(high_rank, fieldnames=fieldnames)        writer.writeheader()          for line_number, current_row in enumerate (imdb_reader):            if(float(current_row['Rank']) > 9.0):                writer.writerow(dict(current_row))

[KINGLEBRON]

I add: errors=replace: (https://docs.python.org/3/library/functions.html#open)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

#!/usr/bin/python3 import csv   filename = "IMDB.txt" with open(filename, 'rt', encoding='utf-8-sig', errors='replace') as imdb_file:    imdb_reader = csv.DictReader(imdb_file, delimiter = '\t')      with open('new file.csv', 'w', newline='') as high_rank:        fieldnames = ['Votes', 'Rank', 'Title', 'Year']        writer = csv.DictWriter(high_rank, fieldnames=fieldnames)        writer.writeheader()          for line_number, current_row in enumerate (imdb_reader):            if(float(current_row['Rank']) > 9.0):                writer.writerow(dict(current_row))

i didn't understand what should i do with this error?
thanks for your help!

[heiner55]

Glad to hear your code runs now ok.

[KINGLEBRON]

Glad to hear your code runs now ok.

now i get a new problem

UnicodeEncodeError: 'charmap' codec can't encode character '\u01e1' in position 6: character maps to <undefined>


you know what is the problem now ?

[heiner55]

Have you added error='replace' to line 5:

1	with open(filename, 'rt', encoding='utf-8-sig', errors='replace') as imdb_file: