すま～と おんしつどけい の むにゃ
ぱいそん
# =============== import
import os
# =============== CD チェンジディレクトリ
os.chdir('C:\\pypy\\000-防水温湿度計')
cwd = os.getcwd()
# print(cwd)
# ===============
with open("temp data.csv", "r" , encoding='UTF-8') as f:
s = f.read()
# ==========================================================
s = s.replace("[字]報道１９３０▼", "報道1930▽")
s = s.replace("Date","年月日")
s = s.replace("Temperature_Celsius(℃)","温度")
s = s.replace("Relative_Humidity(%)","湿度")
s = s.replace("DPT(℃)","ああ")
s = s.replace("VPD(kPa)","かか")
s = s.replace("Abs Humidity(g/m³)","ささ")
s = s.replace("2024-03-05 ","")
s = s.replace(":00","")
# =============== UTF-8 出力 拡張子 *.csv 出力 【 pandas の デフォリト が UTF-8】
with open("温度湿度-Replace.csv", "w", encoding='UTF-8') as f:
f.write(s)
# =============== END END END END END
# =============== グラフ作成
# =============== pip
# pip install matplotlib
# pip install japanize-matplotlib
# pip install jupyter notebook
# =============== import
import pandas as pd
import numpy as np
import os
import matplotlib.pyplot as plt
import japanize_matplotlib
# =============== CD チェンジディレクトリ
os.chdir('C:\\pypy\\000-防水温湿度計')
cwd = os.getcwd()
print(cwd)
# ==========================================================
# import の 直下
# 最大表示列の指定 None=制限なし
pd.set_option('display.max_columns', None)
# 表示行の指定 ５行
pd.set_option('display.max_rows', 2000)
# =============== ファイルの読み込み read_csv
df_temp = pd.read_csv('温度湿度-Replace.csv',encoding='utf-8')
# =============== dataframe series 変数 化
time_1 = df_temp["年月日"]
# print(time_1)
temp_1 = df_temp["温度"]
# print(temp_1)
temp_2 = df_temp["湿度"]
# print(temp_2)
# =============== 列の削除
df_temp_2 = df_temp.drop(columns=['ああ', 'かか', 'ささ'])
print(df_temp_2)
df_temp_2.to_csv('tmp_2-pandas-output.csv',encoding='utf-8',index=False)
# =============== グラフを描画
plt.plot(time_1, temp_1)
plt.xlabel('２４時間')
plt.ylabel('温度')
plt.title('一日の室温変化')
plt.grid(True)
plt.show()
# =============== END END END END END