File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
import pandas as pd
def check_missing(df):
# Convert the '관측시각' column to a datetime object
df['관측시각'] = pd.to_datetime(df['관측시각'], format='%Y%m%d%H%M')
# Calculate the difference between each row and its subsequent row
df['time_diff'] = df['관측시각'].diff()
# Check for differences that aren't 1 hour, excluding the first row
errors = df[df['time_diff'] != pd.Timedelta(hours=1)][1:]
if not errors.empty:
print("Errors found:")
print(errors[['관측시각', 'time_diff']])
return False
else:
print("All time differences are correct.")
return True
if __name__ == "__main__":
file = ".csv"
check_missing(file)