Advertisement
kadyr

Untitled

Mar 13th, 2023
1,073
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.83 KB | None | 0 0
  1.  
  2. def distance (x1,y1,x2,y2): #функция для вычисления расстояния между координатами
  3.    dist = ((((x2-x1)**2) + ((y2-y1)**2))**(1/2))
  4.    return dist
  5. def spisok (stroka):
  6.     stroka = stroka.replace(',', '')
  7.     stroka = stroka.replace('[', '')
  8.     stroka = stroka.replace(']', '')
  9.     stroka = stroka.split()
  10.     stroka = list(map(float, stroka))
  11.     return stroka
  12. # import pandas as pd
  13. # import numpy as np
  14. import csv
  15. i=0
  16. pogr = []
  17.  
  18.  
  19. with open('2.csv', 'r') as csvFile: #открываю файл из архива с данными
  20.     dictReader = csv.DictReader(csvFile)
  21.     for key in dictReader:
  22.         if i<=319:  # 1.1 1.2
  23.             a= spisok(((key['GPS'])))
  24.             el = distance(55.642242,37.39408,a[0],a[1])
  25.             pogr.append(el)
  26.             i+=1
  27.         elif (i > 319) and (i <= 668): #2.1 2.2
  28.             a = spisok(((key['GPS'])))
  29.             el = distance(55.604025,37.41843,a[0],a[1])
  30.             pogr.append(el)
  31.             i+=1
  32.         elif (i<=824)and (i > 668):#2.1 2.2
  33.             a = spisok(((key['GPS'])))
  34.             el = distance(55.547298, 37.482864,a[0],a[1])
  35.             pogr.append(el)
  36.             i+=1
  37. # pogr.insert(0,'pogreshnost')
  38.  
  39. with open('2.csv', 'r') as csvFile:
  40.     infileReader = csv.reader(csvFile)
  41.     rows = list(infileReader)
  42.  
  43. header = rows[0]
  44. header.append("Distance")
  45.  
  46. for i in range(1, len(rows)):
  47.     rows[i].append(pogr[i])
  48.  
  49. with open('2.csv', 'w', newline='') as outputFile:
  50.     writer = csv.writer(outputFile)
  51.     writer.writerows(rows)
  52. # print(pogr)
  53.  
  54. # from itertools import zip_longest
  55. # r=zip(pogr)
  56. # file=open('2.csv', 'a')
  57. # w = csv.writer(file)
  58. # for row in r:
  59. #         w.writerow(row)
  60. # file.close()
  61. # # ser = pd.Series(pogr,index=file.index)
  62. # # file.loc[:, 'pogr'] = ser
  63. # # df['pogr'] = pogr
  64.  
  65.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement