manipulate table containing numeric and string

Question

0 个投票

hi, i have a table containing numeric and string as follow:

   crisp_distance_per_cluster1    crisp_distance_per_cluster2         Var3      
    ___________________________    ___________________________    _______________
                             2.3904                        'dummy_data_1' 
                             2.5404                        'dummy_data_2' 
                             1.5547                        'dummy_data_3' 
                            0.92612                        'dummy_data_4' 
                             1.0761                        'dummy_data_5' 
                             2.1333                        'dummy_data_6' 
                             1.2761                        'dummy_data_7' 
                             7.0547                        'dummy_data_8' 
                             7.8476                        'dummy_data_9' 
                             9.1404                        'dummy_data_10'
                             9.9047                        'dummy_data_11'
   

I want to split the table into different table based on the crisp_distance_per_cluster1. For example, if crisp_distance_per_cluster1=1, will be

                             2.3904                        'dummy_data_1' 
                             2.5404                        'dummy_data_2' 
                             1.5547                        'dummy_data_3' 
                            0.92612                        'dummy_data_4' 
                             1.0761                        'dummy_data_5' 
                             2.1333                        'dummy_data_6' 
                             1.2761                        'dummy_data_7' 

I dont want to convert the table into string since later i need to do some numerical calculation. Please help to give suggestion, ideas or code. TQIA.