[Solved] Calculate the min, max and mean windspeeds and standard deviations

Load the data: df = pd.read_csv(‘wind_data.csv’) Convert date to datetime and set as the index df.date = pd.to_datetime(df.date) df.set_index(‘date’, drop=True, inplace=True) Create a DateFrame for 1961 df_1961 = df[df.index < pd.to_datetime(‘1962-01-01’)] Resample for statistical calculations df_1961.resample(‘W’).mean() df_1961.resample(‘W’).min() df_1961.resample(‘W’).max() df_1961.resample(‘W’).std() Plot the data for 1961: fix, axes = plt.subplots(12, 1, figsize=(15, 60), sharex=True) for name, ax … Read more

(Solved) How to make good reproducible pandas examples

Note: The ideas here are pretty generic for Stack Overflow, indeed questions. Disclaimer: Writing a good question is hard. The Good: do include small* example DataFrame, either as runnable code: In [1]: df = pd.DataFrame([[1, 2], [1, 3], [4, 6]], columns=[‘A’, ‘B’]) or make it “copy and pasteable” using pd.read_clipboard(sep=’\s\s+’), you can format the text … Read more