How to isolate and exctract specific values from an Excel spreadsheet in Python

Question

I have a .csv with a list of 5,000 .jpg filenames (column M). This list is a subsample of a larger spreadsheet comprising ~60,000 rows (column H). I wish to attribute the respective 'Altitude' values (column K) to the relevant filenames in the subsample.

I have tried to achieve this within Excel without any results, how can I achieve this Pythonically?

Thanks,R

!!RESOLVED!!

Solution:

import numpy as np
import pandas as pd
import csv

subsample = pd.read_csv(r'C:UsersLaptopDocumentsPythonSubsample.csv', usecols = [1])
file = pd.read_csv(r'C:UsersLaptopDocumentsPythonData.csv', usecols = [7, 10])

combine = pd.merge(subsample, file[['JPG', 'Altitude']], on='JPG', how='inner')
combine.to_csv(r'C:UsersLaptopDocumentsPythonAltitude_Data.csv', index=False)

question from:https://stackoverflow.com/questions/65829207/how-to-isolate-and-exctract-specific-values-from-an-excel-spreadsheet-in-python

Answer 1

Waitting for answers