-
Notifications
You must be signed in to change notification settings - Fork 0
/
Pandas IO.py
28 lines (18 loc) · 914 Bytes
/
Pandas IO.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
import pandas as pd
df = pd.read_csv("C:\\Users\\Administrator\\Desktop\\ZILL-Z77006_3B.csv")
print(df.head())
df.set_index("Date", inplace = True)
df.to_csv("C:\\Users\\Administrator\\Desktop\\newcsv2.csv")
df = pd.read_csv("C:\\Users\\Administrator\\Desktop\\newcsv2.csv", index_col = 0)
print(df.head())
df.columns = ["Austin_HPI"]
print(df.head())
df.to_csv("C:\\Users\\Administrator\\Desktop\\newcsv3.csv")
df.to_csv("C:\\Users\\Administrator\\Desktop\\newcsv4.csv", header = False)
df = pd.read_csv("C:\\Users\\Administrator\\Desktop\\newcsv4.csv", names = ["Date", "Austin_HPI"], index_col = 0)
print(df.head())
df.to_html("C:\\Users\\Administrator\\Desktop\\example.html")
df = pd.read_csv("C:\\Users\\Administrator\\Desktop\\newcsv4.csv", names = ["Date","Austin_HPI"])
print(df.head())
df.rename(columns = {"Austin_HPI" : "323wer"}, inplace = True)
print(df.head())