How to work with csv file inside a folder in usb (Pendrive) using python

Question

I do have a folder name csvcontainer inside a Pendrive having two CSV files in it I like to read the data of these two CSV files using python I have successfully executed the below code I have installed pyusb

pyusb documentation

import usb.core
import usb.util

dev = usb.core.find(idVendor= 0x0781, idProduct=0x5567)

ep = dev[0].interfaces()[0].endpoints()[0]
i=dev[0].interfaces()[0].bInterfaceNumber
dev.reset()

if dev.is_kernel_driver_active(i):
    print("hello")

# grab the folder if device connected 
#loop it 
# read data of each csv/xls file

Optionally It would be more appreciated if anyhow we grab vendor id and product id programmatically using python