pandas 배우기

# import csv

# with open("C:\\Users\\PC\\Desktop\\erx\\ex_3\\weather_day.csv") as data_file:

#     data = csv.reader(data_file)

#     temperature = []

#     for row in data:

#         if row[1] != "temp":

#             temperature.append(int(row[1]))

#     print(temperature)

import pandas

data =pandas.read_csv("C:\\Users\\PC\\Desktop\\erx\\ex_3\\weather_day.csv")

print(data["temp"])

 

 

import pandas

data =pandas.read_csv("C:\\Users\\PC\\Desktop\\erx\\ex_3\\weather_day.csv")

# print(type(data))

# print (type(data["temp"]))

# data_dict = data.to_dict()

# print(data_dict)

# print("====================")

# temp_list=data["Temp"].to_list()

# print(len(temp_list))

# average=sum(temp_list)/len(temp_list)

# print(average)

# print(data["Temp"].max())

# print("====================")

# print(data["Condition"])

# print(data.Condition)

# print("====================")

# print(data[data.Day=="Monday"])

# print("====================")

# print(data[data.Temp==data.Temp.max()] )

# print("====================")

# monday=data[data.Day=="Monday"]

# print(monday.Condition)

# print("====================")

monday  = data[data.Day== "Monday"]

Monday_temp  = monday.Temp

print(Monday_temp*9/5 + 32)

 

 

 데이터 프레임 만들기

import pandas

data_ditc ={

    "student":["Amy","James","Angela"],

    "scores":[76,56,65]

}

data=pandas.DataFrame(data_ditc)

print(data)