vastorbit.datasets.load_market¶
- vastorbit.datasets.load_market(schema: str | None = None, name: str = 'market') VastFrame¶
Ingests the market dataset into the database.
This dataset is ideal for data exploration. If a table with the same name and schema already exists, this function creates a VastFrame from the input relation.
- Parameters:
schema (str, optional) – Schema of the new relation. Supports formats: - ‘schema_name’ (uses default catalog) - ‘catalog.schema_name’ (e.g., ‘vast.public’, ‘hive.default’) If None, uses ‘memory.default’ (temporary)
name (str, optional) – Name of the new relation.
- Returns:
The market VastFrame.
- Return type:
Examples
from vastorbit.datasets import load_market vdf = load_market()
AbcformVarchar(32)AbcnameVarchar(32)123priceDouble1 Fresh Acorn squash 1.1722478842 2 Fresh Apples 1.56751539145 3 Frozen Apples 0.537867915537 4 Ready to drink Apples 0.727287713105 5 Dried Apricots 7.73397208999 6 Fresh Apricots 3.0400719671 7 Packed in juice Apricots 1.64748926094 8 Packed in syrup, syrup discarded Apricots 1.55204253208 9 Canned Artichoke 3.38561047493 10 Fresh Artichoke 2.21305047929 11 Frozen Artichoke 6.22141832776 12 Canned Asparagus 2.5802971683 13 Fresh Asparagus 3.21349409304 14 Frozen Asparagus 5.85731991397 15 Fresh Avocado 2.23587438158 16 Fresh Bananas 0.566983414531 17 Canned Beets 1.01727546324 18 Frozen Berries, mixed 3.41021478336 19 Canned Black beans 0.980579717755 20 Dried Black beans 1.48978420263 21 Fresh Blackberries 5.77470825035 22 Frozen Blackberries 3.38850085426 23 Canned Blackeye peas 0.910440813422 24 Dried Blackeye peas 1.58990085218 25 Fresh Blueberries 4.73462168973 26 Frozen Blueberries 3.64325041591 27 Florets Broccoli 2.56847143403 28 Frozen Broccoli 1.86970036313 29 Heads Broccoli 1.63609690647 30 Fresh Brussels sprouts 2.76355337151 31 Frozen Brussels sprouts 2.13825366618 32 Fresh Butternut squash 1.24473670387 33 Fresh green cabbage Cabbage 0.579208394258 34 Fresh red cabbage Cabbage 1.05644972791 35 Sauerkraut Cabbage 1.26463509211 36 Fresh Cantaloupe 0.535873776106 37 Canned Carrots 1.06049032785 38 Cooked whole Carrots 0.741539992379 39 Frozen Carrots 1.46051272856 40 Raw baby Carrots 1.44745804876 41 Raw whole Carrots 0.741539992379 42 Florets Cauliflower 3.27064843515 43 Frozen Cauliflower 1.716444729 44 Heads Cauliflower 1.22881085623 45 Sticks Celery 2.2049694293 46 Trimmed bunches Celery 1.11365395418 47 Canned, packed in syrup or water Cherries 3.51874337733 48 Fresh Cherries 3.59298975549 49 Canned Collard greens 0.902593822572 50 Fresh Collard greens 2.63083790515 51 Frozen Collard greens 1.48055610021 52 Canned Corn 0.903905336945 53 Fresh Corn 2.69062315903 54 Frozen Corn 1.61907283226 55 Dried Cranberries 4.78674137766 56 Fresh, consumed with peel Cucumbers 1.29593136814 57 Fresh, peeled Cucumbers 1.29593136814 58 Dried Dates 4.79135143479 59 Dried Figs 5.7483176391 60 Packed in juice Fruit cocktail 1.49015356917 61 Packed in syrup or water Fruit cocktail 1.23945809447 62 Fresh Grapefruit 0.89780204118 63 Frozen Grapefruit 0.674839678618 64 Ready to drink Grapefruit 0.824989780378 65 Fresh Grapes 2.093827412 66 Frozen Grapes 0.720026097396 67 Raisins Grapes 3.50091463439 68 Ready to drink Grapes 0.913535086138 69 Canned Great northern beans 0.923915876218 70 Dried Great northern beans 1.53402874163 71 Canned Green beans 0.826939082717 72 Fresh Green beans 2.13997225241 73 Frozen Green beans 1.66929497324 74 Canned Green peas 1.01306918204 75 Frozen Green peas 1.64557267532 76 Fresh Green peppers 1.4103626315 77 Fresh Honeydew melon 0.79665620543 78 Canned Kale 1.0686461381 79 Fresh Kale 2.8073017758 80 Frozen Kale 1.71622542952 81 Fresh Kiwi 2.04468340797 82 Dried Lentils 1.3850358051 83 Fresh Lettuce, Iceberg 1.21303942953 84 Full Heads Lettuce, Romaine 1.83609831617 85 Hearts Lettuce, Romaine 2.75300289757 86 Canned Lima beans 1.3835692655 87 Dried Lima beans 1.73065564313 88 Frozen Lima beans 1.83572456732 89 Dried Mangoes 8.50464930168 90 Fresh Mangoes 1.37756344703 91 Canned Mixed Vegetables 1.10743317098 92 Canned Mixed Vegetables 1.32442847693 93 Frozen Mixed Vegetables 1.38869195156 94 Frozen Mixed Vegetables 1.80159269637 95 Sliced Mushrooms 3.82158437966 96 Whole Mushrooms 3.41198535117 97 Canned Mustard greens 0.976791582056 98 Fresh Mustard greens 2.56923501629 99 Frozen Mustard greens 1.45594273557 100 Canned Navy beans 0.970423315186 Rows: 1-100 | Columns: 3