pandas用法小结(二)

简介: pandas用法小结(二)

8.index和values

xxx.index查看表的索引值

而xxx.values查看表的值

举个例子:

import pandas
food_info = pandas.read_csv("food_info.csv")
print(food_info.index)
print(food_info.values)

打印结果:

RangeIndex(start=0, stop=8618, step=1)
[[1001 'BUTTER WITH SALT' 15.87 ... 21.021 3.043 215.0]
 [1002 'BUTTER WHIPPED WITH SALT' 15.87 ... 23.426 3.012 219.0]
 [1003 'BUTTER OIL ANHYDROUS' 0.24 ... 28.732 3.694 256.0]
 ...
 [90480 'SYRUP CANE' 26.0 ... 0.0 0.0 0.0]
 [90560 'SNAIL RAW' 79.2 ... 0.259 0.252 50.0]
 [93600 'TURTLE GREEN RAW' 78.5 ... 0.08800000000000001 0.17 50.0]]

9.describe()

xxx.describe()用来查看数据的快速统计结果。

举个例子:

import pandas
food_info = pandas.read_csv("food_info.csv")
print(food_info.describe())

打印结果:

<bound method NDFrame.describe of       NDB_No                                          Shrt_Desc  Water_(g)  \
0       1001                                   BUTTER WITH SALT      15.87
1       1002                           BUTTER WHIPPED WITH SALT      15.87
2       1003                               BUTTER OIL ANHYDROUS       0.24
3       1004                                        CHEESE BLUE      42.41
4       1005                                       CHEESE BRICK      41.11
5       1006                                        CHEESE BRIE      48.42
6       1007                                   CHEESE CAMEMBERT      51.80
7       1008                                     CHEESE CARAWAY      39.28
8       1009                                     CHEESE CHEDDAR      37.10
9       1010                                    CHEESE CHESHIRE      37.65
10      1011                                       CHEESE COLBY      38.20
11      1012                CHEESE COTTAGE CRMD LRG OR SML CURD      79.79
12      1013                        CHEESE COTTAGE CRMD W/FRUIT      79.64
13      1014   CHEESE COTTAGE NONFAT UNCRMD DRY LRG OR SML CURD      81.01
14      1015                   CHEESE COTTAGE LOWFAT 2% MILKFAT      81.24
15      1016                   CHEESE COTTAGE LOWFAT 1% MILKFAT      82.48
16      1017                                       CHEESE CREAM      54.44
17      1018                                        CHEESE EDAM      41.56
18      1019                                        CHEESE FETA      55.22
19      1020                                     CHEESE FONTINA      37.92
20      1021                                     CHEESE GJETOST      13.44
21      1022                                       CHEESE GOUDA      41.46
22      1023                                     CHEESE GRUYERE      33.19
23      1024                                   CHEESE LIMBURGER      48.42
24      1025                                    CHEESE MONTEREY      41.01
25      1026                         CHEESE MOZZARELLA WHL MILK      50.01
26      1027                CHEESE MOZZARELLA WHL MILK LO MOIST      48.38
27      1028                   CHEESE MOZZARELLA PART SKIM MILK      53.78
28      1029               CHEESE MOZZARELLA LO MOIST PART-SKIM      45.54
29      1030                                    CHEESE MUENSTER      41.77
...      ...                                                ...        ...
8588   43544         BABYFOOD CRL RICE W/ PEARS & APPL DRY INST       2.00
8589   43546                     BABYFOOD BANANA NO TAPIOCA STR      76.70
8590   43550                     BABYFOOD BANANA APPL DSSRT STR      83.10
8591   43566       SNACKS TORTILLA CHIPS LT (BAKED W/ LESS OIL)       1.30
8592   43570  CEREALS RTE POST HONEY BUNCHES OF OATS HONEY RSTD       5.00
8593   43572                         POPCORN MICROWAVE LOFAT&NA       2.80
8594   43585                       BABYFOOD FRUIT SUPREME DSSRT      81.60
8595   43589                               CHEESE SWISS LOW FAT      59.60
8596   43595             BREAKFAST BAR CORN FLAKE CRUST W/FRUIT      14.50
8597   43597                            CHEESE MOZZARELLA LO NA      49.90
8598   43598                           MAYONNAISE DRSNG NO CHOL      21.70
8599   44005                          OIL CORN PEANUT AND OLIVE       0.00
8600   44018                   SWEETENERS TABLETOP FRUCTOSE LIQ      23.90
8601   44048                              CHEESE FOOD IMITATION      55.50
8602   44055                                CELERY FLAKES DRIED       9.00
8603   44061           PUDDINGS CHOC FLAVOR LO CAL INST DRY MIX       4.20
8604   44074                    BABYFOOD GRAPE JUC NO SUGAR CND      84.40
8605   44110                   JELLIES RED SUGAR HOME PRESERVED      53.00
8606   44158                         PIE FILLINGS BLUEBERRY CND      54.66
8607   44203               COCKTAIL MIX NON-ALCOHOLIC CONCD FRZ      28.24
8608   44258            PUDDINGS CHOC FLAVOR LO CAL REG DRY MIX       6.80
8609   44259  PUDDINGS ALL FLAVORS XCPT CHOC LO CAL REG DRY MIX      10.40
8610   44260  PUDDINGS ALL FLAVORS XCPT CHOC LO CAL INST DRY...       6.84
8611   48052                                 VITAL WHEAT GLUTEN       8.20
8612   80200                                      FROG LEGS RAW      81.90
8613   83110                                    MACKEREL SALTED      43.00
8614   90240                         SCALLOP (BAY&SEA) CKD STMD      70.25
8615   90480                                         SYRUP CANE      26.00
8616   90560                                          SNAIL RAW      79.20
8617   93600                                   TURTLE GREEN RAW      78.50
      Energ_Kcal  Protein_(g)  Lipid_Tot_(g)  Ash_(g)  Carbohydrt_(g)  \
0            717         0.85          81.11     2.11            0.06
1            717         0.85          81.11     2.11            0.06
2            876         0.28          99.48     0.00            0.00
3            353        21.40          28.74     5.11            2.34
4            371        23.24          29.68     3.18            2.79
5            334        20.75          27.68     2.70            0.45
6            300        19.80          24.26     3.68            0.46
7            376        25.18          29.20     3.28            3.06
8            406        24.04          33.82     3.71            1.33
9            387        23.37          30.60     3.60            4.78
10           394        23.76          32.11     3.36            2.57
11            98        11.12           4.30     1.41            3.38
12            97        10.69           3.85     1.20            4.61
13            72        10.34           0.29     1.71            6.66
14            81        10.45           2.27     1.27            4.76
15            72        12.39           1.02     1.39            2.72
16           342         5.93          34.24     1.32            4.07
17           357        24.99          27.80     4.22            1.43
18           264        14.21          21.28     5.20            4.09
19           389        25.60          31.14     3.79            1.55
20           466         9.65          29.51     4.75           42.65
21           356        24.94          27.44     3.94            2.22
22           413        29.81          32.34     4.30            0.36
23           327        20.05          27.25     3.79            0.49
24           373        24.48          30.28     3.55            0.68
25           300        22.17          22.35     3.28            2.19
26           318        21.60          24.64     2.91            2.47
27           254        24.26          15.92     3.27            2.77
28           301        24.58          19.72     3.80            6.36
29           368        23.41          30.04     3.66            1.12
...          ...          ...            ...      ...             ...
8588         389         6.60           0.90     2.00           88.60
8589          91         1.00           0.20     0.76           21.34
8590          68         0.30           0.20     0.29           16.30
8591         465         8.70          15.20     1.85           73.40
8592         401         7.12           5.46     1.22           81.19
8593         429        12.60           9.50     1.71           73.39
8594          73         0.50           0.20     0.52           17.18
8595         179        28.40           5.10     3.50            3.40
8596         377         4.40           7.50     0.80           72.90
8597         280        27.50          17.10     2.40            3.10
8598         688         0.00          77.80     0.40            0.30
8599         884         0.00         100.00     0.00            0.00
8600         279         0.00           0.00     0.00           76.10
8601         257         4.08          19.50     4.74           16.18
8602         319        11.30           2.10    13.90           63.70
8603         356         5.30           2.40     9.90           78.20
8604          62         0.00           0.00     0.22           15.38
8605         179         0.30           0.03     0.08           46.10
8606         181         0.41           0.20     0.35           44.38
8607         287         0.08           0.01     0.07           71.60
8608         365        10.08           3.00     5.70           74.42
8609         351         1.60           0.10     1.86           86.04
8610         350         0.81           0.90     6.80           84.66
8611         370        75.16           1.85     1.00           13.79
8612          73        16.40           0.30     1.40            0.00
8613         305        18.50          25.10    13.40            0.00
8614         111        20.54           0.84     2.97            5.41
8615         269         0.00           0.00     0.86           73.14
8616          90        16.10           1.40     1.30            2.00
8617          89        19.80           0.50     1.20            0.00
      Fiber_TD_(g)  Sugar_Tot_(g)       ...        Vit_A_IU  Vit_A_RAE  \
0              0.0           0.06       ...          2499.0      684.0
1              0.0           0.06       ...          2499.0      684.0
2              0.0           0.00       ...          3069.0      840.0
3              0.0           0.50       ...           721.0      198.0
4              0.0           0.51       ...          1080.0      292.0
5              0.0           0.45       ...           592.0      174.0
6              0.0           0.46       ...           820.0      241.0
7              0.0            NaN       ...          1054.0      271.0
8              0.0           0.28       ...           994.0      263.0
9              0.0            NaN       ...           985.0      233.0
10             0.0           0.52       ...           994.0      264.0
11             0.0           2.67       ...           140.0       37.0
12             0.2           2.38       ...           146.0       38.0
13             0.0           1.85       ...             8.0        2.0
14             0.0           4.00       ...           225.0       68.0
15             0.0           2.72       ...            41.0       11.0
16             0.0           3.21       ...          1343.0      366.0
17             0.0           1.43       ...           825.0      243.0
18             0.0           4.09       ...           422.0      125.0
19             0.0           1.55       ...           913.0      261.0
20             0.0            NaN       ...          1113.0      334.0
21             0.0           2.22       ...           563.0      165.0
22             0.0           0.36       ...           948.0      271.0
23             0.0           0.49       ...          1155.0      340.0
24             0.0           0.50       ...           769.0      198.0
25             0.0           1.03       ...           676.0      179.0
26             0.0           1.01       ...           745.0      197.0
27             0.0           1.13       ...           481.0      127.0
28             0.0           2.24       ...           846.0      254.0
29             0.0           1.12       ...          1012.0      298.0
...            ...            ...       ...             ...        ...
8588           2.6           1.35       ...             0.0        0.0
8589           1.6          11.36       ...             5.0        0.0
8590           1.0          14.66       ...            30.0        2.0
8591           5.7           0.53       ...            81.0        4.0
8592           4.2          19.79       ...          2731.0      806.0
8593          14.2           0.54       ...           147.0        7.0
8594           2.0          14.87       ...            50.0        3.0
8595           0.0           1.33       ...           152.0       40.0
8596           2.1          35.10       ...          2027.0      608.0
8597           0.0           1.23       ...           517.0      137.0
8598           0.0           0.30       ...             0.0        0.0
8599           0.0           0.00       ...             0.0        0.0
8600           0.1          76.00       ...             0.0        0.0
8601           0.0           8.21       ...           900.0       45.0
8602          27.8          35.90       ...          1962.0       98.0
8603           6.1           0.70       ...             0.0        0.0
8604           0.1            NaN       ...             8.0        NaN
8605           0.8          45.30       ...             3.0        0.0
8606           2.6          37.75       ...            22.0        1.0
8607           0.0          24.53       ...            12.0        1.0
8608          10.1           0.70       ...             0.0        0.0
8609           0.9           2.90       ...             0.0        0.0
8610           0.8           0.90       ...             0.0        0.0
8611           0.6           0.00       ...             0.0        0.0
8612           0.0           0.00       ...            50.0       15.0
8613           0.0           0.00       ...           157.0       47.0
8614           0.0           0.00       ...             5.0        2.0
8615           0.0          73.20       ...             0.0        0.0
8616           0.0           0.00       ...           100.0       30.0
8617           0.0           0.00       ...           100.0       30.0
      Vit_E_(mg)  Vit_D_mcg  Vit_D_IU  Vit_K_(mcg)  FA_Sat_(g)  FA_Mono_(g)  \
0           2.32        1.5      60.0          7.0      51.368       21.021
1           2.32        1.5      60.0          7.0      50.489       23.426
2           2.80        1.8      73.0          8.6      61.924       28.732
3           0.25        0.5      21.0          2.4      18.669        7.778
4           0.26        0.5      22.0          2.5      18.764        8.598
5           0.24        0.5      20.0          2.3      17.410        8.013
6           0.21        0.4      18.0          2.0      15.259        7.023
7            NaN        NaN       NaN          NaN      18.584        8.275
8           0.78        0.6      24.0          2.9      19.368        8.428
9            NaN        NaN       NaN          NaN      19.475        8.671
10          0.28        0.6      24.0          2.7      20.218        9.280
11          0.08        0.1       3.0          0.0       1.718        0.778
12          0.04        0.0       0.0          0.4       2.311        1.036
13          0.01        0.0       0.0          0.0       0.169        0.079
14          0.08        0.0       0.0          0.0       1.235        0.516
15          0.01        0.0       0.0          0.1       0.645        0.291
16          0.29        0.6      25.0          2.9      19.292        8.620
17          0.24        0.5      20.0          2.3      17.572        8.125
18          0.18        0.4      16.0          1.8      14.946        4.623
19          0.27        0.6      23.0          2.6      19.196        8.687
20           NaN        NaN       NaN          NaN      19.160        7.879
21          0.24        0.5      20.0          2.3      17.614        7.747
22          0.28        0.6      24.0          2.7      18.913       10.043
23          0.23        0.5      20.0          2.3      16.746        8.606
24          0.26        0.6      22.0          2.5      19.066        8.751
25          0.19        0.4      16.0          2.3      13.152        6.573
26          0.21        0.5      18.0          2.5      15.561        7.027
27          0.14        0.3      12.0          1.6      10.114        4.510
28          0.43        0.4      15.0          1.3      11.473        5.104
29          0.26        0.6      22.0          2.5      19.113        8.711
...          ...        ...       ...          ...         ...          ...
8588        0.13        0.0       0.0          0.3       0.185        0.252
8589        0.25        0.0       0.0          0.5       0.072        0.028
8590        0.02        0.0       0.0          0.1       0.058        0.018
8591        3.53        0.0       0.0          0.7       2.837        6.341
8592        1.22        4.6     183.0          3.0       0.600        2.831
8593        5.01        0.0       0.0         15.7       1.415        4.085
8594        0.79        0.0       0.0          5.1       0.030        0.025
8595        0.07        0.1       4.0          0.5       3.304        1.351
8596        0.76        0.0       0.0         13.8       1.500        5.000
8597        0.15        0.3      13.0          1.8      10.867        4.844
8598       11.79        0.0       0.0         24.7      10.784       18.026
8599       14.78        0.0       0.0         21.0      14.367       48.033
8600        0.00        0.0       0.0          0.0       0.000        0.000
8601        2.15        0.0       0.0         36.7       7.996        3.108
8602        5.55        0.0       0.0        584.2       0.555        0.405
8603        0.02        0.0       0.0          0.4       0.984        1.154
8604         NaN        NaN       NaN          NaN       0.000        0.000
8605        0.00        0.0       0.0          0.2       0.009        0.001
8606        0.23        0.0       0.0          3.9       0.000        0.000
8607        0.02        0.0       0.0          0.0       0.003        0.001
8608        0.02        0.0       0.0          0.5       1.578        1.150
8609        0.05        0.0       0.0          1.1       0.018        0.032
8610        0.08        0.0       0.0          1.7       0.099        0.116
8611        0.00        0.0       0.0          0.0       0.272        0.156
8612        1.00        0.2       8.0          0.1       0.076        0.053
8613        2.38       25.2    1006.0          7.8       7.148        8.320
8614        0.00        0.0       2.0          0.0       0.218        0.082
8615        0.00        0.0       0.0          0.0       0.000        0.000
8616        5.00        0.0       0.0          0.1       0.361        0.259
8617        0.50        0.0       0.0          0.1       0.127        0.088
      FA_Poly_(g)  Cholestrl_(mg)
0           3.043           215.0
1           3.012           219.0
2           3.694           256.0
3           0.800            75.0
4           0.784            94.0
5           0.826           100.0
6           0.724            72.0
7           0.830            93.0
8           1.433           102.0
9           0.870           103.0
10          0.953            95.0
11          0.123            17.0
12          0.124            13.0
13          0.003             7.0
14          0.083            12.0
15          0.031             4.0
16          1.437           110.0
17          0.665            89.0
18          0.591            89.0
19          1.654           116.0
20          0.938            94.0
21          0.657           114.0
22          1.733           110.0
23          0.495            90.0
24          0.899            89.0
25          0.765            79.0
26          0.778            89.0
27          0.472            64.0
28          0.861            65.0
29          0.661            96.0
...           ...             ...
8588        0.231             0.0
8589        0.041             0.0
8590        0.047             0.0
8591        5.024             0.0
8592        1.307             0.0
8593        3.572             0.0
8594        0.068             0.0
8595        0.180            35.0
8596        0.900             0.0
8597        0.509            54.0
8598       45.539             0.0
8599       33.033             0.0
8600        0.000             0.0
8601        7.536             6.0
8602        1.035             0.0
8603        0.131             0.0
8604        0.000             0.0
8605        0.008             0.0
8606        0.000             0.0
8607        0.009             0.0
8608        0.130             0.0
8609        0.050             0.0
8610        0.433             0.0
8611        0.810             0.0
8612        0.102            50.0
8613        6.210            95.0
8614        0.222            41.0
8615        0.000             0.0
8616        0.252            50.0
8617        0.170            50.0
[8618 rows x 36 columns]>

10.T

xxx.T可以对数据进行行列转换。

举个例子:

import pandas
food_info = pandas.read_csv("food_info.csv")
print(food_info.T)

打印结果:

0                         1     \
NDB_No                       1001                      1002
Shrt_Desc        BUTTER WITH SALT  BUTTER WHIPPED WITH SALT
Water_(g)                   15.87                     15.87
Energ_Kcal                    717                       717
Protein_(g)                  0.85                      0.85
Lipid_Tot_(g)               81.11                     81.11
Ash_(g)                      2.11                      2.11
Carbohydrt_(g)               0.06                      0.06
Fiber_TD_(g)                    0                         0
Sugar_Tot_(g)                0.06                      0.06
Calcium_(mg)                   24                        24
Iron_(mg)                    0.02                      0.16
Magnesium_(mg)                  2                         2
Phosphorus_(mg)                24                        23
Potassium_(mg)                 24                        26
Sodium_(mg)                   643                       659
Zinc_(mg)                    0.09                      0.05
Copper_(mg)                     0                     0.016
Manganese_(mg)                  0                     0.004
Selenium_(mcg)                  1                         1
Vit_C_(mg)                      0                         0
Thiamin_(mg)                0.005                     0.005
Riboflavin_(mg)             0.034                     0.034
Niacin_(mg)                 0.042                     0.042
Vit_B6_(mg)                 0.003                     0.003
Vit_B12_(mcg)                0.17                      0.13
Vit_A_IU                     2499                      2499
Vit_A_RAE                     684                       684
Vit_E_(mg)                   2.32                      2.32
Vit_D_mcg                     1.5                       1.5
Vit_D_IU                       60                        60
Vit_K_(mcg)                     7                         7
FA_Sat_(g)                 51.368                    50.489
FA_Mono_(g)                21.021                    23.426
FA_Poly_(g)                 3.043                     3.012
Cholestrl_(mg)                215                       219
                                 2            3             4            5     \
NDB_No                           1003         1004          1005         1006
Shrt_Desc        BUTTER OIL ANHYDROUS  CHEESE BLUE  CHEESE BRICK  CHEESE BRIE
Water_(g)                        0.24        42.41         41.11        48.42
Energ_Kcal                        876          353           371          334
Protein_(g)                      0.28         21.4         23.24        20.75
Lipid_Tot_(g)                   99.48        28.74         29.68        27.68
Ash_(g)                             0         5.11          3.18          2.7
Carbohydrt_(g)                      0         2.34          2.79         0.45
Fiber_TD_(g)                        0            0             0            0
Sugar_Tot_(g)                       0          0.5          0.51         0.45
Calcium_(mg)                        4          528           674          184
Iron_(mg)                           0         0.31          0.43          0.5
Magnesium_(mg)                      0           23            24           20
Phosphorus_(mg)                     3          387           451          188
Potassium_(mg)                      5          256           136          152
Sodium_(mg)                         2         1146           560          629
Zinc_(mg)                        0.01         2.66           2.6         2.38
Copper_(mg)                     0.001         0.04         0.024        0.019
Manganese_(mg)                      0        0.009         0.012        0.034
Selenium_(mcg)                      0         14.5          14.5         14.5
Vit_C_(mg)                          0            0             0            0
Thiamin_(mg)                    0.001        0.029         0.014         0.07
Riboflavin_(mg)                 0.005        0.382         0.351         0.52
Niacin_(mg)                     0.003        1.016         0.118         0.38
Vit_B6_(mg)                     0.001        0.166         0.065        0.235
Vit_B12_(mcg)                    0.01         1.22          1.26         1.65
Vit_A_IU                         3069          721          1080          592
Vit_A_RAE                         840          198           292          174
Vit_E_(mg)                        2.8         0.25          0.26         0.24
Vit_D_mcg                         1.8          0.5           0.5          0.5
Vit_D_IU                           73           21            22           20
Vit_K_(mcg)                       8.6          2.4           2.5          2.3
FA_Sat_(g)                     61.924       18.669        18.764        17.41
FA_Mono_(g)                    28.732        7.778         8.598        8.013
FA_Poly_(g)                     3.694          0.8         0.784        0.826
Cholestrl_(mg)                    256           75            94          100
                             6               7               8     \
NDB_No                       1007            1008            1009
Shrt_Desc        CHEESE CAMEMBERT  CHEESE CARAWAY  CHEESE CHEDDAR
Water_(g)                    51.8           39.28            37.1
Energ_Kcal                    300             376             406
Protein_(g)                  19.8           25.18           24.04
Lipid_Tot_(g)               24.26            29.2           33.82
Ash_(g)                      3.68            3.28            3.71
Carbohydrt_(g)               0.46            3.06            1.33
Fiber_TD_(g)                    0               0               0
Sugar_Tot_(g)                0.46             NaN            0.28
Calcium_(mg)                  388             673             675
Iron_(mg)                    0.33            0.64            0.16
Magnesium_(mg)                 20              22              27
Phosphorus_(mg)               347             490             473
Potassium_(mg)                187              93              76
Sodium_(mg)                   842             690             644
Zinc_(mg)                    2.38            2.94            3.43
Copper_(mg)                 0.021           0.024           0.056
Manganese_(mg)              0.038           0.021           0.033
Selenium_(mcg)               14.5            14.5            28.3
Vit_C_(mg)                      0               0               0
Thiamin_(mg)                0.028           0.031           0.027
Riboflavin_(mg)             0.488            0.45           0.434
Niacin_(mg)                  0.63            0.18           0.039
Vit_B6_(mg)                 0.227           0.074           0.049
Vit_B12_(mcg)                 1.3            0.27            0.88
Vit_A_IU                      820            1054             994
Vit_A_RAE                     241             271             263
Vit_E_(mg)                   0.21             NaN            0.78
Vit_D_mcg                     0.4             NaN             0.6
Vit_D_IU                       18             NaN              24
Vit_K_(mcg)                     2             NaN             2.9
FA_Sat_(g)                 15.259          18.584          19.368
FA_Mono_(g)                 7.023           8.275           8.428
FA_Poly_(g)                 0.724            0.83           1.433
Cholestrl_(mg)                 72              93             102
                            9           ...         \
NDB_No                      1010        ...
Shrt_Desc        CHEESE CHESHIRE        ...
Water_(g)                  37.65        ...
Energ_Kcal                   387        ...
Protein_(g)                23.37        ...
Lipid_Tot_(g)               30.6        ...
Ash_(g)                      3.6        ...
Carbohydrt_(g)              4.78        ...
Fiber_TD_(g)                   0        ...
Sugar_Tot_(g)                NaN        ...
Calcium_(mg)                 643        ...
Iron_(mg)                   0.21        ...
Magnesium_(mg)                21        ...
Phosphorus_(mg)              464        ...
Potassium_(mg)                95        ...
Sodium_(mg)                  700        ...
Zinc_(mg)                   2.79        ...
Copper_(mg)                0.042        ...
Manganese_(mg)             0.012        ...
Selenium_(mcg)              14.5        ...
Vit_C_(mg)                     0        ...
Thiamin_(mg)               0.046        ...
Riboflavin_(mg)            0.293        ...
Niacin_(mg)                 0.08        ...
Vit_B6_(mg)                0.074        ...
Vit_B12_(mcg)               0.83        ...
Vit_A_IU                     985        ...
Vit_A_RAE                    233        ...
Vit_E_(mg)                   NaN        ...
Vit_D_mcg                    NaN        ...
Vit_D_IU                     NaN        ...
Vit_K_(mcg)                  NaN        ...
FA_Sat_(g)                19.475        ...
FA_Mono_(g)                8.671        ...
FA_Poly_(g)                 0.87        ...
Cholestrl_(mg)               103        ...
                                                    8608  \
NDB_No                                             44258
Shrt_Desc        PUDDINGS CHOC FLAVOR LO CAL REG DRY MIX
Water_(g)                                            6.8
Energ_Kcal                                           365
Protein_(g)                                        10.08
Lipid_Tot_(g)                                          3
Ash_(g)                                              5.7
Carbohydrt_(g)                                     74.42
Fiber_TD_(g)                                        10.1
Sugar_Tot_(g)                                        0.7
Calcium_(mg)                                          50
Iron_(mg)                                           3.87
Magnesium_(mg)                                       110
Phosphorus_(mg)                                      174
Potassium_(mg)                                       570
Sodium_(mg)                                         3326
Zinc_(mg)                                           1.49
Copper_(mg)                                        0.854
Manganese_(mg)                                     0.887
Selenium_(mcg)                                       5.1
Vit_C_(mg)                                             0
Thiamin_(mg)                                       0.025
Riboflavin_(mg)                                    0.105
Niacin_(mg)                                        0.545
Vit_B6_(mg)                                        0.027
Vit_B12_(mcg)                                          0
Vit_A_IU                                               0
Vit_A_RAE                                              0
Vit_E_(mg)                                          0.02
Vit_D_mcg                                              0
Vit_D_IU                                               0
Vit_K_(mcg)                                          0.5
FA_Sat_(g)                                         1.578
FA_Mono_(g)                                         1.15
FA_Poly_(g)                                         0.13
Cholestrl_(mg)                                         0
                                                              8609  \
NDB_No                                                       44259
Shrt_Desc        PUDDINGS ALL FLAVORS XCPT CHOC LO CAL REG DRY MIX
Water_(g)                                                     10.4
Energ_Kcal                                                     351
Protein_(g)                                                    1.6
Lipid_Tot_(g)                                                  0.1
Ash_(g)                                                       1.86
Carbohydrt_(g)                                               86.04
Fiber_TD_(g)                                                   0.9
Sugar_Tot_(g)                                                  2.9
Calcium_(mg)                                                    49
Iron_(mg)                                                     0.05
Magnesium_(mg)                                                  17
Phosphorus_(mg)                                                 12
Potassium_(mg)                                                  18
Sodium_(mg)                                                   1765
Zinc_(mg)                                                     0.19
Copper_(mg)                                                   0.04
Manganese_(mg)                                                 NaN
Selenium_(mcg)                                                 0.9
Vit_C_(mg)                                                       0
Thiamin_(mg)                                                     0
Riboflavin_(mg)                                                  0
Niacin_(mg)                                                      0
Vit_B6_(mg)                                                      0
Vit_B12_(mcg)                                                    0
Vit_A_IU                                                         0
Vit_A_RAE                                                        0
Vit_E_(mg)                                                    0.05
Vit_D_mcg                                                        0
Vit_D_IU                                                         0
Vit_K_(mcg)                                                    1.1
FA_Sat_(g)                                                   0.018
FA_Mono_(g)                                                  0.032
FA_Poly_(g)                                                   0.05
Cholestrl_(mg)                                                   0
                                                              8610  \
NDB_No                                                       44260
Shrt_Desc        PUDDINGS ALL FLAVORS XCPT CHOC LO CAL INST DRY...
Water_(g)                                                     6.84
Energ_Kcal                                                     350
Protein_(g)                                                   0.81
Lipid_Tot_(g)                                                  0.9
Ash_(g)                                                        6.8
Carbohydrt_(g)                                               84.66
Fiber_TD_(g)                                                   0.8
Sugar_Tot_(g)                                                  0.9
Calcium_(mg)                                                   143
Iron_(mg)                                                     0.38
Magnesium_(mg)                                                   5
Phosphorus_(mg)                                               2368
Potassium_(mg)                                                  30
Sodium_(mg)                                                   3750
Zinc_(mg)                                                      0.1
Copper_(mg)                                                  0.038
Manganese_(mg)                                               0.041
Selenium_(mcg)                                                 0.8
Vit_C_(mg)                                                       0
Thiamin_(mg)                                                 0.005
Riboflavin_(mg)                                              0.021
Niacin_(mg)                                                  0.014
Vit_B6_(mg)                                                  0.005
Vit_B12_(mcg)                                                 0.05
Vit_A_IU                                                         0
Vit_A_RAE                                                        0
Vit_E_(mg)                                                    0.08
Vit_D_mcg                                                        0
Vit_D_IU                                                         0
Vit_K_(mcg)                                                    1.7
FA_Sat_(g)                                                   0.099
FA_Mono_(g)                                                  0.116
FA_Poly_(g)                                                  0.433
Cholestrl_(mg)                                                   0
                               8611           8612             8613  \
NDB_No                        48052          80200            83110
Shrt_Desc        VITAL WHEAT GLUTEN  FROG LEGS RAW  MACKEREL SALTED
Water_(g)                       8.2           81.9               43
Energ_Kcal                      370             73              305
Protein_(g)                   75.16           16.4             18.5
Lipid_Tot_(g)                  1.85            0.3             25.1
Ash_(g)                           1            1.4             13.4
Carbohydrt_(g)                13.79              0                0
Fiber_TD_(g)                    0.6              0                0
Sugar_Tot_(g)                     0              0                0
Calcium_(mg)                    142             18               66
Iron_(mg)                       5.2            1.5              1.4
Magnesium_(mg)                   25             20               60
Phosphorus_(mg)                 260            147              254
Potassium_(mg)                  100            285              520
Sodium_(mg)                      29             58             4450
Zinc_(mg)                      0.85              1              1.1
Copper_(mg)                   0.182           0.25              0.1
Manganese_(mg)                  NaN            NaN              NaN
Selenium_(mcg)                 39.7           14.1             73.4
Vit_C_(mg)                        0              0                0
Thiamin_(mg)                      0           0.14             0.02
Riboflavin_(mg)                   0           0.25             0.19
Niacin_(mg)                       0            1.2              3.3
Vit_B6_(mg)                       0           0.12             0.41
Vit_B12_(mcg)                     0            0.4               12
Vit_A_IU                          0             50              157
Vit_A_RAE                         0             15               47
Vit_E_(mg)                        0              1             2.38
Vit_D_mcg                         0            0.2             25.2
Vit_D_IU                          0              8             1006
Vit_K_(mcg)                       0            0.1              7.8
FA_Sat_(g)                    0.272          0.076            7.148
FA_Mono_(g)                   0.156          0.053             8.32
FA_Poly_(g)                    0.81          0.102             6.21
Cholestrl_(mg)                    0             50               95
                                       8614        8615       8616  \
NDB_No                                90240       90480      90560
Shrt_Desc        SCALLOP (BAY&SEA) CKD STMD  SYRUP CANE  SNAIL RAW
Water_(g)                             70.25          26       79.2
Energ_Kcal                              111         269         90
Protein_(g)                           20.54           0       16.1
Lipid_Tot_(g)                          0.84           0        1.4
Ash_(g)                                2.97        0.86        1.3
Carbohydrt_(g)                         5.41       73.14          2
Fiber_TD_(g)                              0           0          0
Sugar_Tot_(g)                             0        73.2          0
Calcium_(mg)                             10          13         10
Iron_(mg)                              0.58         3.6        3.5
Magnesium_(mg)                           37          10        250
Phosphorus_(mg)                         426           8        272
Potassium_(mg)                          314          63        382
Sodium_(mg)                             667          58         70
Zinc_(mg)                              1.55        0.19          1
Copper_(mg)                           0.033        0.02        0.4
Manganese_(mg)                        0.029         NaN        NaN
Selenium_(mcg)                         21.7         0.7       27.4
Vit_C_(mg)                                0           0          0
Thiamin_(mg)                          0.012        0.13       0.01
Riboflavin_(mg)                       0.024        0.06       0.12
Niacin_(mg)                           1.076         0.1        1.4
Vit_B6_(mg)                           0.112           0       0.13
Vit_B12_(mcg)                          2.15           0        0.5
Vit_A_IU                                  5           0        100
Vit_A_RAE                                 2           0         30
Vit_E_(mg)                                0           0          5
Vit_D_mcg                                 0           0          0
Vit_D_IU                                  2           0          0
Vit_K_(mcg)                               0           0        0.1
FA_Sat_(g)                            0.218           0      0.361
FA_Mono_(g)                           0.082           0      0.259
FA_Poly_(g)                           0.222           0      0.252
Cholestrl_(mg)                           41           0         50
                             8617
NDB_No                      93600
Shrt_Desc        TURTLE GREEN RAW
Water_(g)                    78.5
Energ_Kcal                     89
Protein_(g)                  19.8
Lipid_Tot_(g)                 0.5
Ash_(g)                       1.2
Carbohydrt_(g)                  0
Fiber_TD_(g)                    0
Sugar_Tot_(g)                   0
Calcium_(mg)                  118
Iron_(mg)                     1.4
Magnesium_(mg)                 20
Phosphorus_(mg)               180
Potassium_(mg)                230
Sodium_(mg)                    68
Zinc_(mg)                       1
Copper_(mg)                  0.25
Manganese_(mg)                NaN
Selenium_(mcg)               16.8
Vit_C_(mg)                      0
Thiamin_(mg)                 0.12
Riboflavin_(mg)              0.15
Niacin_(mg)                   1.1
Vit_B6_(mg)                  0.12
Vit_B12_(mcg)                   1
Vit_A_IU                      100
Vit_A_RAE                      30
Vit_E_(mg)                    0.5
Vit_D_mcg                       0
Vit_D_IU                        0
Vit_K_(mcg)                   0.1
FA_Sat_(g)                  0.127
FA_Mono_(g)                 0.088
FA_Poly_(g)                  0.17
Cholestrl_(mg)                 50
[36 rows x 8618 columns]


目录
相关文章
|
2月前
|
数据处理 索引 Python
Pandas中concat的用法
Pandas中concat的用法
42 1
|
3月前
|
存储 数据采集 数据处理
深入探索Pandas的DataFrame:基本用法与案例研究
深入探索Pandas的DataFrame:基本用法与案例研究
|
数据处理 Python
Pandas数据处理 | apply() 函数用法指南!
本文介绍一下关于 Pandas 中 apply() 函数的几个常见用法,apply() 函数的自由度较高,可以直接对 Series 或者 DataFrame 中元素进行逐元素遍历操作,方便且高效,具有类似于 Numpy 的特性。
|
2月前
|
索引 Python
pandas读取某列、某行数据——loc、iloc用法总结
pandas读取某列、某行数据——loc、iloc用法总结
105 2
|
7月前
|
数据可视化 数据挖掘 数据处理
【100天精通Python】Day58:Python 数据分析_Pandas时间序列数据处理,创建和解析时间数据pd.to_datetime(),.loc[],resample() 用法示例
【100天精通Python】Day58:Python 数据分析_Pandas时间序列数据处理,创建和解析时间数据pd.to_datetime(),.loc[],resample() 用法示例
208 0
|
索引 Python
pandas用法小结(三)
pandas用法小结(三)
71 0
|
存储 人工智能 Ubuntu
pandas用法小结(一)
pandas用法小结
166 0
|
Python
【Pandas】解析resample函数中重采样频率‘freq‘用法(附参数说明表)
【Pandas】解析resample函数中重采样频率‘freq‘用法(附参数说明表)
404 0
【Pandas】解析resample函数中重采样频率‘freq‘用法(附参数说明表)
|
机器学习/深度学习 人工智能 自然语言处理
高手系列!数据科学家私藏pandas高阶用法大全 ⛵
本文汇总介绍了21个 Pandas 进阶用法,能保持代码整洁优雅,更能提高代码效率!这篇是从数据科学家朋友那里搞到的私藏,快一起薅羊毛~
1196 4
高手系列!数据科学家私藏pandas高阶用法大全 ⛵
|
存储 Python
Pandas | value_counts() 的详细用法
Pandas | value_counts() 的详细用法
638 0
Pandas | value_counts() 的详细用法