Oct-16-2021, 10:07 AM
I am trying to visulaize my data and show some trend.. the problem is the data range is wide ..
The file link: [https://drive.google.com/file/d/14qYhFB_...sp=sharing][1]
Recency Frequency MonetaryValue
count 129314.000000 129314.000000 1.293140e+05
mean 2.307159 1.540290 1.834728e+03
std 1.101710 1.217529 1.198400e+04
min 1.000000 1.000000 5.500000e+00
25% 1.000000 1.000000 1.500000e+02
50% 2.000000 1.000000 1.500000e+02
75% 3.000000 2.000000 1.050000e+03
max 4.000000 37.000000 1.991736e+06
I would like to viuslize the Monetary, Frequency, and recency,,, I will put the sample code and resulted charts for Monetary
as seen on the chart, it is unclear at all !
Also, I tried the Histogram .. The same unclear visualization :(
-I would be glad for suggestion how to have more meanningful visualizations ..
Thanx
The file link: [https://drive.google.com/file/d/14qYhFB_...sp=sharing][1]
data_processocess.describe()result:
Recency Frequency MonetaryValue
count 129314.000000 129314.000000 1.293140e+05
mean 2.307159 1.540290 1.834728e+03
std 1.101710 1.217529 1.198400e+04
min 1.000000 1.000000 5.500000e+00
25% 1.000000 1.000000 1.500000e+02
50% 2.000000 1.000000 1.500000e+02
75% 3.000000 2.000000 1.050000e+03
max 4.000000 37.000000 1.991736e+06
I would like to viuslize the Monetary, Frequency, and recency,,, I will put the sample code and resulted charts for Monetary
fig = plt.figure() ax = fig.add_subplot(111) bp = ax.boxplot(data_process['MonetaryValue'], vert=False) # I tried vertical and Horizental orintation
as seen on the chart, it is unclear at all !
Also, I tried the Histogram .. The same unclear visualization :(
plt.hist(data_process['MonetaryValue']) plt.ylabel('Count') plt.xlabel('Money') plt.show()
-I would be glad for suggestion how to have more meanningful visualizations ..
Thanx