Consumer_Price_Index_Food_Product_Statistics.csv

테이블 미리보기 준비 중...

전체 화면 보기

항목
파일명 CSV
파일 포맷 csv
설명 설명 없음
데이터셋 설명

This data table contains Consumer Price Index (CPI) monthly summary statistics for food categories in Manitoba and other provincial jurisdictions in Canada, from 2002 to present.

This data table contains Consumer Price Index (CPI) monthly summary statistics for food categories in Manitoba and other provincial jurisdictions in Canada, from 2002 to present. These data are displayed in the Manitoba Food Consumer Price Index Dashboard. The source of the information is the Statistics Canada Table 18-10-0004-01 Consumer Price Index, monthly, not seasonally adjusted. Data are updated monthly by Manitoba Agriculture from Statistics Canada sources. Fields included [Alias (Field Name): Field description] PROV_INDEX (PROV_INDEX): Index column for ordering data displayed in dashboard REF_DATE (REF_DATE): CPI reference date in yyyy-mm-dd format GEO (GEO): Province or territory name; also includes Canada as a whole YEAR (YEAR): Reference date year value MONTH (MONTH): Reference date numeric month value CPI (CPI): Consumer Price Index value PRODUCT (PRODUCT): CPI product group; food categories include: meat; fish, seafood and other marine products; dairy products; eggs; bakery and cereal products; fruit, fruit preparations and nuts; vegetables and vegetable preparations; other food products and non-alcoholic beverages; all foods PERCENT_CHANGE (PERCENT_CHANGE): Percentage change in CPI from the previous year of the same month

url 파일 다운로드 (안 되면 원본 페이지에서 다운 받으세요)
원본 페이지 https://open.canada.ca/data/en/dataset/9ecaebf4-a60a-99d7-c0a8-8871fd60ed9a
버전 2024-03-25
파일 크기3 MB
행 수 31,357
컬럼 수9
텍스트 인코딩UTF-8-SIG
컬럼 구분자 , 콤마 (COMMA)

import pandas as pd

df = pd.read_csv('Consumer_Price_Index_Food_Product_Statistics.csv', on_bad_lines='skip', delimiter=',', encoding='UTF-8-SIG', encoding_errors='ignore')

컬럼 타입 샘플
PROV_INDEX int64 1
REF_DATE string 2006/03/01 06:00:00+00
GEO string Alberta
YEAR int64 2006
MONTH int64 3
PRODUCT string All Foods
CPI float64 103.2
PERCENT_CHANGE float64 1.88
ObjectId int64 1

항목
생성일시 2024-06-12T12:39:02.317466
아이디 bafc832a-c233-4c17-8bb7-11ea2fa2ca5c
key ec672af1-02ba-459b-a053-da8947bc205f
메타데이터 수정일시 2024-06-13T21:00:58.740696
데이터셋 아이디 e805a2a5-e477-4de7-9f0b-b87dc3983d5d
상태 active
url https://geoportal.gov.mb.ca/api/download/v1/items/622b0512a98743788420b66b90cf34c1/csv?layers=0