verticapy.datasets.load_market¶
- verticapy.datasets.load_market(schema: str | None = None, name: str = 'market') vDataFrame¶
Ingests the market dataset into the Vertica database. This dataset is ideal for data exploration. If a table with the same name and schema already exists, this function creates a vDataFrame from the input relation.
Parameters¶
- schema: str, optional
Schema of the new relation. If empty, the temporary schema is used.
- name: str, optional
Name of the new relation.
Returns¶
- vDataFrame
the market vDataFrame.
Examples¶
If you call this loader without any arguments, the dataset is loaded using the default schema (public).
from verticapy.datasets import load_market load_market()
AbcFormAbcName123Price1 Boiled Spinach 3.83371571139 2 Canned Artichoke 3.38561047493 3 Canned Asparagus 2.5802971683 4 Canned Black beans 0.945681045 5 Canned Blackeye peas 0.910440813422 6 Canned Blackeye peas 0.9310398825 7 Canned Collard greens 0.8534190293 8 Canned Corn 0.8537281609 9 Canned Great northern beans 0.8733322508 10 Canned Green beans 0.824040727 11 Canned Mixed Vegetables 1.1300407331 12 Canned Mustard greens 0.976791582056 13 Canned Navy beans 0.970423315186 14 Canned Pinto beans 0.866189704098 15 Canned, Olives 4.18683171458 16 Canned, packed in syrup or water Cherries 3.51874337733 17 Dried Blackeye peas 1.58990085218 18 Dried Blackeye peas 1.613022434 19 Dried Cranberries 4.78674137766 20 Dried Figs 6.1253708776 21 Dried Great northern beans 1.53402874163 22 Dried Navy beans 1.4787507743 23 Dried Pineapple 5.49708634567 24 Dried Red Kidney Beans 1.67188888931 25 Fresh Apples 1.56751539145 26 Fresh Artichoke 2.3637333814 27 Fresh Bananas 0.566983414531 28 Fresh Blueberries 4.3911083709 29 Fresh Brussels sprouts 2.76355337151 30 Fresh Cantaloupe 0.520793672 31 Fresh Corn 2.69062315903 32 Fresh Grapes 2.093827412 33 Fresh Grapes 2.2358731965 34 Fresh Green beans 2.13997225241 35 Fresh Green peppers 1.4949708543 36 Fresh Honeydew melon 0.79665620543 37 Fresh Lettuce, Iceberg 1.21303942953 38 Fresh Mangoes 1.37756344703 39 Fresh Mustard greens 2.6792685486 40 Fresh Nectarines 1.7611484828 41 Fresh Okra 3.21355231 42 Fresh Peaches 1.59118685325 43 Fresh Peaches 1.6779315817 44 Fresh Pears 1.5175920102 45 Fresh Plums 1.82741600781 46 Fresh Potatoes 0.6037360906 47 Fresh Red peppers 2.3206705319 48 Fresh Strawberries 2.35880848311 49 Fresh Summer squash 1.63947703201 50 Fresh Summer squash 1.6400455025 51 Fresh Turnip greens 2.47174882117 52 Fresh Watermelon 0.3166387792 53 Fresh red cabbage Cabbage 1.05644972791 54 Fresh, consumed with peel Cucumbers 1.2555855801 55 Fresh, peeled Cucumbers 1.29593136814 56 Frozen Broccoli 1.8227837671 57 Frozen Brussels sprouts 2.0397358015 58 Frozen Cauliflower 1.6814349408 59 Frozen Collard greens 1.5921257034 60 Frozen Corn 1.5981945708 61 Frozen Green peas 1.64557267532 62 Frozen Mustard greens 1.5551743896 63 Frozen Okra 1.5662807702 64 Frozen Pineapple 0.6203795725 65 Frozen Spinach 1.760213418 66 Frozen Strawberries 2.6115889333 67 Frozen french fries Potatoes 1.17673673184 68 Frozen french fries Potatoes 1.2177194503 69 Full Heads Lettuce, Romaine 1.484034868 70 Grape and cherry, Tomatoes 3.4831293942 71 Juice, ready to drink Grapefruit 0.8494909232 72 Juice, ready to drink Pomegranate 3.0102739423 73 Large round, Tomatoes 2.0066199543 74 Packed in juice Apricots 1.4742760156 75 Packed in juice Fruit cocktail 1.4088850314 76 Packed in juice Peaches 1.96460660811 77 Packed in juice Pineapple 1.2761153689 78 Packed in syrup or water Pineapple 1.12844843614 79 Raisins Grapes 3.50091463439 80 Raw Spinach 3.8265942203 81 Raw Spinach 3.83371571139 82 Raw whole Carrots 0.741539992379 83 Ready to drink Apples 0.727287713105 84 Ready to drink Grapefruit 0.824989780378 85 Ready to drink Oranges 0.796288571647 86 Ready to drink Oranges 0.8467005261 87 Sliced Mushrooms 3.81042465 88 Beefsteak, Tomatoes 3.15921213872 89 Canned Artichoke 3.3174627313 90 Canned Carrots 1.06049032785 91 Canned Great northern beans 0.923915876218 92 Canned Kale 1.0686461381 93 Canned Mixed Vegetables 1.10743317098 94 Canned Mixed Vegetables 1.1153572418 95 Canned Spinach 1.1345923224 96 Canned Spinach 1.1471519614 97 Canned, Olives 5.0861220216 98 Cooked whole Carrots 0.7737514155 99 Dried Cranberries 4.6894038279 100 Dried Lima beans 1.73065564313 Rows: 1-100 | Columns: 3