Sign up to +=1 for access to these, video downloads, and no ads. There exists 1 challenge(s) for this tutorial. Simple enough! If we enter something that doesn't exist, we get an ugly error. Print('The date of',whatColor,'is:',theDate) To instantiate a DataFrame from data with element order preserved use pd.readcsv (data, usecols 'foo', 'bar') 'foo', 'bar' for columns in 'foo', 'bar' order or pd.readcsv (data, usecols 'foo', 'bar') 'bar', 'foo' for 'bar', 'foo' order. WhatColor = input('What color do you wish to know the date of?:') Once we have this data, what can we do with it? Maybe we are curious about what color something was on a specific date.

Next, we will show how to pull out specific data from the spreadsheet and save it to a list variable: ReadCSV = csv.reader(csvfile, delimiter=',')Ībove, we've shown how to open a CSV file and read each row, as well as reference specific data on each row. The csv modules defines also the DictReader class, which let us map each row in a csv file to a dictionary, where the keys are the field names and the values are the their actual content in a row. Next, let's cover the reading of CSV files into memory: The one we used above is probably the easiest way we can use to read a csv file with python. Here is the sample code that matches the video:

CSV literally stands for comma separated variable, where the comma is what is known as a 'delimiter.' While you can also just simply use Python's split() function, to separate lines and data within each line, the CSV module can also be used to make things easy. This Python 3 tutorial covers how to read CSV data in from a file and then use it in Python.

Read csv in python