We created this code in Python and I am trying to convert it into SAS programming: import pandas as pd from IPython.display import display import requests from io import StringIO def decoder(row): url = 'https://vpic.nhtsa.dot.gov/api/vehicles/DecodeVINValuesBatch/' post_fields = {'format': 'csv', 'data':f'{row["VIN"]},{row["VEH_YEAR"]}'} r = requests.post(url, data=post_fields) r1=StringIO(r.text) return pd.read_csv(r1) def main(): #data = pd.read_csv(StringIO('vin,year\n3GNDA13D76S000000,2006\n5XYKT3A12CG000000,2012')) vehFrame = pd.read_csv('N:\IanWork\VIN AND YEAR_2018_2022C.csv') #Takes the original vin list and puts it into the vehFrame dataframe decodedTest = vehFrame[['VIN', 'VEH_YEAR']].apply(decoder, axis=1) #Applies the decoder function/method to each row of the vehFrame and stores the result in decodedTest #USED FOR TESTING///////////////////////////////////////////// testFrame = vehFrame.iloc[0:500] decode100 = testFrame[['VIN', 'VEH_YEAR']].apply(decoder, axis = 1) test100 = pd.concat(decode100.tolist(), ignore_index=True) test100.query("vin = 4834") #///////////////////////////////////////////////////////////// #decoded = data[['vin', 'year']].apply(decoder, axis=1) #decData = pd.concat(decoded.tolist(), ignore_index=True) decCars = pd.concat(decodedTest.tolist(), ignore_index=True) #Takes the decodedTest list and reformats it into a dataframe called decCars decCars.to_csv('Decoded vins.csv', encoding = 'utf-8-sig') #Exports the decCars dataframe to a csv file #display(decData) #display(decData[['vin', 'modelyear']]) display(decCars[['vin', 'modelyear']])# if __name__ == '__main__': main()
... View more