# -*- coding: utf-8 -*-
"""
Created on Mon Aug  9 10:01:39 2021

@author: yanni
"""

import pandas as pd

# In[]

data=pd.DataFrame([1,2,"hello",4.5],columns=["number"],index=["a","b","c","d"])

# In[]

data1=pd.read_csv("D:\\python_project\\python_course\\class3\\data.csv")


# In[]

data.to_csv("D:\\python_project\\python_course\\class3\\data_first.csv")
# In[]

print(data1.index)

print(data1.columns)

print(data1.head(1))

print(data1["Name"])

print(data1["Name"].head())

print(data1.loc[0,"Age"])

print(data1.iloc[1,2])

print(data1.iloc[0:3,1:4])
# In[]

print(data1.isnull())

print(data1.dropna())

print(data1.fillna(0))

# In[]

tmp = data1.drop(2)
print(data1["Age"].sum())

print(data1["Age"].min())

print(data1["Age"].std())

print(data1["Age"].describe())

print(data1["Job"].describe())

m = data1["Age"].values

print(data1["Job"].unique())

# In[]