what we will make by the end of the day

Reading CSV Data in Python

main.py

with open("weather_data.csv") as data_file:
	data = data_file.readlines()
	print(data)

===================================================

['day,temp,condition\\n', 'Monday,12,Sunny\\n', 'Tuesday,14,Rain\\n', 'Wednesday,15,Rain\\n', 'Thursday,14,Cloudy\\n', 'Friday,21,Sunny\\n', 'Saturday,22,Sunny\\n', 'Sunday,24,Sunny']
main.py

import csv

with open("weather_data.csv") as data_file:
    data = csv.reader(data_file)
    for row in data:
        print(row)

====================================================

['day', 'temp', 'condition']
['Monday', '12', 'Sunny']
['Tuesday', '14', 'Rain']
['Wednesday', '15', 'Rain']
['Thursday', '14', 'Cloudy']
['Friday', '21', 'Sunny']
['Saturday', '22', 'Sunny']
['Sunday', '24', 'Sunny']

小測試 將溫度新增到temperatures =[]

main.py

import csv

with open("weather_data.csv") as data_file:
    data = csv.reader(data_file)
    temperatures =[]
    for row in data:
        if row[1] != "temp":
            temperatures.append(int(row[1]))
            print(temperatures)

==============================================

[12]
[12, 14]
[12, 14, 15]
[12, 14, 15, 14]
[12, 14, 15, 14, 21]
[12, 14, 15, 14, 21, 22]
[12, 14, 15, 14, 21, 22, 24]

FireShot Capture 053 - 100 Days of Code_ The Complete Python Pro Bootcamp for 2022 - Udemy_ - www.udemy.com.png

main.py

import pandas
data = pandas.read_csv("weather_data.csv")
print(data)

========================================================

          day  temp condition
0     Monday    12     Sunny
1    Tuesday    14      Rain
2  Wednesday    15      Rain
3   Thursday    14    Cloudy
4     Friday    21     Sunny
5   Saturday    22     Sunny
6     Sunday    24     Sunny
main.py

import pandas
data = pandas.read_csv("weather_data.csv")
print(data["temp"])

=============================================================

0    12
1    14
2    15
3    14
4    21
5    22
6    24
Name: temp, dtype: int64

DataFrames & Series: Working with Rows & Columns

main.py

import pandas
data = pandas.read_csv("weather_data.csv")
print(type(data))
======================================================
<class 'pandas.core.frame.DataFrame'>
main.py

import pandas
data = pandas.read_csv("weather_data.csv")
print(type(data))
print(type(data["temp"]))

======================================================

<class 'pandas.core.frame.DataFrame'>
<class 'pandas.core.series.Series'>