Xg3-2-2-1

import pandas as pd

df = pd.read_csv('data2.csv')
cp = df.iloc[:,1]
cp_ma7 = cp.rolling(7).mean()
print(cp_ma7)

---------------------------------------------------------------

Xg3-2-2-2

from matplotlib import rcParams

rcParams['font.family'] = 'sans-serif'
rcParams['font.sans-serif'] = ['Yu Gothic', 'Meiryo']

df['7Ԉړ'] = cp_ma7
df.plot(x='t', y=['Il', '7Ԉړ'], figsize=(9, 6))

---------------------------------------------------------------

Xg3-2-2-3

import pandas as pd

df = pd.read_csv('data3.csv')

---------------------------------------------------------------

df

---------------------------------------------------------------

Xg3-2-2-4

df[''] = df[''].str.replace('@', ' ')

---------------------------------------------------------------

df

---------------------------------------------------------------

Xg3-2-2-5

df = df.fillna({'g': df['g'].median()})

---------------------------------------------------------------

df

---------------------------------------------------------------

Xg3-2-2-6

print(df.isnull().sum())

---------------------------------------------------------------

Xg3-2-2-7

df.dropna()

---------------------------------------------------------------

Xg3-2-2-8

df = df.query('g < 200')

---------------------------------------------------------------

df

---------------------------------------------------------------

Xg3-2-2-9

thr = df['g'].quantile(0.95)
df = df.query('g < @thr')

---------------------------------------------------------------

df

---------------------------------------------------------------

Xg3-2-2-10

pd.get_dummies(df[''])

---------------------------------------------------------------

Xg3-2-2-11

pd.concat([df, pd.get_dummies(df[''])], axis=1)

---------------------------------------------------------------

Xg3-2-2-12

df_m = pd.read_csv('i}X^.csv')
df_t = pd.read_csv('.csv')
df = pd.merge(df_t, df_m, how='left', on='iID')

---------------------------------------------------------------

df

---------------------------------------------------------------
