Mini$-$Project $3$

Restaurant Tips

Accessing data is a necessary first step for using most of the tools we have learned so far. In this mini$-$

project, we will use comma$-$separated form file that can be loaded into a DataFrame with

pandas.read$\_$csv$.$ We then use the dataset to do some data analysis and visualization using pandas.

Typically, the file will not always have a header row.

Consider an excel file: ex$1.$csv with the following cells:

$1,2,3,4,$ hello

$5,6,7,8,$ world

$9,10,11,12,$ foo

To read this file from your local drive and path, you can allow pandas to assign default column names:

In: pd$.$read$\_$csv$(\text{'}$C:$/$Users$/$mowaf$/$Data$/$ex$1.$csv$\text{'},$ header$=$None$)$

Out:

$01234$

$01234$ hello

$15678$ world

$29101112$ foo

Or you can specify names yourself:

In: pd$.$read$\_$csv$(\text{'}$C:$/$Users$/$mowaf$/$Data ex$1.$csv$\text{'},$ names$=[\text{'}$a$\text{'},\text{'}$b$\text{'},\text{'}$c$\text{'},\text{'}$d$\text{'},$ 'message'$])$

Out:

a bcd message

$01234$ hello

$15678$ world

$29101112$ foo