Python: read csv file

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

# This is a sample Python script. from os import listdir   import csv import numpy import pandas as pd # C:\\Users\\geovindu\\PycharmProjects\\pythonProjectLinuolin\\venv\data\\10.csv     def print_hi(name):     # Use a breakpoint in the code line below to debug your script.     print(f'Hi, {name}')  # Press Ctrl+F8 to toggle the breakpoint.       if __name__ == '__main__':     print_hi('PyCharm') fname=listdir('C:\\Users\\geovindu\\PycharmProjects\\pythonProjectLinuolin\\venv\data\\') for filename in fname:     print(filename)   with open('C:\\Users\\geovindu\\PycharmProjects\\pythonProjectLinuolin\\venv\data\\10.csv') as csv_file:     csv_reader = csv.reader(csv_file, delimiter=',')     line_count = 0     for row in csv_reader:         if line_count == 0:             print(f'Column {", ".join(row)}')             line_count += 1         else:             print(f'\t{row[0]},  {row[1]} ,{row[2]}.')             line_count += 1         if line_count == 4:             for rows in csv_reader:                 if line_count == 4:                     print(f'Column {", ".join(rows)}')                     line_count += 1                 else:                     print(f'\t{rows[0]} ,{rows[1]} , {rows[2]}, {rows[3]}, {rows[4]}, {rows[5]}, {rows[6]}, {rows[7]},{rows[8]}.')                     line_count += 1     print(f'Processed {line_count} lines.')       # See PyCharm help at https://www.jetbrains.com/help/pycharm/

　　

所有文件序列化

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

# This is a sample Python script. from os import listdir   import csv import numpy import pandas as pd # C:\\Users\\geovindu\\PycharmProjects\\pythonProjectLinuolin\\venv\data\\10.csv     def print_hi(name):     # Use a breakpoint in the code line below to debug your script.     print(f'Hi, {name}')  # Press Ctrl+F8 to toggle the breakpoint.       if __name__ == '__main__':     print_hi('PyCharm') fname=listdir('C:\\Users\\geovindu\\PycharmProjects\\pythonProjectLinuolin\\venv\data\\') for filename in fname:     print(filename)       with open('C:\\Users\\geovindu\\PycharmProjects\\pythonProjectLinuolin\\venv\data\\'+filename) as csv_file:         csv_reader = csv.reader(csv_file, delimiter=',')         line_count = 0         for row in csv_reader:              if line_count == 0:                  print(f'Column {", ".join(row)}')                  line_count += 1              else:                  print(f'\t{row[0]},  {row[1]} ,{row[2]}.')                  line_count += 1              if line_count == 4:                 for rows in csv_reader:                     if line_count == 4:                          print(f'Column {", ".join(rows)}')                          line_count += 1                     else:                          print(f'\t{rows[0]} ,{rows[1]} , {rows[2]}, {rows[3]}, {rows[4]}, {rows[5]}, {rows[6]}, {rows[7]},{rows[8]}.')                          line_count += 1         print(f'Processed {line_count} lines.')