CSV文件未显示在文件位置

Question

因此，我正在编写一个脚本，当在AirSim中运行的模拟运行时，该脚本也会运行。它不断地收集数据(理论上)并将其写入csv文件。但是，当我转到应该保存它的位置时，却没有文件。例如，即使我的保存数据的方法中有错误，文件本身也不在那里。

import setup_path
import airsim


import numpy as np
import os
import os.path
import string
import csv
import tempfile
import pprint
import csv
import datetime

client = airsim.MultirotorClient()
client.confirmConnection()
'''
First create a directory for all the csv files to store into.
''' 

dirmain = r"C:\AirSimData"
if not os.path.exists(dirmain):
    os.mkdir(dirmain)


'''
Create format for file names
'''
run_date_and_time = datetime.datetime.now()
run_date_and_time_string = str(run_date_and_time)
extension = ".csv"
file_name_base = run_date_and_time_string + extension

imu = "imu"
gps = "gps"
magnetometer = "magnetometer"
barometer = "barometer"

gps_file_name = gps + file_name_base

'''Create csv files
'''
gps_file = open(r"gps_file_name",'w')   

gps_header = ['lat','lon','alt']
with open(r"gps_file_name",'w') as gpscsvfile:
    gpscsvwriter = csv.writer(gpscsvfile)
    gpscsvwriter = gpscsvwriter.writerow(gps_header)    

gpscsvfile.close()



while True: 
  

    #state = client.getMultirotorState()
    #s = pprint.pformat(state)
    #print("state: %s" % s)
    
   #imu_data = client.getImuData()
    #s = pprint.pformat(imu_data)
    #print("imu_data: %s" % s)

    #barometer_data = client.getBarometerData()
    #s = pprint.pformat(barometer_data)
    #print("barometer_data: %s" % s)

    #magnetometer_data = client.getMagnetometerData()
    #s = pprint.pformat(magnetometer_data)
    #print("magnetometer_data: %s" % s)

    gps_data = client.getGpsData().gnss.geo_point
    alt = (gps_data.altitude)
    lat = (gps_data.latitude)
    lon = (gps_data.longitude)
    gps_data_struct = [lat,lon,alt]
    
    with open(r"gps_file_name",'w') as gpscsvfile:
        gpscsvwriter = csv.writer(gpscsvfile)
        gpscsvwriter = gpscsvwriter.writerow(gps_data_struct)    

    gpscsvfile.close()

    #print("Altitude: %s\nLatitude %s\nLongitude %s" %(alt,lat,lon) )
    if False:
        break

Answer 1

在这里，您创建了一个文件名"gps_file_name“

with open(r"gps_file_name",'w') as gpscsvfile:
    gpscsvwriter = csv.writer(gpscsvfile)
    gpscsvwriter = gpscsvwriter.writerow(gps_header)   

您应该将变量与您创建的name元素一起使用。os.path.join()是连接文件名和路径名的安全方法。

gps_file_name = gps + file_name_base    
output_file = os.path.join(dirmain, gps_file_name)

# Should read something like this  "C:\AirSimData\gps2021-01-21 13:37:39.867152.csv"

然后你可以在这里使用它。

with open(output_file,'w') as gpscsvfile:
    gpscsvwriter = csv.writer(gpscsvfile)
    gpscsvwriter = gpscsvwriter.writerow(gps_header)    

gpscsvfile.close()

下一个问题是datetime字符串包含无效字符，因为文件名中不能使用冒号(:)。所以你需要重新考虑这一点。

一种选择是不使用冒号，让你的时间看起来像这样。

run_date_and_time_string = run_date_and_time.strftime('%y-%m-%d_%H%M%S')
# 'C:\\AirSimData\\gps21-01-21_134531.csv'