In [1]:
import pandas as pd

import matplotlib.pyplot as plt
import numpy as np

# Load master file
master_data = pd.read_csv('master_data.csv')

# Load data file containing references
data_file = pd.read_csv('tbl_data_retrival.csv')
In [85]:
import seaborn as sns
import textwrap
import warnings
warnings.filterwarnings("ignore")

def wrap_labels(ax, width, break_long_words=False):
    labels = []
    for label in ax.get_xticklabels():
        text = label.get_text()
        labels.append(textwrap.fill(text, width=width,
                      break_long_words=break_long_words))
    ax.set_xticklabels(labels, rotation=0)
    

col=data_file.columns.tolist()[5:]
inc=1
for c in col:
    filtered_df=master_data[master_data["cd_ext_id"]==c]
    column_name=filtered_df.iloc[0]["characterisation_descriptor"]
    colData=filtered_df.iloc[0]
    print(f"{inc}. COLUMN NAME - '{column_name}' (COLUMN_ID : {colData["cd_loc_id"]}) #{c}")
    print ("------------------------------------------------------------")

    inc+=1
    uq_data=data_file[c].value_counts().reset_index()
    uq_data.columns = ['cd_param_value', 'count']
    ab=filtered_df.drop(columns=["id","cd_loc_id","characterisation_descriptor","cd_ext_id"],axis=1)
    result_df= pd.merge(ab,uq_data,on="cd_param_value",how="left").fillna(0)
    display(result_df.head())
    result_df['count']=result_df['count'].astype(int)
    result_df['cd_param_name']=result_df['cd_param_name'].astype(str)

    fig, ax = plt.subplots(figsize=(6, 4))
    sns.barplot(x='cd_param_name', y='count',data=result_df, ax=ax)
    wrap_labels(ax, 10)
    ax.bar_label(ax.containers[0])
    ax.set_title("Distribution of - \'"+column_name+"\'")
    ax.set_xlabel("Parameter Name")
    plt.show()
    print ("------------------------------------------------------------")
1. COLUMN NAME - 'Leaf habit' (COLUMN_ID : 6.1.1 ) #cid101
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Erect 148.0
1 2 Intermediate 350.0
2 3 Drooping 91.0
3 4 Others 0.0
No description has been provided for this image
------------------------------------------------------------
2. COLUMN NAME - 'Dwarfism' (COLUMN_ID : 6.1.2) #cid102
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Normal: leaves not overlapped and leaf ratio i... 577
1 2 Dwarf type: leaves strongly overlapped and lea... 12
No description has been provided for this image
------------------------------------------------------------
3. COLUMN NAME - 'Pseudostem height (m)' (COLUMN_ID : 6.2.1) #cid103
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <2 48
1 2 2.1 to 2.9 273
2 3 >3 268
No description has been provided for this image
------------------------------------------------------------
4. COLUMN NAME - 'Pseudostem aspect' (COLUMN_ID : 6.2.2) #cid104
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Slender 68
1 2 Normal 289
2 3 Robust 232
No description has been provided for this image
------------------------------------------------------------
5. COLUMN NAME - 'Pseudostem colour' (COLUMN_ID : 6.2.3) #cid105
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Green-yellow 144.0
1 2 Medium Green 238.0
2 3 Green 121.0
3 4 Dark green 37.0
4 5 Green-red 8.0
No description has been provided for this image
------------------------------------------------------------
6. COLUMN NAME - 'Pseudostem appearance' (COLUMN_ID : 6.2.4) #cid106
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Dull (waxy) 174
1 2 Shiny (not waxy) 415
No description has been provided for this image
------------------------------------------------------------
7. COLUMN NAME - 'Predominant underlying colour of the pseudostem' (COLUMN_ID : 6.2.5) #cid107
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Watery green 189.0
1 2 Light green 319.0
2 3 Green 37.0
3 4 Cream 0.0
4 5 Pink-purple 21.0
No description has been provided for this image
------------------------------------------------------------
8. COLUMN NAME - 'Pigmentation of the underlying pseudostem' (COLUMN_ID : 6.2.6) #cid108
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Pink-purple 281
1 2 Red 8
2 3 Purple 7
3 4 Other 293
No description has been provided for this image
------------------------------------------------------------
9. COLUMN NAME - 'Sap colour' (COLUMN_ID : 6.2.7) #cid109
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Watery 589.0
1 2 Milky 0.0
2 3 Red-purple 0.0
3 4 Other (Yellow) 0.0
No description has been provided for this image
------------------------------------------------------------
10. COLUMN NAME - 'Wax on leaf sheaths' (COLUMN_ID : 6.2.8) #cid110
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Very little or no visible sign of wax 29
1 2 Very few wax 183
2 3 Moderately waxy 331
3 4 Very waxy 46
No description has been provided for this image
------------------------------------------------------------
11. COLUMN NAME - 'Position of suckers' (COLUMN_ID : 6.2.11) #cid111
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Far from parent plant (emerging > 50 cm from p... 26
1 2 Close to parent (vertical growth) 292
2 3 Close to parent(growing at an angle) 77
3 4 Far from the parent and emerging at angle. 194
No description has been provided for this image
------------------------------------------------------------
12. COLUMN NAME - 'Blotches at the petiole base' (COLUMN_ID : 6.3.1) #cid112
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Sparse blotching 5
1 2 Small blotches 147
2 3 Large blotches 292
3 4 Extensive pigmentation 141
4 5 Without pigmentation 4
No description has been provided for this image
------------------------------------------------------------
13. COLUMN NAME - 'Blotches colour' (COLUMN_ID : 6.3.2) #cid113
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Brown 17
1 2 Dark brown 3
2 3 Brown-black 453
3 4 Black-purple 21
4 5 Black 75
No description has been provided for this image
------------------------------------------------------------
14. COLUMN NAME - 'Petiole canal leaf III' (COLUMN_ID : 6.3.3) #cid114
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Open with margins spreading 237.0
1 2 Wide with erect margins 140.0
2 3 Straight with erect margins 153.0
3 4 Margins curved inward. 46.0
4 5 Margins overlapping 13.0
No description has been provided for this image
------------------------------------------------------------
15. COLUMN NAME - 'Petiole margins' (COLUMN_ID : 6.3.4) #cid115
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Winged and undulating 12.0
1 2 Winged and not clasping the pseudostem 206.0
2 3 Winged and clasping the pseudostem 371.0
3 4 Not winged and clasping the pseudostem 0.0
4 5 Not winged and not clasping the pseudostem 0.0
No description has been provided for this image
------------------------------------------------------------
16. COLUMN NAME - 'Wing type' (COLUMN_ID : 6.3.5) #cid116
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Dry 589.0
1 2 Notdry 0.0
No description has been provided for this image
------------------------------------------------------------
17. COLUMN NAME - 'Petiole margine colour' (COLUMN_ID : 6.3.6) #cid117
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Green 397.0
1 2 Pink-purple 192.0
2 3 Purple to blue 0.0
3 4 Brown black 0.0
4 5 others 0.0
No description has been provided for this image
------------------------------------------------------------
18. COLUMN NAME - 'Edge of pertiole margin' (COLUMN_ID : 6.3.7) #cid118
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Colourless(without a colour line along) 245
1 2 With a colour line along 344
No description has been provided for this image
------------------------------------------------------------
19. COLUMN NAME - 'Petiole margin width (cm)' (COLUMN_ID : 6.3.8) #cid119
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <1cm 335.0
1 2 > 1cm 254.0
2 3 Cannot be defined 0.0
No description has been provided for this image
------------------------------------------------------------
20. COLUMN NAME - 'Leaf blade length (cm)' (COLUMN_ID : 6.3.9) #cid120
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <170cm 208.0
1 2 171 to 220cm 342.0
2 3 221 to 260 cm 39.0
3 4 ≥261cm 0.0
No description has been provided for this image
------------------------------------------------------------
21. COLUMN NAME - 'Leaf blade width (cm)' (COLUMN_ID : 6.3.10) #cid121
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <70cm 258
1 2 71 to 80cm 311
2 3 81 to 90cm 15
3 4 >91cm 5
No description has been provided for this image
------------------------------------------------------------
22. COLUMN NAME - 'Petiole length (cm)' (COLUMN_ID : 6.3.11) #cid122
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 < 50cm 248
1 2 51-70cm 259
2 3 >71cm 82
No description has been provided for this image
------------------------------------------------------------
23. COLUMN NAME - 'Colour of leaf upper surface' (COLUMN_ID : 6.3.12) #cid123
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Green-yellow 0.0
1 2 Medium green 131.0
2 3 Green 265.0
3 4 Dark green 193.0
4 5 Dark green with red-purple (presence of large ... 0.0
No description has been provided for this image
------------------------------------------------------------
24. COLUMN NAME - 'Appearance of leaf upper surface' (COLUMN_ID : 6.3.13) #cid124
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Dull 312
1 2 Shiny 277
No description has been provided for this image
------------------------------------------------------------
25. COLUMN NAME - 'Colour of leaf lower surface' (COLUMN_ID : 6.3.14) #cid125
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Green-yellow 44.0
1 2 Medium green 237.0
2 3 Green 301.0
3 4 Dark green 7.0
4 5 Blue 0.0
No description has been provided for this image
------------------------------------------------------------
26. COLUMN NAME - 'Appearance of leaf lower surface' (COLUMN_ID : 6.3.15) #cid126
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Dull 564
1 2 Shiny 25
No description has been provided for this image
------------------------------------------------------------
27. COLUMN NAME - 'Wax on leaves' (COLUMN_ID : 6.3.16) #cid127
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 No or Very little sign of wax 48
1 2 Sparsely wax 319
2 3 Moderately waxy 201
3 4 Very waxy 21
No description has been provided for this image
------------------------------------------------------------
28. COLUMN NAME - 'Insertion point of leaf blades on petiole' (COLUMN_ID : 6.3.17) #cid128
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Symmetric 245
1 2 Asymmetric 344
No description has been provided for this image
------------------------------------------------------------
29. COLUMN NAME - 'Shape of leaf blade base' (COLUMN_ID : 6.3.18) #cid129
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Both sides rounded 218
1 2 One side rounded, one pointed 219
2 3 Both sides pointed 133
3 4 Auriculated rounded(both sides) 19
No description has been provided for this image
------------------------------------------------------------
30. COLUMN NAME - 'Colour of midrib dorsal surface' (COLUMN_ID : 6.3.20) #cid130
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Yellow 5.0
1 2 Light green 459.0
2 3 Green 82.0
3 4 Pink-purple 43.0
4 5 Red-purple 0.0
No description has been provided for this image
------------------------------------------------------------
31. COLUMN NAME - 'Colour of midrib ventral surface' (COLUMN_ID : 6.3.21) #cid131
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Yellow 1.0
1 2 Light green 148.0
2 3 Green 439.0
3 4 Pink-purple 1.0
4 6 Red-purple 0.0
No description has been provided for this image
------------------------------------------------------------
32. COLUMN NAME - 'Colour of cigar leaf dorsal surface' (COLUMN_ID : 6.3.22) #cid132
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Green 508.0
1 2 Red-purple 81.0
2 3 Other 0.0
No description has been provided for this image
------------------------------------------------------------
33. COLUMN NAME - 'Blotches on leaves of water suckers' (COLUMN_ID : 6.3.23) #cid133
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Without blotches 334
1 2 Little or narrow blotches 150
2 3 Large purple blotches 90
3 4 With small brown blotches 15
No description has been provided for this image
------------------------------------------------------------
34. COLUMN NAME - 'Peduncle length(cm)' (COLUMN_ID : 6.4.1) #cid134
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 30cm 231
1 2 31-60 cm 258
2 3 >61cm 100
No description has been provided for this image
------------------------------------------------------------
35. COLUMN NAME - 'Empty nodes on peduncle' (COLUMN_ID : 6.4.2) #cid135
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 0 47
1 2 one 347
2 3 two or more 195
No description has been provided for this image
------------------------------------------------------------
36. COLUMN NAME - 'Peduncle width (cm)' (COLUMN_ID : 6.4.3) #cid136
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <6cm 68
1 2 7-12 cm 323
2 3 >13 cm 197
No description has been provided for this image
------------------------------------------------------------
37. COLUMN NAME - 'Peduncle colour' (COLUMN_ID : 6.4.4) #cid137
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Light green 104.0
1 2 Green 246.0
2 3 Dark green 105.0
3 4 Red or pink/purple 14.0
4 5 With purple-brown to blue blotches 120.0
No description has been provided for this image
------------------------------------------------------------
38. COLUMN NAME - 'Pedencle hairiness' (COLUMN_ID : 6.4.5) #cid138
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Hairless 282
1 2 Slightly hairy 142
2 3 Very hairy, short hairs (similar to velvet touch) 122
3 4 Very hairy, long hairs (>2mm) 43
No description has been provided for this image
------------------------------------------------------------
39. COLUMN NAME - 'Bunch position' (COLUMN_ID : 6.4.6) #cid139
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Hanging vertically 225.0
1 2 Slightly angled 111.0
2 3 Hanging at angle 45°p 165.0
3 4 Horizontal 88.0
4 5 Erect 0.0
No description has been provided for this image
------------------------------------------------------------
40. COLUMN NAME - 'Bunch shape' (COLUMN_ID : 6.4.7) #cid140
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Cylindrical 400.0
1 2 Truncated cone shape 122.0
2 3 Asymmetric-Bunch axis is nearly straight 32.0
3 4 With a curve in the bunch axis 35.0
4 5 Spiral (all fruit is attached to a unique crow... 0.0
No description has been provided for this image
------------------------------------------------------------
41. COLUMN NAME - 'Bunch appearance' (COLUMN_ID : 6.4.8) #cid141
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Lax 356
1 2 Compact 123
2 3 Very compact 110
No description has been provided for this image
------------------------------------------------------------
42. COLUMN NAME - 'Flowers that form the fruit' (COLUMN_ID : 6.4.9) #cid142
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Female (absence of pollen sacs or pollens) 582
1 2 Hermaphrodite (presence of pollen sacs and pol... 7
No description has been provided for this image
------------------------------------------------------------
43. COLUMN NAME - 'Fruits' (COLUMN_ID : 6.4.10) #cid143
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Uniseriate 0.0
1 2 Biseriate 589.0
2 3 Biseriate and fused. 0.0
No description has been provided for this image
------------------------------------------------------------
44. COLUMN NAME - 'Rachis type' (COLUMN_ID : 6.4.11) #cid144
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Truncated, no bract scar below the last hand o... 8
1 2 Present and male bud may be degenerated or per... 581
No description has been provided for this image
------------------------------------------------------------
45. COLUMN NAME - 'Rachis position' (COLUMN_ID : 6.4.12) #cid145
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Falling vertically 431.0
1 2 At an angle 97.0
2 3 With a curve 45.0
3 4 Horizontal 8.0
4 5 Erect 0.0
No description has been provided for this image
------------------------------------------------------------
46. COLUMN NAME - 'Rachis appearance' (COLUMN_ID : 6.4.13) #cid146
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Bare 298.0
1 2 Neutral flowers (one to few hands only, stalk ... 202.0
2 3 Male flowers/bracts above the male bud (but th... 20.0
3 4 Neutral/male flowers and presence of withered ... 57.0
4 5 Neutral/male flowers on the whole stalk withou... 4.0
No description has been provided for this image
------------------------------------------------------------
47. COLUMN NAME - 'Male bud type' (COLUMN_ID : 6.4.14) #cid147
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Normal (present) 580
1 2 Degenerating before maturity like false-hom ’P... 1
2 3 Like true-horn "Plantain" (absent) 8
No description has been provided for this image
------------------------------------------------------------
48. COLUMN NAME - 'Male bud shape' (COLUMN_ID : 6.4.15) #cid148
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Like a top 112.0
1 2 Lanceolate 276.0
2 3 Intermediate 102.0
3 4 Ovoid 91.0
4 5 Rounded 0.0
No description has been provided for this image
------------------------------------------------------------
49. COLUMN NAME - 'Male bud size' (COLUMN_ID : 6.4.16) #cid149
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <20 cm 120
1 3 >31cm 77
2 2 21-30 cm 384
3 4 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
50. COLUMN NAME - 'Bract base shape' (COLUMN_ID : 6.5.1) #cid150
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Small 98
1 2 Medium 432
2 3 Large shoulder 51
3 4 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
51. COLUMN NAME - 'Bract apex shape' (COLUMN_ID : 6.5.2) #cid151
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Pointed 65
1 2 Slightly pointed 104
2 3 Intermediate 9
3 4 Obtuse 213
4 5 Obtuse and split 190
No description has been provided for this image
------------------------------------------------------------
52. COLUMN NAME - 'Bract imbrication' (COLUMN_ID : 6.5.3) #cid152
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Old bracts overlap at apex of bud (like Musa a... 71
1 2 Young bracts slightly overlap 497
2 3 Young bracts greatly overlap(like Musa acumina... 13
3 4 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
53. COLUMN NAME - 'Colour of the bract external face' (COLUMN_ID : 6.5.4) #cid153
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Yellow 0.0
1 2 Green 1.0
2 3 Red 0.0
3 4 Red-purple 136.0
4 5 Purple-brown 273.0
No description has been provided for this image
------------------------------------------------------------
54. COLUMN NAME - 'Colour of the bract internal face' (COLUMN_ID : 6.5.5) #cid154
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Whitish 21.0
1 2 Yellow or green 13.0
2 3 Orange red 137.0
3 4 Red 399.0
4 5 Purple 2.0
No description has been provided for this image
------------------------------------------------------------
55. COLUMN NAME - 'Colour on the bract apex' (COLUMN_ID : 6.5.6) #cid155
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Tinted with yellow (discoloured) 276
1 2 Not tinted with yellow (colour is uniform unti... 305
2 3 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
56. COLUMN NAME - 'Colour stripes on bract' (COLUMN_ID : 6.5.7) #cid156
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Without discoloured lines (not ridges) on the ... 508
1 2 With discoloured lines or stripes on the exter... 73
2 3 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
57. COLUMN NAME - 'Bract scars on rachis' (COLUMN_ID : 6.5.8) #cid157
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Very prominent 83
1 2 Not prominent 25
2 3 Medium 423
3 4 Not visible 50
4 5 Rachis and male bud absent 8
No description has been provided for this image
------------------------------------------------------------
58. COLUMN NAME - 'Fading of colour on bract base' (COLUMN_ID : 6.5.9) #cid158
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Colour discontinuing towards the base loss of ... 99
1 2 Colour homogenous (pigmentation is uniform and... 482
2 3 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
59. COLUMN NAME - 'Male bract shape' (COLUMN_ID : 6.5.10) #cid159
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 x/y <0.28 (lanceolate) 28
1 2 0.28, x/y <0.30 198
2 3 x/y > 0.30 (Ovate) 354
3 4 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
60. COLUMN NAME - 'Male bract lifting' (COLUMN_ID : 6.5.11) #cid160
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Not lifting from male bud (bracts are persistent) 24
1 2 Lifting one at a time 137
2 3 Lifting two or more at a time 420
3 4 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
61. COLUMN NAME - 'Bract behaviour before falling' (COLUMN_ID : 6.5.12) #cid161
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Revolute (rolling) 448
1 2 Notrevolute (not rolling) 133
2 3 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
62. COLUMN NAME - 'Wax on the bract' (COLUMN_ID : 6.5.13) #cid162
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Very little or no visible sign of wax 105
1 2 Very few wax 322
2 3 Moderately waxy 153
3 4 Very waxy 1
4 5 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
63. COLUMN NAME - 'Presence of grooves on the bract' (COLUMN_ID : 6.5.14) #cid163
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Few grooves or not grooved (the bract is compl... 125
1 2 Moderate grooving (parallel ridges are distigu... 323
2 3 Strongly grooved (deep parallel furrows on the... 133
3 4 Male bud absent 8
No description has been provided for this image
------------------------------------------------------------
64. COLUMN NAME - 'Male flower behaviour' (COLUMN_ID : 6.6.1) #cid164
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Falling before the bract 483
1 2 Falling with the bract 1
2 3 Falling after the bract 21
3 4 Neutral / male flowers persistent 67
4 5 More than 50% male flowers/bract above male bu... 9
No description has been provided for this image
------------------------------------------------------------
65. COLUMN NAME - 'Compound tepal basic colour' (COLUMN_ID : 6.6.2) #cid165
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 115.0
1 2 Cream 226.0
2 3 Yellow 0.0
3 4 Orange 14.0
4 5 Pink/pink-purple 226.0
No description has been provided for this image
------------------------------------------------------------
66. COLUMN NAME - 'Compound tepal pigmentation' (COLUMN_ID : 6.6.3) #cid166
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Very few or no visible sign of pigmentation 178.0
1 2 Rust-coloured spots 0.0
2 3 Presence of pink 403.0
3 4 Male bud and flowers absent 8.0
No description has been provided for this image
------------------------------------------------------------
67. COLUMN NAME - 'Lobe colour of compound tepal' (COLUMN_ID : 6.6.4) #cid167
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Cream 7.0
1 2 Yellow 415.0
2 3 Orange 152.0
3 4 Green 1.0
4 5 Yellow with pink 6.0
No description has been provided for this image
------------------------------------------------------------
68. COLUMN NAME - 'Lobe development of compound tepal' (COLUMN_ID : 6.6.5) #cid168
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Little or not visible sign of development 4
1 2 Developed 89
2 3 Very developed 488
3 4 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
69. COLUMN NAME - 'Free tepal colour' (COLUMN_ID : 6.6.6) #cid169
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Translucent white 174.0
1 2 Opaque white 198.0
2 3 Tinted with yellow 0.0
3 4 Tinted with pink 159.0
4 5 Full of pink 50.0
No description has been provided for this image
------------------------------------------------------------
70. COLUMN NAME - 'Free tepal shape' (COLUMN_ID : 6.6.7) #cid170
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Rectangular 199
1 2 Oval 268
2 3 Rounded 69
3 4 Fan-shaped 28
4 5 Bowl shaped 17
No description has been provided for this image
------------------------------------------------------------
71. COLUMN NAME - 'Free tepal appearance' (COLUMN_ID : 6.6.8) #cid171
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Simple folding under apex 493
1 2 More or less smooth 74
2 3 Several folding under apex(corrugate) 14
3 4 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
72. COLUMN NAME - 'Free tepal apex development' (COLUMN_ID : 6.6.9) #cid172
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Little or no visible sign of development 29
1 2 Developed 143
2 3 Very developed 409
3 4 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
73. COLUMN NAME - 'Free tepal apex shape' (COLUMN_ID : 6.6.10) #cid173
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Thread-like 451
1 2 Triangular 120
2 3 Obtuse 3
3 4 Spear shape 7
4 5 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
74. COLUMN NAME - 'Anther exertion' (COLUMN_ID : 6.6.11) #cid174
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Exserted 121
1 2 Same level 213
2 3 Inserted 247
3 4 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
75. COLUMN NAME - 'Filament colour' (COLUMN_ID : 6.6.12) #cid175
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 127
1 2 Cream 351
2 3 Yellow 2
3 4 Pink shaded 101
4 5 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
76. COLUMN NAME - 'Anther colour' (COLUMN_ID : 6.6.13) #cid176
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 5.0
1 2 Cream 516.0
2 3 Yellow 0.0
3 4 Grey 0.0
4 5 Brown/rusty brown 5.0
No description has been provided for this image
------------------------------------------------------------
77. COLUMN NAME - 'Pollan sac colour' (COLUMN_ID : 6.6.14) #cid177
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 0.0
1 2 Cream 326.0
2 3 Yellow 0.0
3 4 Brown/rusty brown 135.0
4 5 Pink/pink-purple 94.0
No description has been provided for this image
------------------------------------------------------------
78. COLUMN NAME - 'Style basic colour' (COLUMN_ID : 6.6.16) #cid178
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 550
1 2 Cream 10
2 3 Red-purple 16
3 4 White with pink 5
4 5 Male bud flowers absent 8
No description has been provided for this image
------------------------------------------------------------
79. COLUMN NAME - 'Pigmentation on style' (COLUMN_ID : 6.6.17) #cid179
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Without pigmentation. 328
1 2 Purple 253
2 3 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
80. COLUMN NAME - 'Style exertion' (COLUMN_ID : 6.6.18) #cid180
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Exserted 311
1 3 Inserted 8
2 2 Same level 262
3 4 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
81. COLUMN NAME - 'Style shape' (COLUMN_ID : 6.6.19) #cid181
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Straight 329.0
1 2 Curved under stigma 89.0
2 3 Curved at the base 0.0
3 4 Curved twice 31.0
4 5 Folded at middle 128.0
No description has been provided for this image
------------------------------------------------------------
82. COLUMN NAME - 'Stigma colour' (COLUMN_ID : 6.6.20) #cid182
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Cream 155.0
1 2 Yellow 25.0
2 3 Pink/pink-purple 4.0
3 4 Bright yellow 0.0
4 5 Orange 397.0
No description has been provided for this image
------------------------------------------------------------
83. COLUMN NAME - 'Ovary shape' (COLUMN_ID : 6.6.21) #cid183
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Straight 53
1 2 Arched 528
2 3 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
84. COLUMN NAME - 'Ovary basic colour' (COLUMN_ID : 6.6.22) #cid184
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 102.0
1 2 Cream 461.0
2 3 Yellow 0.0
3 4 Green 6.0
4 5 Other (Pink purple) 12.0
No description has been provided for this image
------------------------------------------------------------
85. COLUMN NAME - 'Ovary pigmentation' (COLUMN_ID : 6.6.23) #cid185
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Very few or no visible sign of pigmentation 242
1 2 With red-purple 339
2 3 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
86. COLUMN NAME - 'Dominant colour of male flower' (COLUMN_ID : 6.6.24) #cid186
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 54
1 2 Cream 201
2 3 Yellow 11
3 4 Pink/pink-purple 280
4 5 Red-purple 17
No description has been provided for this image
------------------------------------------------------------
87. COLUMN NAME - 'Irregular flowers' (COLUMN_ID : 6.6.25) #cid187
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Absent 484
1 2 Rare 57
2 3 Frequent 40
3 4 Male bud and flowers absent 8
No description has been provided for this image
------------------------------------------------------------
88. COLUMN NAME - 'Arrangement of ovules' (COLUMN_ID : 6.6.26) #cid188
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Two rowed 273
1 2 Four-rowed (more or less) 167
2 3 Irregular 149
No description has been provided for this image
------------------------------------------------------------
89. COLUMN NAME - 'Fruit position' (COLUMN_ID : 6.7.1) #cid189
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Curved towards stalk 319
1 2 Parallel to the stalk 52
2 3 Curved upward (obliquely, at a 45°angle upward) 208
3 4 Perpendicular to the axis 10
No description has been provided for this image
------------------------------------------------------------
90. COLUMN NAME - 'Number of fruits' (COLUMN_ID : 6.7.2) #cid190
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <12 54
1 2 13-16 496
2 3 ≥17 39
No description has been provided for this image
------------------------------------------------------------
91. COLUMN NAME - 'Fruit length(cm)' (COLUMN_ID : 6.7.3) #cid191
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <15cm 358.0
1 2 16-20cm 219.0
2 3 21-25cm 12.0
3 4 26-30cm 0.0
4 5 >31cm 0.0
No description has been provided for this image
------------------------------------------------------------
92. COLUMN NAME - 'Fruit shape (longitudinal curvature)' (COLUMN_ID : 6.7.4) #cid192
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Straight in the distal part 464
1 2 Curved (sharp curve) 85
2 3 Curved in "S" shape (double curvature) 40
No description has been provided for this image
------------------------------------------------------------
93. COLUMN NAME - 'Transerse section of fruit' (COLUMN_ID : 6.7.5) #cid193
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Pronounced ridges 368
1 2 Slightly ridges 89
2 3 Rounded 132
No description has been provided for this image
------------------------------------------------------------
94. COLUMN NAME - 'Fruit apex observed at the distal end of the fruit.' (COLUMN_ID : 6.7.6) #cid194
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Pointed 143
1 2 Lengthily pointed 185
2 3 Blunt-tipped 118
3 4 Bottle-necked 139
4 5 Rounded 4
No description has been provided for this image
------------------------------------------------------------
95. COLUMN NAME - 'Remains of flower relicts at fruit apex Observed at the distal end of the fruit' (COLUMN_ID : 6.7.7) #cid195
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Without any floral relicts 300
1 2 Persistent style 244
2 3 Base of the style prominent 45
No description has been provided for this image
------------------------------------------------------------
96. COLUMN NAME - 'Fruit pedicel length(mm)' (COLUMN_ID : 6.7.8) #cid196
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <10mm 224
1 2 11 to 20 mm 245
2 3 >21 mm 120
No description has been provided for this image
------------------------------------------------------------
97. COLUMN NAME - 'Fruit pedicel width(mm)' (COLUMN_ID : 6.7.9) #cid197
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <5mm 26
1 2 5 to 10mm 553
2 3 >10mm 10
No description has been provided for this image
------------------------------------------------------------
98. COLUMN NAME - 'Pedicel surface' (COLUMN_ID : 6.7.10) #cid198
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Hairless 275
1 2 Hairy 314
No description has been provided for this image
------------------------------------------------------------
99. COLUMN NAME - 'Fusion of pedicels' (COLUMN_ID : 6.7.11) #cid199
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Very partially or no visible sign of fusion 580.0
1 2 Partially fused 9.0
2 3 Totally fused 0.0
No description has been provided for this image
------------------------------------------------------------
100. COLUMN NAME - 'Immature fruit peel colour' (COLUMN_ID : 6.7.12) #cid200
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Yellow 0.0
1 2 Light green 78.0
2 3 Green 354.0
3 4 Green and pink, red ore purple 7.0
4 5 Silvery 80.0
No description has been provided for this image
------------------------------------------------------------
101. COLUMN NAME - 'Mature fruit peel colour' (COLUMN_ID : 6.7.13) #cid201
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Yellow 434.0
1 2 Bright Yellow 49.0
2 3 Orange 0.0
3 4 Grey spots 0.0
4 5 Brown/rusty-brown 10.0
No description has been provided for this image
------------------------------------------------------------
102. COLUMN NAME - 'Fruit peel thickness (mm)' (COLUMN_ID : 6.7.14) #cid202
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Two or less 146
1 2 3 to 4 331
2 3 more than 4 112
No description has been provided for this image
------------------------------------------------------------
103. COLUMN NAME - 'Adherence of the fruit peel' (COLUMN_ID : 6.7.15) #cid203
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Fruit peels easily 272
1 2 Fruit does not peel easily 317
No description has been provided for this image
------------------------------------------------------------
104. COLUMN NAME - 'Cracks in fruit peel' (COLUMN_ID : 6.7.16) #cid204
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Without cracks 443
1 2 Cracked 146
No description has been provided for this image
------------------------------------------------------------
105. COLUMN NAME - 'Pulp in fruit' (COLUMN_ID : 6.7.17) #cid205
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Without pulp 14
1 2 With pulp 575
No description has been provided for this image
------------------------------------------------------------
106. COLUMN NAME - 'Pulp colour before maturity' (COLUMN_ID : 6.7.18) #cid206
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 377.0
1 2 Cream 162.0
2 3 Ivory 50.0
3 4 Yellow 0.0
4 5 Orange 0.0
No description has been provided for this image
------------------------------------------------------------
107. COLUMN NAME - 'Pulp colour at maturity' (COLUMN_ID : 6.7.19) #cid207
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 White 55.0
1 2 Cream 185.0
2 3 Ivory 280.0
3 4 Yellow 3.0
4 5 Orange 66.0
No description has been provided for this image
------------------------------------------------------------
108. COLUMN NAME - 'Fruits fall from hands' (COLUMN_ID : 6.7.20) #cid208
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Persistent 324
1 2 Deciduous 265
No description has been provided for this image
------------------------------------------------------------
109. COLUMN NAME - 'Flesh texture' (COLUMN_ID : 6.7.21) #cid209
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Firm 227
1 2 Soft 362
No description has been provided for this image
------------------------------------------------------------
110. COLUMN NAME - 'Predominant taste' (COLUMN_ID : 6.7.22) #cid210
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Astringent(like cooking banana) 17.0
1 2 Mild, slightly tasty or tasteless 131.0
2 3 Sweet (like Cavendish) 167.0
3 4 Sugary (like "Pisang Mas") 101.0
4 5 Sweet and acidic (apple like) 173.0
No description has been provided for this image
------------------------------------------------------------
111. COLUMN NAME - 'Presence of seed with source of pollen' (COLUMN_ID : 6.7.23) #cid211
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <5 156
1 3 >20 33
2 2 5 to 20 11
3 4 Seeds absent 389
No description has been provided for this image
------------------------------------------------------------
112. COLUMN NAME - 'Seed surface' (COLUMN_ID : 6.7.24) #cid212
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Smooth 15
1 2 Wrinkled 186
2 3 Seeds absent 388
No description has been provided for this image
------------------------------------------------------------
113. COLUMN NAME - 'Seed shape' (COLUMN_ID : 6.7.25) #cid213
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Flat 26
1 2 Angular(more or less pyramidal) 45
2 3 Globular(spherical) 12
3 4 Rounded (but not completely spherical) 119
4 5 Seeds absent 387
No description has been provided for this image
------------------------------------------------------------
114. COLUMN NAME - 'Crop duration (months)' (COLUMN_ID : 7.4) #cid214
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 312 months 24
1 2 13 to 14 months 150
2 3 15 to 16 months 298
3 4 17 to 18 months 91
4 5 19 to 20 months 16
No description has been provided for this image
------------------------------------------------------------
115. COLUMN NAME - 'Days taken for bunch maturation (days)' (COLUMN_ID : 7.4 a) #cid215
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <75 days 0.0
1 3 91 to 115 days 133.0
2 2 76 to 90 days 6.0
3 4 116 to 125 days 291.0
4 5 ≥126 days 159.0
No description has been provided for this image
------------------------------------------------------------
116. COLUMN NAME - 'Bunch weight (kg)' (COLUMN_ID : 7.9) #cid216
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 < 5 15
1 2 6 to 13 297
2 3 14 to 16 165
3 4 17 to 28 74
4 5 >29 12
No description has been provided for this image
------------------------------------------------------------
117. COLUMN NAME - 'Total number of fingers in bunch' (COLUMN_ID : 7.11) #cid217
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <50 34
1 2 51 to 100 258
2 3 101 to 150 141
3 4 151 to 200 119
4 5 201 to 250 31
No description has been provided for this image
------------------------------------------------------------
118. COLUMN NAME - 'Fruit Weight (g)' (COLUMN_ID : 7.14) #cid218
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <100 246.0
1 2 101 to 200 247.0
2 3 201 to 300 96.0
3 4 > 300 0.0
No description has been provided for this image
------------------------------------------------------------
119. COLUMN NAME - 'Pulp weight (g)' (COLUMN_ID : 7.14 a) #cid219
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 < 100 247.0
1 2 101 to 200 244.0
2 3 201 to 300 98.0
3 4 > 300 0.0
No description has been provided for this image
------------------------------------------------------------
120. COLUMN NAME - 'Sugar content' (COLUMN_ID : 7.14 b) #cid220
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 < 10 0.0
1 2 11 to 15 0.0
2 3 16 to 20 22.0
3 4 21 to 25 382.0
4 5 26 to 30 177.0
No description has been provided for this image
------------------------------------------------------------
121. COLUMN NAME - 'Acidity' (COLUMN_ID : 7.14 c) #cid221
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <0.30 49.0
1 2 0.31 to 0.60 500.0
2 3 0.61 to 0.90 40.0
3 4 > 0.90 0.0
No description has been provided for this image
------------------------------------------------------------
122. COLUMN NAME - 'Shelf life' (COLUMN_ID : 7.14 d) #cid222
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <3 18
1 2 4 to 6 322
2 3 7 to 9 178
3 4 >9 71
No description has been provided for this image
------------------------------------------------------------
123. COLUMN NAME - 'Utility' (COLUMN_ID : 7.14 e) #cid223
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Dessert 447
1 2 Culinary 52
2 3 Dual 82
3 4 Ornamental 1
4 5 Non-edible 7
No description has been provided for this image
------------------------------------------------------------
124. COLUMN NAME - 'Special utility' (COLUMN_ID : 7.14 f) #cid224
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Flour making, baby food 109
1 2 Medicinal 60
2 3 Beer / wine making 116
3 4 Chips 14
4 5 Pastries 121
No description has been provided for this image
------------------------------------------------------------
125. COLUMN NAME - 'Photosynthetic leaves at harvest' (COLUMN_ID : 7.16) #cid225
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 <2 10
1 2 2 to 4 78
2 3 5 to 6 205
3 4 7 to 8 180
4 5 >8 116
No description has been provided for this image
------------------------------------------------------------
126. COLUMN NAME - 'Drought tolerance' (COLUMN_ID : 8.2) #cid226
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Low 209
1 2 Medium 239
2 3 High 141
No description has been provided for this image
------------------------------------------------------------
127. COLUMN NAME - 'Salt tolerance' (COLUMN_ID : 8.6) #cid227
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Low 127
1 2 Medium 287
2 3 High 175
No description has been provided for this image
------------------------------------------------------------
128. COLUMN NAME - 'Physiological disorders' (COLUMN_ID : 8.10) #cid228
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Hard lumps 18
1 2 Kottavazhai 80
2 3 Neervazhai 12
3 4 Softtissues 41
4 5 Flattering of pseudostem 3
No description has been provided for this image
------------------------------------------------------------
129. COLUMN NAME - 'Tolerance to Rhizome weevil' (COLUMN_ID : 9.2.4) #cid229
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 High 0.0
1 2 Medium 473.0
2 3 Low 102.0
3 4 Very low 11.0
No description has been provided for this image
------------------------------------------------------------
130. COLUMN NAME - 'Tolerance to Pseudostem borer' (COLUMN_ID : 9.2.7) #cid230
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 High 0.0
1 2 Medium 473.0
2 3 Low 102.0
No description has been provided for this image
------------------------------------------------------------
131. COLUMN NAME - 'Tolerance to Wilt' (COLUMN_ID : 9.13) #cid231
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Immune 108
1 2 Resistant 91
2 3 Susceptible 226
3 4 Highly susceptible 91
No description has been provided for this image
------------------------------------------------------------
132. COLUMN NAME - 'Suiting to marginal conditions' (COLUMN_ID : 9.14) #cid232
------------------------------------------------------------
cd_param_value cd_param_name count
0 1 Highly suitable 182
1 2 Suitable 367
2 3 Not suitable 40
No description has been provided for this image
------------------------------------------------------------
In [ ]: