import numpy as np
import pandas as pd
import matplotlib
from matplotlib import pyplot as plt, ticker
from matplotlib.ticker import ScalarFormatter
data = pd.read_excel("直方图数据.xlsx")
bins = 10 ** np.arange(-3, 3, 0.05)
f, ax = plt.subplots(1, 1)
plt.hist(data[0], bins=bins, edgecolor="black", range=(0, 100), rwidth=1, color="#CCCCCC")
plt.xscale("log")
plt.xlim((0.001, 1000))
plt.xlabel("$\mathregular{R}$(mm $\mathregular{h^-}$$\mathregular{^1}$)")
plt.ylabel("Differential water column (mm/(mm $\mathregular{h^-}$$\mathregular{^1}$)")
plt.rcParams['xtick.direction'] = "in"
plt.rcParams['ytick.direction'] = "in"
plt.text(0.0015, 67, "500m")
ax.xaxis.set_major_formatter(ScalarFormatter())
ax.xaxis.set_major_formatter(ticker.FuncFormatter(lambda y, _: '{:g}'.format(y)))
plt.savefig("hist.png")
plt.show()
