ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืกื“ืจืช ืžืืžืจื™ื ื–ื• ืžื•ืงื“ืฉืช ืœื—ืงืจ ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื” ื‘ืขื™ืจ ื”ืžืจื›ื–ื™ืช ืฉืœ ืขืžืง ื”ืกื™ืœื™ืงื•ืŸ - ืกืŸ ืคืจื ืกื™ืกืงื•. ืกืŸ ืคืจื ืกื™ืกืงื• ื”ื™ื "ืžื•ืกืงื‘ื”" ื”ื˜ื›ื ื•ืœื•ื’ื™ืช ืฉืœ ื”ืขื•ืœื ืฉืœื ื•, ืžืฉืชืžืฉืช ื‘ื“ื•ื’ืžื” ืฉืœื” (ื‘ืขื–ืจืช ื ืชื•ื ื™ื ืคืชื•ื—ื™ื) ื›ื“ื™ ืœืฆืคื•ืช ื‘ื”ืชืคืชื—ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืขืจื™ื ื•ื‘ื™ืจื•ืช ื’ื“ื•ืœื•ืช.

ื‘ื ื™ื™ืช ื’ืจืคื™ื ื•ื—ื™ืฉื•ื‘ื™ื ื‘ื•ืฆืขื” ื‘ ืžื—ื‘ืจืช ืฆื“ืง (ื‘ืคืœื˜ืคื•ืจืžืช Kaggle.com).

ื ืชื•ื ื™ื ืขืœ ื™ื•ืชืจ ืžืžื™ืœื™ื•ืŸ ื”ื™ืชืจื™ ื‘ื ื™ื™ื” (ืจืฉื•ืžื•ืช ื‘ืฉื ื™ ืžืขืจื›ื™ ื ืชื•ื ื™ื) ืžืžื—ืœืงืช ื”ื‘ื ื™ื™ื” ืฉืœ ืกืŸ ืคืจื ืกื™ืกืงื• - ืžืืคืฉืจื™ื ืœื ืชื— ืœื ืจืง ืืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื” ื‘ืขื™ืจ, ืื‘ืœ ื’ื ืœืฉืงื•ืœ ื‘ื‘ื™ืงื•ืจืชื™ื•ืช ื”ืžื’ืžื•ืช ื”ืื—ืจื•ื ื•ืช ื•ื”ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืžื”ืœืš 40 ื”ืฉื ื™ื ื”ืื—ืจื•ื ื•ืช, ื‘ื™ืŸ 1980 ืœ-2019.

ื ืชื•ื ื™ื ืคืชื•ื—ื™ื ืžืืคืฉืจื™ื ืœื—ืงื•ืจ ื’ื•ืจืžื™ื ืขื™ืงืจื™ื™ื ืฉื”ืฉืคื™ืขื• ื•ื™ืฉืคื™ืขื• ืขืœ ื”ืชืคืชื—ื•ืช ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืขื™ืจ, ืžื—ืœืงื™ื ืื•ืชื ืœ"ื—ื™ืฆื•ื ื™ื™ื" (ืชื ื•ื—ื•ืช ื›ืœื›ืœื™ื•ืช ื•ืžืฉื‘ืจื™ื) ื•"ืคื ื™ืžื™ื™ื" (ื”ืฉืคืขืช ื—ื’ื™ื ื•ืžื—ื–ื•ืจื™ื ืขื•ื ืชื™ื™ื-ืฉื ืชื™ื™ื).

ืชื•ื›ืŸ

ืคืชื— ื ืชื•ื ื™ื ื•ืกืงื™ืจื” ืฉืœ ืคืจืžื˜ืจื™ื ืจืืฉื•ื ื™ื™ื
ืคืขื™ืœื•ืช ื‘ื ื™ื™ื” ืฉื ืชื™ืช ื‘ืกืŸ ืคืจื ืกื™ืกืงื•
ืฆื™ืคื™ื™ื” ื•ืžืฆื™ืื•ืช ื‘ืขืช ื”ื›ื ืช ื”ืขืจื›ื•ืช ืขืœื•ื™ื•ืช
ืคืขื™ืœื•ืช ื‘ื ื™ื™ื” ื‘ื”ืชืื ืœืขื•ื ื” ื‘ืฉื ื”
ืกืš ื”ื”ืฉืงืขื” ื‘ื ื“ืœ"ืŸ ื‘ืกืŸ ืคืจื ืกื™ืกืงื•
ื‘ืื™ืœื• ืชื—ื•ืžื™ื ื”ื ื”ืฉืงื™ืขื• ื‘ืžื”ืœืš 40 ื”ืฉื ื™ื ื”ืื—ืจื•ื ื•ืช?
ืขืœื•ืช ืžืฉื•ืขืจืช ืžืžื•ืฆืขืช ืฉืœ ื‘ืงืฉื” ืœืคื™ ืžื—ื•ื– ืขื™ืจ
ืกื˜ื˜ื™ืกื˜ื™ืงื” ืขืœ ื”ืžืกืคืจ ื”ื›ื•ืœืœ ืฉืœ ื‘ืงืฉื•ืช ืœืคื™ ื—ื•ื“ืฉ ื•ื™ื•ื
ื”ืขืชื™ื“ ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ืฉืœ ืกืŸ ืคืจื ืกื™ืกืงื•

ืคืชื™ื—ืช ื ืชื•ื ื™ื ื•ืกืงื™ืจืช ืคืจืžื˜ืจื™ื ื‘ืกื™ืกื™ื™ื.

ื–ื” ืœื ืชืจื’ื•ื ืฉืœ ื”ืžืืžืจ. ืื ื™ ื›ื•ืชื‘ ื‘ืœื™ื ืงื“ืื™ืŸ ื•ื›ื“ื™ ืœื ืœื™ืฆื•ืจ ื’ืจืคื™ืงื” ื‘ืžืกืคืจ ืฉืคื•ืช, ื›ืœ ื”ื’ืจืคื™ืงื” ื”ื™ื ื‘ืื ื’ืœื™ืช. ืงื™ืฉื•ืจ ืœื’ืจืกื” ื”ืื ื’ืœื™ืช: ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ื‘ื ื™ื™ื”.

ืงื™ืฉื•ืจ ืœื—ืœืง ื”ืฉื ื™:
ืžื’ื–ืจื™ ื‘ื ื™ื™ื” ื”ื™ื™ืค ื•ืขืœื•ืช ื”ืขื‘ื•ื“ื” ื‘ืขื™ืจ ื”ื’ื“ื•ืœื”. ืื™ื ืคืœืฆื™ื” ื•ืฆืžื™ื—ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•

ื ืชื•ื ื™ ื”ื™ืชืจ ื‘ื ื™ื™ื” ืฉืœ ื”ืขื™ืจ ืกืŸ ืคืจื ืกื™ืกืงื• - ืžืชื•ืš ืคื•ืจื˜ืœ ื ืชื•ื ื™ื ืคืชื•ื— - data.sfgov.org. ืœืคื•ืจื˜ืœ ืžืกืคืจ ืžืขืจื›ื™ ื ืชื•ื ื™ื ื‘ื ื•ืฉื ื‘ื ื™ื™ื”. ืฉื ื™ ืžืขืจื›ื™ ื ืชื•ื ื™ื ื›ืืœื” ืžืื—ืกื ื™ื ื•ืžืขื“ื›ื ื™ื ื ืชื•ื ื™ื ืขืœ ื”ื™ืชืจื™ื ืฉื ื™ืชื ื• ืœื‘ื ื™ื™ื” ืื• ืชื™ืงื•ืŸ ืฉืœ ื—ืคืฆื™ื ื‘ืขื™ืจ:

ืžืขืจื›ื™ ื ืชื•ื ื™ื ืืœื” ืžื›ื™ืœื™ื ืžื™ื“ืข ืขืœ ื”ื™ืชืจื™ ื‘ื ื™ื™ื” ืฉื ื™ืชื ื•, ืขื ืžืืคื™ื™ื ื™ื ืฉื•ื ื™ื ืฉืœ ื”ื—ืคืฅ ืฉืขื‘ื•ืจื• ื ื™ืชืŸ ื”ื”ื™ืชืจ. ื”ืžืกืคืจ ื”ื›ื•ืœืœ ืฉืœ ืขืจื›ื™ื (ื”ืจืฉืื•ืช) ืฉื”ืชืงื‘ืœื• ื‘ืชืงื•ืคื” 1980-2019 - 1 ื”ื™ืชืจื™ื.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื”ืคืจืžื˜ืจื™ื ื”ืขื™ืงืจื™ื™ื ืžืžืขืจืš ื ืชื•ื ื™ื ื–ื” ืฉืฉื™ืžืฉื• ืœื ื™ืชื•ื—:

  • ืชืืจื™ืš_ื™ืฆื™ืจืช_ืื™ืฉื•ืจ - ืชืืจื™ืš ื™ืฆื™ืจืช ื”ื‘ืงืฉื” (ืœืžืขืฉื”, ื”ื™ื•ื ืฉื‘ื• ืžืชื—ื™ืœื•ืช ืขื‘ื•ื“ื•ืช ื”ื‘ื ื™ื™ื”)
  • ืชื™ืื•ืจ - ืชื™ืื•ืจ ื”ื‘ืงืฉื” (ืฉืชื™ื™ื ืื• ืฉืœื•ืฉ ืžื™ืœื•ืช ืžืคืชื— ื”ืžืชืืจื•ืช ืืช ืคืจื•ื™ืงื˜ ื”ื‘ื ื™ื™ื” (ื”ืขื‘ื•ื“ื”) ืฉืขื‘ื•ืจื” ื ื•ืฆืจ ื”ื”ื™ืชืจ)
  • ืžื—ื™ืจ ืžืฉื•ืขืจ - ืขืœื•ืช ืžืฉื•ืขืจืช (ืžืฉื•ืขืจืช) ืฉืœ ืขื‘ื•ื“ื•ืช ื‘ื ื™ื™ื”
  • ืขืœื•ืช_ืžืชื•ืงื ืช - ืขืœื•ืช ืžืชื•ืงื ืช (ืขืœื•ืช ืขื‘ื•ื“ื” ืœืื—ืจ ื”ืขืจื›ื” ืžื—ื“ืฉ, ื”ื’ื“ืœื” ืื• ื™ืจื™ื“ื” ืฉืœ ื”ื ืคื—ื™ื ื”ืจืืฉื•ื ื™ื™ื ืฉืœ ื”ื‘ืงืฉื”)
  • ืงื™ื™ื_ืฉื™ืžื•ืฉ - ืกื•ื’ ื“ื™ื•ืจ (ื‘ื™ืช ื—ื“, ื“ื• ืžืฉืคื—ืชื™, ื“ื™ืจื•ืช, ืžืฉืจื“ื™ื, ื™ื™ืฆื•ืจ ื•ื›ื•')
  • ืžื™ืงื•ื“, ืžื™ืงื•ื - ืงื•ืื•ืจื“ื™ื ื˜ื•ืช ืžื™ืงื•ื“ ื•ืื•ื‘ื™ื™ืงื˜

ืคืขื™ืœื•ืช ื‘ื ื™ื™ื” ืฉื ืชื™ืช ื‘ืกืŸ ืคืจื ืกื™ืกืงื•

ื”ื’ืจืฃ ืฉืœื”ืœืŸ ืžืฆื™ื’ ืืช ื”ืคืจืžื˜ืจื™ื ืžื—ื™ืจ ืžืฉื•ืขืจ ะธ ืขืœื•ืช_ืžืชื•ืงื ืช ืžื•ืฆื’ ื›ื”ืชืคืœื’ื•ืช ืฉืœ ืกืš ืขืœื•ืช ื”ืขื‘ื•ื“ื” ืœืคื™ ื—ื•ื“ืฉ.

data_cost_m = data_cost.groupby(pd.Grouper(freq='M')).sum()

ื›ื“ื™ ืœื”ืคื—ื™ืช ืืช ื”"ื—ืจื™ื’ื™ื" ื”ื—ื•ื“ืฉื™ื™ื, ื”ื ืชื•ื ื™ื ื”ื—ื•ื“ืฉื™ื™ื ืžืงื•ื‘ืฆื™ื ืœืคื™ ืฉื ื”. ื’ืจืฃ ื›ืžื•ืช ื”ื›ืกืฃ ื”ืžื•ืฉืงืข ืœืคื™ ืฉื ื” ืงื™ื‘ืœ ืฆื•ืจื” ื™ื•ืชืจ ื”ื’ื™ื•ื ื™ืช ื•ื ื™ืชื ืช ืœื ื™ืชื•ื—.

data_cost_y = data_cost.groupby(pd.Grouper(freq='Y')).sum()

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืžื‘ื•ืกืก ืขืœ ื”ืชื ื•ืขื” ื”ืฉื ืชื™ืช ืฉืœ ืกื›ื•ื ื”ืขืœื•ื™ื•ืช (ื›ืœ ื”ื”ื™ืชืจื™ื ืœืฉื ื”) ืœืžืชืงื ื™ื ื‘ืขื™ืจ ื’ื•ืจืžื™ื ื›ืœื›ืœื™ื™ื ืฉื”ืฉืคื™ืขื• ืž-1980 ืขื“ 2019 ื ืจืื™ื ื‘ื‘ื™ืจื•ืจ ืขืœ ืžืกืคืจ ื•ืขืœื•ืชื ืฉืœ ืคืจื•ื™ืงื˜ื™ ื‘ื ื™ื™ื”, ืื• ืื—ืจืช ืขืœ ื”ืฉืงืขื•ืช ื‘ื ื“ืœ"ืŸ ื‘ืกืŸ ืคืจื ืกื™ืกืงื•.

ืžืกืคืจ ื”ื™ืชืจื™ ื”ื‘ื ื™ื™ื” (ืžืกืคืจ ืžืฉืจื•ืช ื”ื‘ื ื™ื™ื” ืื• ืžืกืคืจ ื”ื”ืฉืงืขื•ืช) ื‘-40 ื”ืฉื ื™ื ื”ืื—ืจื•ื ื•ืช ืงืฉื•ืจ ืงืฉืจ ื”ื“ื•ืง ืœืคืขื™ืœื•ืช ื”ื›ืœื›ืœื™ืช ื‘ืขืžืง ื”ืกื™ืœื™ืงื•ืŸ.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื”ืฉื™ื ื”ืจืืฉื•ืŸ ืฉืœ ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื” ื”ื™ื” ืงืฉื•ืจ ืœื”ื™ื™ืค ื”ืืœืงื˜ืจื•ื ื™ืงื” ืฉืœ ืืžืฆืข ืฉื ื•ืช ื”-80 ื‘ืขืžืง. ืžื™ืชื•ืŸ ื”ืืœืงื˜ืจื•ื ื™ืงื” ื•ื”ื‘ื ืงืื•ืช ืฉื”ืชืคืชื— ื‘-1985 ื”ื‘ื™ื ืืช ืฉื•ืง ื”ื ื“ืœ"ืŸ ื”ืื–ื•ืจื™ ืœื“ืขื™ื›ื” ืฉืžืžื ื” ื”ื•ื ืœื ื”ืชืื•ืฉืฉ ื‘ืžืฉืš ื›ืžืขื˜ ืขืฉื•ืจ.

ืœืื—ืจ ืžื›ืŸ, ืคืขืžื™ื™ื ื ื•ืกืคื•ืช (ื‘ืฉื ื™ื 1993-2000 ื•-2009-2016) ืœืคื ื™ ืงืจื™ืกืช ื‘ื•ืขืช ื”ื“ื•ื˜ืงื•ื ื•ื”ืคืจื™ื—ื” ื”ื˜ื›ื ื•ืœื•ื’ื™ืช ืฉืœ ื”ืฉื ื™ื ื”ืื—ืจื•ื ื•ืช ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ืฉืœ ืกืŸ ืคืจื ืกื™ืกืงื• ื—ื•ื•ืชื” ืฆืžื™ื—ื” ืคืจื‘ื•ืœื™ืช ืฉืœ ื›ืžื” ืืœืคื™ ืื—ื•ื–ื™ื..

ืขืœ ื™ื“ื™ ื”ืกืจืช ืคืกื’ื•ืช ื”ื‘ื™ื ื™ื™ื ื•ื”ืฉืคืœ ื•ื”ืฉืืจืช ืขืจื›ื™ ื”ืžื™ื ื™ืžื•ื ื•ื”ืžืงืกื™ืžื•ื ืœื›ืœ ืžื—ื–ื•ืจ ื›ืœื›ืœื™, ื‘ืจื•ืจ ืขื“ ื›ืžื” ืชื ื•ื“ื•ืช ืฉื•ืง ื’ื“ื•ืœื•ืช ืคืงื“ื• ืืช ื”ืขื ืฃ ื‘ืžื”ืœืš 40 ื”ืฉื ื™ื ื”ืื—ืจื•ื ื•ืช.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื”ืขืœื™ื™ื” ื”ื’ื“ื•ืœื” ื‘ื™ื•ืชืจ ื‘ื”ืฉืงืขื” ื‘ื‘ื ื™ื™ื” ื”ืชืจื—ืฉื” ื‘ืžื”ืœืš ืคืจื™ื—ืช ื”ื“ื•ื˜-ืงื•ื, ื›ืืฉืจ ื‘ื™ืŸ 1993 ืœ-2001 ื”ื•ืฉืงืขื• 10 ืžื™ืœื™ืืจื“ ื“ื•ืœืจ ื‘ืฉื™ืคื•ืฅ ื•ื‘ื ื™ื”, ืื• ื›ืžื™ืœื™ืืจื“ ื“ื•ืœืจ ื‘ืฉื ื”. ืื ื ืกืคื•ืจ ื‘ืž"ืจ (ื”ืขืœื•ืช ืฉืœ 1 ืž"ืจ ื‘-1 ื”ื™ื 1995 ื“ื•ืœืจ), ืžื“ื•ื‘ืจ ื‘ื›-3000 ืž"ืจ ื‘ืฉื ื” ืœืžืฉืš 350 ืฉื ื™ื, ื”ื—ืœ ืž-000.

ื”ื’ื™ื“ื•ืœ ื‘ืกืš ื”ื”ืฉืงืขื•ืช ื”ืฉื ืชื™ ื‘ืชืงื•ืคื” ื–ื• ื”ืกืชื›ื ื‘-1215%.

ื”ื—ื‘ืจื•ืช ืฉืฉื›ืจื• ืฆื™ื•ื“ ื‘ื ื™ื™ื” ื‘ืชืงื•ืคื” ื–ื• ื”ื™ื• ื“ื•ืžื•ืช ืœื—ื‘ืจื•ืช ืฉืžื›ืจื• ืืชื™ื ื‘ืชืงื•ืคืช ื”ื‘ื”ืœื” ืœื–ื”ื‘ (ื‘ืื•ืชื• ืื–ื•ืจ ื‘ืืžืฆืข ื”ืžืื” ื”-19). ืจืง ืฉื‘ืžืงื•ื ืืชื™ื, ื‘ืฉื ื•ืช ื”ืืœืคื™ื™ื ื›ื‘ืจ ื”ื™ื• ืžื ื•ืคื™ื ื•ืžืฉืื‘ื•ืช ื‘ื˜ื•ืŸ ืœื—ื‘ืจื•ืช ื‘ื ื™ื™ื” ืฉื–ื” ืขืชื” ื ื•ืฆืจื•, ืฉืจืฆื• ืœื”ืจื•ื•ื™ื— ื›ืกืฃ ืขืœ ืชื ื•ืคืช ื”ื‘ื ื™ื™ื”.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืœืื—ืจ ื›ืœ ืื—ื“ ืžื”ืžืฉื‘ืจื™ื ื”ืจื‘ื™ื ืฉื—ื•ื•ื” ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืžื”ืœืš ื”ืฉื ื™ื, ื‘ืฉื ืชื™ื™ื ื”ื‘ืื•ืช ืฉืœืื—ืจ ื”ืžืฉื‘ืจ, ื”ืฉืงืขื•ืช (ื›ืžื•ืช ื”ื‘ืงืฉื•ืช ืœื”ื™ืชืจื™ื) ืœื‘ื ื™ื” ื™ืจื“ ื‘-50% ืœืคื—ื•ืช ื‘ื›ืœ ืคืขื.

ื”ืžืฉื‘ืจื™ื ื”ื’ื“ื•ืœื™ื ื‘ื™ื•ืชืจ ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ื”ืชืจื—ืฉื• ื‘ืฉื ื•ืช ื”-90. ื›ืืฉืจ, ืขื ืžื—ื–ื•ืจื™ื•ืช ืฉืœ 5 ืฉื ื™ื, ื”ืขื ืฃ ื™ืจื“ (-85% ื‘ืชืงื•ืคื” 1983-1986), ื•ืื– ืขืœื” ืฉื•ื‘ (+895% ื‘ืชืงื•ืคื” 1988-1992), ื•ื ืฉืืจ ื‘ืžื•ื ื—ื™ื ืฉื ืชื™ื™ื ื‘-1981, 1986, 1988 , 1993 - ื‘ืื•ืชื” ืจืžื”.

ืœืื—ืจ 1993, ื›ืœ ื”ื™ืจื™ื“ื•ืช ืฉืœืื—ืจ ืžื›ืŸ ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ื”ืกืชื›ืžื• ื‘-50% ืœื›ืœ ื”ื™ื•ืชืจ. ืื‘ืœ ื”ืžืฉื‘ืจ ื”ื›ืœื›ืœื™ ืžืชืงืจื‘ (ืขืงื‘ COVID-19) ืขืœื•ืœ ืœื™ืฆื•ืจ ืžืฉื‘ืจ ืฉื™ื ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืชืงื•ืคื” 2017-2021, ืฉื™ืจื™ื“ืชื” ื›ื‘ืจ ื‘ืชืงื•ืคื” 2017-2019 ืžืกืชื›ืžืช ื‘ื™ื•ืชืจ ืž-60%.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื’ื™ื“ื•ืœ ืื•ื›ืœื•ืกื™ื™ืช ืกืŸ ืคืจื ืกื™ืกืงื• ื“ื™ื ืžื™ืงื” ื’ื ื‘ืชืงื•ืคื” 1980-1993 ื”ืจืื” ืฆืžื™ื—ื” ื›ืžืขื˜ ืืงืกืคื•ื ื ืฆื™ืืœื™ืช. ื”ื—ื•ื–ืง ื”ื›ืœื›ืœื™ ื•ื”ืื ืจื’ื™ื” ื”ื—ื“ืฉื ื™ืช ืฉืœ ืขืžืง ื”ืกื™ืœื™ืงื•ืŸ ื”ื™ื• ื”ื‘ืกื™ืก ื”ืื™ืชืŸ ืฉืขืœื™ื• ื ื‘ื ืชื” ื”ื”ื™ืคืจื‘ื•ืœ ืฉืœ ื”ื›ืœื›ืœื” ื”ื—ื“ืฉื”, ื”ืจื ืกื ืก ื”ืืžืจื™ืงืื™ ื•ื”ื“ื•ื˜-ืงื•ื. ื–ื” ื”ื™ื” ื”ืžื•ืงื“ ืฉืœ ื”ื›ืœื›ืœื” ื”ื—ื“ืฉื”. ืื‘ืœ ื‘ื ื™ื’ื•ื“ ืœืขืœื™ื™ื” ื‘ื”ืฉืงืขื•ืช ื‘ื ื“ืœ"ืŸ, ืื—ืจื™ ืฉื™ื ื”ื“ื•ื˜-ืงื•ื, ื”ืื•ื›ืœื•ืกื™ื™ื” ื“ื•ื•ืงื ืขืœืชื” ื‘ืจืžื”.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืœืคื ื™ ืฉื™ื ื”ื“ื•ื˜-ืงื•ื ื‘-2001, ื’ื™ื“ื•ืœ ื”ืื•ื›ืœื•ืกื™ื™ื” ื”ืฉื ืชื™ ืžืื– 1950 ื”ื™ื” ื‘ืขืจืš 1% ื‘ืฉื ื”. ื•ืื–, ืœืื—ืจ ื”ืชืžื•ื˜ื˜ื•ืช ื”ื‘ื•ืขื”, ื”ื•ืื˜ื” ื–ืจื™ืžืช ื”ืื•ื›ืœื•ืกื™ื™ื” ื”ื—ื“ืฉื” ื•ืžืื– 2001 ื”ื™ื ืขื•ืžื“ืช ืขืœ 0.2 ืื—ื•ื– ื‘ืœื‘ื“ ื‘ืฉื ื”.

ื‘ืฉื ืช 2019 (ืœืจืืฉื•ื ื” ืžืื– 1950), ื“ื™ื ืžื™ืงืช ื”ืฆืžื™ื—ื” ื”ืจืืชื” ื™ืฆื™ืื” ืฉืœ ืื•ื›ืœื•ืกื™ื” (-0.21% ืื• 7000 ืื™ืฉ) ืžื”ืขื™ืจ ืกืŸ ืคืจื ืกื™ืกืงื•.

ืฆื™ืคื™ื™ื” ื•ืžืฆื™ืื•ืช ื‘ืขืช ื”ื›ื ืช ื”ืขืจื›ื•ืช ืขืœื•ื™ื•ืช

ื‘ืžืขืจืš ื”ื ืชื•ื ื™ื ื”ืžืฉืžืฉื™ื, ื”ื ืชื•ื ื™ื ืขืœ ืขืœื•ืช ื”ื”ื™ืชืจ ืœืคืจื•ื™ืงื˜ ื‘ื ื™ื™ื” ืžื—ื•ืœืงื™ื ืœ:

  • ืขืœื•ืช ืžืฉื•ืขืจืช ืžืงื•ืจื™ืช (ืžื—ื™ืจ ืžืฉื•ืขืจ)
  • ืขืœื•ืช ืขื‘ื•ื“ื” ืœืื—ืจ ืฉืขืจื•ืš (ืขืœื•ืช_ืžืชื•ืงื ืช)

ื‘ืชืงื•ืคื•ืช ืคืจื™ื—ื”, ื”ืžื˜ืจื” ื”ืขื™ืงืจื™ืช ืฉืœ ืฉืขืจื•ืš ื”ื™ื ืœื”ื’ื“ื™ืœ ืืช ื”ืขืœื•ืช ื”ืจืืฉื•ื ื™ืช, ื›ืืฉืจ ื”ืžืฉืงื™ืข (ืœืงื•ื— ื”ื‘ื ื™ื™ื”) ืžืจืื” ืชื™ืื‘ื•ืŸ ืœืื—ืจ ืชื—ื™ืœืช ื”ื‘ื ื™ื™ื”.
ื‘ื–ืžืŸ ืžืฉื‘ืจ ื”ื ืžืฉืชื“ืœื™ื ืœื ืœื—ืจื•ื’ ืžื”ืขืœื•ื™ื•ืช ื”ืžืฉื•ืขืจื•ืช, ื•ื”ื”ืขืจื›ื•ืช ื”ืจืืฉื•ื ื™ื•ืช ื›ืžืขื˜ ื•ืœื ืขื•ื‘ืจื•ืช ืฉื™ื ื•ื™ื™ื (ืœืžืขื˜ ืจืขื™ื“ืช ื”ืื“ืžื” ืฉืœ 1989).

ืขืœ ืคื™ ื”ื’ืจืฃ ืฉื ื‘ื ื” ืขืœ ื”ื”ืคืจืฉ ื‘ื™ืŸ ื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื•ื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช (ืขืœื•ืช_ืžืชื•ืงื ืช - ืขืœื•ืช_ื”ืขืจื›ื”), ื ื™ืชืŸ ืœืจืื•ืช ื›ื™:

ื›ืžื•ืช ืขืœื™ื™ืช ื”ืขืœื•ืช ื‘ืขืช ื”ืขืจื›ื” ืžื—ื“ืฉ ืฉืœ ื”ื™ืงืฃ ืขื‘ื•ื“ื•ืช ื”ื‘ื ื™ื™ื” ืชืœื•ื™ื” ื™ืฉื™ืจื•ืช ื‘ืžื—ื–ื•ืจื™ ื”ืคืจื™ื—ื” ื”ื›ืœื›ืœื™ืช

data_spread = data_cost.assign(spread = (data_cost.revised_cost-data_cost.estimated_cost))

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื‘ืชืงื•ืคื•ืช ืฉืœ ืฆืžื™ื—ื” ื›ืœื›ืœื™ืช ืžื”ื™ืจื”, ืœืงื•ื—ื•ืช ื”ืขื‘ื•ื“ื” (ืžืฉืงื™ืขื™ื) ืžื•ืฆื™ืื™ื ืืช ื›ืกืคื™ื”ื ื‘ื ื“ื™ื‘ื•ืช ืจื‘ื”, ื•ืžื’ื“ื™ืœื™ื ืืช ื‘ืงืฉื•ืชื™ื”ื ืœืื—ืจ ืชื—ื™ืœืช ื”ืขื‘ื•ื“ื”.

ื”ืœืงื•ื— (ื”ืžืฉืงื™ืข), ื—ืฉ ื‘ื™ื˜ื—ื•ืŸ ื›ืœื›ืœื™, ืžื‘ืงืฉ ืžืงื‘ืœืŸ ื”ื‘ื ื™ื™ื” ืื• ื”ืื“ืจื™ื›ืœ ืœื”ืืจื™ืš ืืช ื”ื™ืชืจ ื”ื‘ื ื™ื™ื” ืฉื›ื‘ืจ ื ื™ืชืŸ. ื–ื• ืขืฉื•ื™ื” ืœื”ื™ื•ืช ื”ื—ืœื˜ื” ืœื”ื’ื“ื™ืœ ืืช ื”ืื•ืจืš ื”ืจืืฉื•ื ื™ ืฉืœ ื”ื‘ืจื™ื›ื” ืื• ืœื”ื’ื“ื™ืœ ืืช ืฉื˜ื— ื”ื‘ื™ืช (ืœืื—ืจ ืชื—ื™ืœืช ื”ืขื‘ื•ื“ื” ื•ื”ื•ืฆืืช ื”ื™ืชืจ ื‘ื ื™ื™ื”).

ื‘ืฉื™ื ืขื™ื“ืŸ ื”ื“ื•ื˜-ืงื•ื, ื”ื•ืฆืื•ืช "ื ื•ืกืคื•ืช" ื›ืืœื” ื”ื’ื™ืขื• ืœืžื™ืœื™ืืจื“ "ื ื•ืกืคื™ื" ื‘ืฉื ื”.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืื ืžืกืชื›ืœื™ื ืขืœ ื”ื˜ื‘ืœื” ื”ื–ื• ื›ื‘ืจ ื‘ืื—ื•ื–ื™ื, ืื–ื™ ื”ืขืœื™ื™ื” ื‘ืฉื™ื ื”ืื•ืžื“ืŸ (100% ืื• ืคื™ 2 ืžื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื”ืžืงื•ืจื™ืช) ื”ืชืจื—ืฉื” ื‘ืฉื ื” ืฉืœืคื ื™ ืจืขื™ื“ืช ื”ืื“ืžื” ืฉื”ืชืจื—ืฉื” ื‘-1989 ืœื™ื“ ื”ืขื™ืจ. ืื ื™ ืžื ื™ื— ืฉืื—ืจื™ ืจืขื™ื“ืช ื”ืื“ืžื” ืคืจื•ื™ืงื˜ื™ ื‘ื ื™ื™ื” ืฉื”ื—ืœื• ื‘-1988 ื“ืจืฉื•, ืœืื—ืจ ืจืขื™ื“ืช ื”ืื“ืžื” ื‘-1989, ื™ื•ืชืจ ื–ืžืŸ ื•ืžื™ืžื•ืŸ ืœื‘ื™ืฆื•ืข.

ืœืขื•ืžืช ื–ืืช, ืขื“ื›ื•ืŸ ื›ืœืคื™ ืžื˜ื” ืฉืœ โ€‹โ€‹ื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช (ืฉื”ืชืจื—ืฉื” ืจืง ืคืขื ืื—ืช ื‘ืžื”ืœืš ื”ืชืงื•ืคื” ืฉื‘ื™ืŸ 1980 ืœ-2019) ืžืกืคืจ ืฉื ื™ื ืœืคื ื™ ืจืขื™ื“ืช ื”ืื“ืžื” ื ื•ื‘ืขืช ื›ื›ืœ ื”ื ืจืื” ืžื”ืขื•ื‘ื“ื” ืฉื—ืœืง ืžื”ืคืจื•ื™ืงื˜ื™ื ืฉื”ื—ืœื• ื‘ืฉื ื™ื 1986-1987 ื”ื•ืงืคืื• ืื• ืฉื”ื”ืฉืงืขื•ืช ื‘ืคืจื•ื™ืงื˜ื™ื ืืœื• ืงื•ืฆืฆื•. ืžื˜ื”. ื‘ื–ืžืŸ ื‘ืžืžื•ืฆืข ืขื‘ื•ืจ ื›ืœ ืคืจื•ื™ืงื˜ ืฉื”ื—ืœ ื‘-1987 - ื”ื”ืคื—ืชื” ื‘ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื”ื™ื™ืชื” -20% ืžื”ืชื•ื›ื ื™ืช ื”ืžืงื•ืจื™ืช.

data_spred_percent = data_cost_y.assign(spred = ((data_cost_y.revised_cost-data_cost_y.estimated_cost)/data_cost_y.estimated_cost*100))

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืขืœื™ื™ื” ื‘ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื”ืจืืฉื•ื ื™ืช ืฉืœ ื™ื•ืชืจ ืž-40% ื”ืฆื‘ื™ืขื” ืื• ื”ื™ื™ืชื” ืื•ืœื™ ืชื•ืฆืื” ืฉืœ ื”ื‘ื•ืขื” ื”ืžืชืงืจื‘ืช ื‘ืฉื•ืง ื”ืคื™ื ื ืกื™ ื•ืœืื—ืจ ืžื›ืŸ ื‘ืฉื•ืง ื”ื‘ื ื™ื™ื”.

ืžื”ื™ ื”ืกื™ื‘ื” ืœื™ืจื™ื“ื” ื‘ืคืขืจ (ื”ื”ื‘ื“ืœ) ื‘ื™ืŸ ื”ืขืœื•ื™ื•ืช ื”ืžืฉื•ืขืจื•ืช ืœืขืœื•ืช ื”ืžืชื•ืงื ื•ืช ืœืื—ืจ 2007?

ืื•ืœื™ ื”ืžืฉืงื™ืขื™ื ื”ืชื—ื™ืœื• ืœื‘ื—ื•ืŸ ื”ื™ื˜ื‘ ืืช ื”ืžืกืคืจื™ื (ื”ืกื›ื•ื ื”ืžืžื•ืฆืข ืœืื•ืจืš 20 ืฉื ื” ืขืœื” ืž-100 ืืœืฃ ื“ื•ืœืจ ืœ-2 ืžื™ืœื™ื•ืŸ ื“ื•ืœืจ) ืื• ืื•ืœื™ ืžื—ืœืงืช ื”ื‘ื ื™ื™ื”, ืฉืžื ืขื” ื•ืžืขื›ื‘ืช ื‘ื•ืขื•ืช ืฆืฆื•ืช ื‘ืฉื•ืง ื”ื ื“ืœ"ืŸ, ื”ืฆื™ื’ื” ื›ืœืœื™ื ื•ื”ื’ื‘ืœื•ืช ื—ื“ืฉื•ืช ื›ื“ื™ ืœืฆืžืฆื ืžื ื™ืคื•ืœืฆื™ื•ืช ืืคืฉืจื™ื•ืช ื•ืกื™ื›ื•ื ื™ื ืืคืฉืจื™ื™ื ืฉื™ืฆื•ืฆื• ื‘ืžื”ืœืš ืฉื ื•ืช ืžืฉื‘ืจ.

ืคืขื™ืœื•ืช ื‘ื ื™ื™ื” ื‘ื”ืชืื ืœืขื•ื ื” ื‘ืฉื ื”

ืขืœ ื™ื“ื™ ืงื™ื‘ื•ืฅ ื”ื ืชื•ื ื™ื ืœืคื™ ืฉื‘ื•ืขื•ืช ืงืœื ื“ืจื™ื™ื ื‘ืฉื ื” (54 ืฉื‘ื•ืขื•ืช), ื ื™ืชืŸ ืœืฆืคื•ืช ื‘ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื” ื‘ืขื™ืจ ืกืŸ ืคืจื ืกื™ืกืงื• ื‘ื”ืชืื ืœืขื•ื ืชื™ื•ืช ื•ืœื–ืžืŸ ื”ืฉื ื”.

ืขื“ ื—ื’ ื”ืžื•ืœื“, ื›ืœ ืืจื’ื•ื ื™ ื”ื‘ื ื™ื™ื” ืžื ืกื™ื ืœื”ืฉื™ื’ ืื™ืฉื•ืจื™ื ืœืคืจื•ื™ืงื˜ื™ื "ื’ื“ื•ืœื™ื" ื—ื“ืฉื™ื ื‘ื–ืžืŸ. (ื™ื—ื“ ืขื ื–ืืช! ืžืกืคืจ! ื”ื”ื™ืชืจื™ื ื‘ืื•ืชื ื—ื•ื“ืฉื™ื ื”ื•ื ื‘ืื•ืชื” ืจืžื” ืœืื•ืจืš ื›ืœ ื”ืฉื ื”). ืžืฉืงื™ืขื™ื, ื”ืžืชื›ื ื ื™ื ืœืงื‘ืœ ืืช ื ื›ืกื™ื”ื ื‘ืžื”ืœืš ื”ืฉื ื” ื”ืงืจื•ื‘ื”, ื—ื•ื–ื™ื ื‘ื—ื•ื–ื™ื ื‘ื—ื•ื“ืฉื™ ื”ื—ื•ืจืฃ, ื‘ื•ื ื™ื ืขืœ ื”ื ื—ื•ืช ื’ื“ื•ืœื•ืช (ืฉื›ืŸ ื—ื•ื–ื™ ื”ืงื™ืฅ, ืขืœ ืคื™ ืจื•ื‘, ืžืกืชื™ื™ืžื™ื ืขื“ ืกื•ืฃ ื”ืฉื ื” ื•ื—ื‘ืจื•ืช ื”ื‘ื ื™ื™ื” ืžืชืขื ื™ื™ื ื•ืช ื‘ืงื‘ืœืช ืคื ื™ื•ืช ื—ื“ืฉื•ืช).

ืœืคื ื™ ื—ื’ ื”ืžื•ืœื“, ื”ื›ืžื•ื™ื•ืช ื”ื’ื“ื•ืœื•ืช ื‘ื™ื•ืชืจ ืฉืœ ื‘ืงืฉื•ืช ืžื•ื’ืฉื•ืช (ืขืœื™ื™ื” ืžืžืžื•ืฆืข ืฉืœ 1-1,5 ืžื™ืœื™ืืจื“ ื‘ื—ื•ื“ืฉ ืœ-5 ืžื™ืœื™ืืจื“ ื‘ื“ืฆืžื‘ืจ ื‘ืœื‘ื“). ื™ื—ื“ ืขื ื–ืืช, ืžืกืคืจ ื”ื‘ืงืฉื•ืช ื”ื›ื•ืœืœ ืœืคื™ ื—ื•ื“ืฉ ื ืฉืืจ ื‘ืื•ืชื” ืจืžื” (ืจืื” ืกืขื™ืฃ ืœื”ืœืŸ: ื ืชื•ื ื™ื ืกื˜ื˜ื™ืกื˜ื™ื™ื ืขืœ ื”ืžืกืคืจ ื”ื›ื•ืœืœ ืฉืœ ื‘ืงืฉื•ืช ืœืคื™ ื—ื•ื“ืฉ ื•ื™ื•ื)

ืœืื—ืจ ื—ื•ืคืฉืช ื”ื—ื•ืจืฃ, ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ืžืชื›ื ื ื™ื ื•ืžื‘ืฆืขื™ื ื‘ืื•ืคืŸ ืคืขื™ืœ ื”ื–ืžื ื•ืช "ื—ื’ ื”ืžื•ืœื“" (ื›ืžืขื˜ ืœืœื ื’ื™ื“ื•ืœ ื‘ืžืกืคืจ ื”ื”ื™ืชืจื™ื) ืขืœ ืžื ืช ืœืคื ื•ืช ืžืฉืื‘ื™ื ืขื“ ืืžืฆืข ื”ืฉื ื” (ืœืคื ื™ ื—ื•ืคืฉืช ื™ื•ื ื”ืขืฆืžืื•ืช) ืœืคื ื™ ื”ื—ื’ ื”ื—ื“ืฉ. ื’ืœ ื—ื•ื–ื™ ื”ืงื™ืฅ ืžืชื—ื™ืœ ืžื™ื“ ืœืื—ืจ ื—ื•ืคืฉืช ื™ื•ื ื™.

data_month_year = data_month_year.assign(week_year = data_month_year.permit_creation_date.dt.week)
data_month_year = data_month_year.groupby(['week_year'])['estimated_cost'].sum()

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื’ื ืžืื•ืชื ื ืชื•ื ื™ ืื—ื•ื–ื™ื (ืงื• ื›ืชื•ื) ืขื•ืœื” ื›ื™ ื”ืขื ืฃ ืคื•ืขืœ "ื—ืœืง" ืœืื•ืจืš ื›ืœ ื”ืฉื ื”, ืืš ืœืคื ื™ ื•ืื—ืจื™ ื”ื—ื’ื™ื ื”ืคืขื™ืœื•ืช ื‘ื”ื™ืชืจื™ื ืขื•ืœื” ืœ-150% ื‘ืชืงื•ืคื” ืฉื‘ื™ืŸ ืฉื‘ื•ืข 20-24 (ืœืคื ื™ ื™ื•ื ื”ืขืฆืžืื•ืช), ื•ื›ืŸ ื™ื•ืจื“ ืžื™ื“ ืœืื—ืจ ื”ื—ื’ ืขื“ -70%.

ืœืคื ื™ ืœื™ืœ ื›ืœ ื”ืงื“ื•ืฉื™ื ื•ื—ื’ ื”ืžื•ืœื“, ื”ืคืขื™ืœื•ืช ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ืขื•ืœื” ื‘-43% ื‘ืžื”ืœืš ื”ืฉื‘ื•ืข 44-150 (ืžื”ืชื—ืชื™ืช ืœืฉื™ื) ื•ืœืื—ืจ ืžื›ืŸ ื™ื•ืจื“ืช ืœืืคืก ื‘ืžื”ืœืš ื”ื—ื’ื™ื.

ืœืคื™ื›ืš, ื”ืขื ืฃ ื ืžืฆื ื‘ืžื—ื–ื•ืจ ืฉืœ ืฉื™ืฉื” ื—ื•ื“ืฉื™ื, ื”ืžื•ืคืจื“ื™ื ืขืœ ื™ื“ื™ ื”ื—ื’ื™ื "ื™ื•ื ื”ืขืฆืžืื•ืช ืฉืœ ืืจื”"ื‘" (ืฉื‘ื•ืข 20) ื•"ื—ื’ ื”ืžื•ืœื“" (ืฉื‘ื•ืข 52).

ืกืš ื”ื”ืฉืงืขื” ื‘ื ื“ืœ"ืŸ ื‘ืกืŸ ืคืจื ืกื™ืกืงื•

ื‘ื”ืชื‘ืกืก ืขืœ ื ืชื•ื ื™ ื”ื™ืชืจื™ ื‘ื ื™ื™ื” ื‘ืขื™ืจ:

ื”ื”ืฉืงืขื” ื”ื›ื•ืœืœืช ื‘ืคืจื•ื™ืงื˜ื™ ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ืž-1980 ืขื“ 2019 ื”ื™ื 91,5 ืžื™ืœื™ืืจื“ ื“ื•ืœืจ.

sf_worth = data_location_lang_long.cost.sum()

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืฉื•ื•ื™ ื”ืฉื•ืง ื”ื›ื•ืœืœ ืฉืœ ื›ืœ ื”ื ื“ืœ"ืŸ ืœืžื’ื•ืจื™ื ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ื”ืžื•ืขืจืš ืœืคื™ ืžืก ืจื›ื•ืฉ (ื‘ื”ื™ื•ืชื• ื”ืขืจืš ื”ืžื•ืขืจืš ืฉืœ ื›ืœ ื”ื ื“ืœ"ืŸ ื•ื›ืœ ื”ืจื›ื•ืฉ ื”ืื™ืฉื™ ืฉื‘ื‘ืขืœื•ืช ืกืŸ ืคืจื ืกื™ืกืงื•) ื”ื’ื™ืข ืœ-2016 ืžื™ืœื™ืืจื“ ื“ื•ืœืจ ื‘-208.

ื‘ืื™ืœื• ืื–ื•ืจื™ื ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ื”ืฉืงื™ืขื• ื‘ืžื”ืœืš 40 ื”ืฉื ื™ื ื”ืื—ืจื•ื ื•ืช?

ื‘ืืžืฆืขื•ืช ืกืคืจื™ื™ืช Folium, ื‘ื•ืื• ื ืจืื” ื”ื™ื›ืŸ ื”ื•ืฉืงืขื• 91,5 ืžื™ืœื™ืืจื“ ื“ื•ืœืจ ืœืคื™ ืื–ื•ืจ. ืœืฉื ื›ืš, ืœืื—ืจ ืงื™ื‘ื•ืฅ ื”ื ืชื•ื ื™ื ืœืคื™ ืžื™ืงื•ื“, ื ืฆื™ื’ ืืช ื”ืขืจื›ื™ื ื”ืžืชืงื‘ืœื™ื ื‘ืืžืฆืขื•ืช ืขื™ื’ื•ืœื™ื (ืคื•ื ืงืฆื™ื™ืช Circle ืžืกืคืจื™ื™ืช Folium).

import folium
from folium import Circle
from folium import Marker
from folium.features import DivIcon

# map folium display
lat = data_location_lang_long.lat.mean()
long = data_location_lang_long.long.mean()
map1 = folium.Map(location = [lat, long], zoom_start = 12)

for i in range(0,len(data_location_lang_long)):
    Circle(
        location = [data_location_lang_long.iloc[i]['lat'], data_location_lang_long.iloc[i]['long']],
        radius= [data_location_lang_long.iloc[i]['cost']/20000000],
        fill = True, fill_color='#cc0000',color='#cc0000').add_to(map1)
    Marker(
    [data_location_mean.iloc[i]['lat'], data_location_mean.iloc[i]['long']],
    icon=DivIcon(
        icon_size=(6000,3336),
        icon_anchor=(0,0),
        html='<div style="font-size: 14pt; text-shadow: 0 0 10px #fff, 0 0 10px #fff;; color: #000";"">%s</div>'
        %("$ "+ str((data_location_lang_long.iloc[i]['cost']/1000000000).round()) + ' mlrd.'))).add_to(map1)
map1

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื–ื” ื‘ืจื•ืจ ืžื”ืื–ื•ืจื™ื ืจื•ื‘ ื”ืขื•ื’ื” ื”ืœืš ื‘ืื•ืคืŸ ื”ื’ื™ื•ื ื™ ืœื“ืื•ืŸ ื˜ืื•ืŸ. ืœืื—ืจ ืฉืคื™ืฉื˜ ืืช ืงื™ื‘ื•ืฅ ื›ืœ ื”ื—ืคืฆื™ื ืœืคื™ ื”ืžืจื—ืง ืœืžืจื›ื– ื”ืขื™ืจ ื•ื”ื–ืžืŸ ืฉืœื•ืงื— ืœื”ื’ื™ืข ืœืžืจื›ื– ื”ืขื™ืจ (ื›ืžื•ื‘ืŸ ืฉื‘ื•ื ื™ื ื’ื ื‘ืชื™ื ื™ืงืจื™ื ื‘ื—ื•ืฃ), ื›ืœ ื”ื”ื™ืชืจื™ื ื—ื•ืœืงื• ืœ-4 ืงื‘ื•ืฆื•ืช: 'ืžืจื›ื– ื”ืขื™ืจ' , '<0.5H Downtown', '< 1H Downtown', 'Outside SF'.

from geopy.distance import vincenty
def distance_calc (row):
    start = (row['lat'], row['long'])
    stop = (37.7945742, -122.3999445)

    return vincenty(start, stop).meters/1000

df_pr['distance'] = df_pr.apply (lambda row: distance_calc (row),axis=1)

def downtown_proximity(dist):
    '''
    < 2 -> Near Downtown,  >= 2, <4 -> <0.5H Downtown
    >= 4, <6 -> <1H Downtown, >= 8 -> Outside SF
    '''
    if dist < 2:
        return 'Downtown'
    elif dist < 4:
        return  '<0.5H Downtown'
    elif dist < 6:
        return '<1H Downtown'
    elif dist >= 6:
        return 'Outside SF'
df_pr['downtown_proximity'] = df_pr.distance.apply(downtown_proximity)

ืžืชื•ืš 91,5 ืžื™ืœื™ืืจื“ ื”ืžื•ืฉืงืขื™ื ื‘ืขื™ืจ, ื›ืžืขื˜ 70 ืžื™ืœื™ืืจื“ (75% ืžื›ืœืœ ื”ื”ืฉืงืขื•ืช) ืฉื”ื•ืฉืงืขื• ื‘ืชื™ืงื•ื ื™ื ื•ื‘ื‘ื ื™ื™ื” ื ืžืฆืื™ื ื‘ืžืจื›ื– ื”ืขื™ืจ. (ืื–ื•ืจ ื™ืจื•ืง) ื•ืœืื–ื•ืจ ื”ืขื™ืจ ื‘ืจื“ื™ื•ืก ืฉืœ 2 ืง"ืž. ืžื”ืžืจื›ื– (ืื–ื•ืจ ื›ื—ื•ืœ).

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืขืœื•ืช ืžืฉื•ืขืจืช ืžืžื•ืฆืขืช ืฉืœ ื‘ืงืฉืช ื‘ื ื™ื™ื” ืœืคื™ ืžื—ื•ื– ืขื™ืจ

ื›ืœ ื”ื ืชื•ื ื™ื, ื›ืžื• ื‘ืกื›ื•ื ื”ื”ืฉืงืขื” ื”ื›ื•ืœืœ, ืงื•ื‘ืฆื• ืœืคื™ ืžื™ืงื•ื“. ืจืง ื‘ืžืงืจื” ื–ื” ืขื ื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื”ืžืžื•ืฆืขืช (.mean()) ืฉืœ ื”ื™ื™ืฉื•ื ืœืคื™ ืžื™ืงื•ื“.

data_location_mean = data_location.groupby(['zipcode'])['lat','long','estimated_cost'].mean()

ื‘ืื–ื•ืจื™ื ืจื’ื™ืœื™ื ื‘ืขื™ืจ (ื™ื•ืชืจ ืž-2 ืง"ืž ืžืžืจื›ื– ื”ืขื™ืจ) - ื”ืขืœื•ืช ื”ืžื•ืขืจื›ืช ื”ืžืžื•ืฆืขืช ืฉืœ ื‘ืงืฉืช ื‘ื ื™ื™ื” ื”ื™ื 50 ืืœืฃ ื“ื•ืœืจ.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื”ืžืžื•ืฆืขืช ื‘ืื–ื•ืจ ืžืจื›ื– ื”ืขื™ืจ ื’ื‘ื•ื”ื” ืคื™ ืฉืœื•ืฉื” ื‘ืขืจืš (150 ืขื“ 400 ืืœืฃ ื“ื•ืœืจ) ืžืืฉืจ ื‘ืชื—ื•ืžื™ื ืื—ืจื™ื (30-50 ืืœืฃ ื“ื•ืœืจ).

ื‘ื ื•ืกืฃ ืœืขืœื•ืช ื”ืงืจืงืข, ืฉืœื•ืฉื” ื’ื•ืจืžื™ื ืงื•ื‘ืขื™ื ืืช ื”ืขืœื•ืช ื”ื›ื•ืœืœืช ืฉืœ ื‘ื ื™ื™ืช ื”ื‘ื™ืช: ืขื‘ื•ื“ื”, ื—ื•ืžืจื™ื ื•ืื’ืจื•ืช ืžืžืฉืœืชื™ื•ืช. ืฉืœื•ืฉืช ื”ืžืจื›ื™ื‘ื™ื ื”ืœืœื• ื’ื‘ื•ื”ื™ื ื™ื•ืชืจ ื‘ืงืœื™ืคื•ืจื ื™ื” ืžืืฉืจ ื‘ืฉืืจ ื”ืžื“ื™ื ื”. ื—ื•ืงื™ ื”ื‘ื ื™ื™ื” ืฉืœ ืงืœื™ืคื•ืจื ื™ื” ื ื—ืฉื‘ื™ื ืœื›ืžื” ืžื”ืžืงื™ืคื™ื ื•ื”ืžื—ืžื™ืจื™ื ื‘ื™ื•ืชืจ ื‘ืžื“ื™ื ื” (ื‘ืฉืœ ืจืขื™ื“ืช ืื“ืžื” ื•ืชืงื ื•ืช ืกื‘ื™ื‘ืชื™ื•ืช), ื”ืžืฆืจื™ื›ื™ื ืœืจื•ื‘ ื—ื•ืžืจื™ื ื•ืขื‘ื•ื“ื” ื™ืงืจื™ื ื™ื•ืชืจ.

ืœื“ื•ื’ืžื”, ื”ืžืžืฉืœื” ื“ื•ืจืฉืช ืžื‘ื•ื ื™ื ืœื”ืฉืชืžืฉ ื‘ื—ื•ืžืจื™ ื‘ื ื™ื™ืŸ ืื™ื›ื•ืชื™ื™ื ื™ื•ืชืจ (ื—ืœื•ื ื•ืช, ื‘ื™ื“ื•ื“, ืžืขืจื›ื•ืช ื—ื™ืžื•ื ื•ืงื™ืจื•ืจ) ื›ื“ื™ ืœื”ืฉื™ื’ ืชืงื ื™ ื™ืขื™ืœื•ืช ืื ืจื’ื˜ื™ืช ื’ื‘ื•ื”ื™ื.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืžื”ืกื˜ื˜ื™ืกื˜ื™ืงื” ื”ื›ืœืœื™ืช ืขืœ ื”ืขืœื•ืช ื”ืžืžื•ืฆืขืช ืฉืœ ื‘ืงืฉืช ื”ื™ืชืจ, ื‘ื•ืœื˜ื™ื ืฉื ื™ ืžื™ืงื•ืžื™ื:

  • ืื™ ื”ืžื˜ืžื•ืŸ - ืื™ ืžืœืื›ื•ืชื™ ื‘ืžืคืจืฅ ืกืŸ ืคืจื ืกื™ืกืงื•. ื”ืขืœื•ืช ื”ืžืžื•ืฆืขืช ื”ืžื•ืขืจื›ืช ืฉืœ ื”ื™ืชืจ ื‘ื ื™ื™ื” ื”ื™ื 6,5 ืžื™ืœื™ื•ืŸ ื“ื•ืœืจ.
  • ืžืคืจืฅ ืžื™ืกื™ื•ืŸ โ€” (ืื•ื›ืœื•ืกื™ื™ื” 2926) ื”ืขืœื•ืช ื”ืžืžื•ืฆืขืช ื”ืžื•ืขืจื›ืช ืฉืœ ื”ื™ืชืจ ื‘ื ื™ื™ื” ื”ื™ื 1,5 ืžื™ืœื™ื•ืŸ ื“ื•ืœืจ.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืœืžืขืฉื”, ื”ื™ื™ืฉื•ื ื”ืžืžื•ืฆืข ื”ื’ื‘ื•ื” ื‘ืฉื ื™ ื”ืชื—ื•ืžื™ื ื”ืœืœื• ืงืฉื•ืจ ืขื ื”ืžืกืคืจ ื”ื ืžื•ืš ื‘ื™ื•ืชืจ ืฉืœ ื‘ืงืฉื•ืช ืขื‘ื•ืจ ืžื™ืงื•ืžื™ ื“ื•ืืจ ืืœื” (145 ื•-3064 ื‘ื”ืชืืžื”, ื”ื‘ื ื™ื™ื” ื‘ืื™ ืžื•ื’ื‘ืœืช ืžืื•ื“), ื‘ืขื•ื“ ืฉืœืฉืืจ ื”ืžื™ืงื•ื“ื™ื - XNUMXื•ื‘ืชืงื•ืคื” 1980-2019 ื”ืชืงื‘ืœื• ื›-1300 ื‘ืงืฉื•ืช ื‘ืฉื ื” (ืกื”"ื› ื‘ืžืžื•ืฆืข 30 -50 ืืœืฃ ืคื ื™ื•ืช ืœื›ืœ ื”ืชืงื•ืคื”).

ืขืœ ืคื™ ืคืจืžื˜ืจ "ืžืกืคืจ ืคื ื™ื•ืช", ื ื™ื›ืจืช ื”ืชืคืœื’ื•ืช ืฉื•ื•ื” ืœื—ืœื•ื˜ื™ืŸ ืฉืœ ืžืกืคืจ ื”ื‘ืงืฉื•ืช ืœื›ืœ ืžื™ืงื•ื“ ื‘ืจื—ื‘ื™ ื”ืขื™ืจ.

ืกื˜ื˜ื™ืกื˜ื™ืงื” ืขืœ ื”ืžืกืคืจ ื”ื›ื•ืœืœ ืฉืœ ื‘ืงืฉื•ืช ืœืคื™ ื—ื•ื“ืฉ ื•ื™ื•ื

ื ืชื•ื ื™ื ืกื˜ื˜ื™ืกื˜ื™ื™ื ื›ื•ืœืœื™ื ืขืœ ื”ืžืกืคืจ ื”ื›ื•ืœืœ ืฉืœ ื‘ืงืฉื•ืช ืœืคื™ ื—ื•ื“ืฉ ื•ื™ื•ื ื‘ืฉื‘ื•ืข ื‘ื™ืŸ 1980 ืœ-2019 ืžืจืื™ื ื›ื™ ื”ื—ื•ื“ืฉื™ื ื”ืฉืงื˜ื™ื ื‘ื™ื•ืชืจ ืขื‘ื•ืจ ืžื—ืœืงืช ื”ื‘ื ื™ื™ื” ื”ื ื—ื•ื“ืฉื™ ื”ืื‘ื™ื‘ ื•ื”ื—ื•ืจืฃ. ื™ื—ื“ ืขื ื–ืืช, ื›ืžื•ืช ื”ื”ืฉืงืขื•ืช ื”ืžืฆื•ื™ื ืช ื‘ื‘ืงืฉื•ืช ืžืฉืชื ื” ืžืื•ื“ ื•ืฉื•ื ื” ืžื—ื•ื“ืฉ ืœื—ื•ื“ืฉ ืœืขื™ืชื™ื. (ืจืื” ื‘ื ื•ืกืฃ "ืคืขื™ืœื•ืช ื‘ื ื™ื™ื” ื‘ื”ืชืื ืœืขื•ื ื”"). ื‘ื™ืŸ ื™ืžื•ืช ื”ืฉื‘ื•ืข, ื‘ื™ื•ื ืฉื ื™ ื”ืขื•ืžืก ืขืœ ื”ืžื—ืœืงื” ืงื˜ืŸ ื‘ื›-20% ืžืืฉืจ ื‘ืฉืืจ ื™ืžื•ืช ื”ืฉื‘ื•ืข.

months = [ 'January', 'February', 'March', 'April', 'May','June', 'July', 'August', 'September', 'October', 'November', 'December' ]
data_month_count  = data_month.groupby(['permit_creation_date']).count().reindex(months) 

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื‘ืขื•ื“ ื™ื•ื ื™ ื•ื™ื•ืœื™ ื”ื ื›ืžืขื˜ ื–ื”ื™ื ืžื‘ื—ื™ื ืช ืžืกืคืจ ื”ื‘ืงืฉื•ืช, ืžื‘ื—ื™ื ืช ื”ืขืœื•ืช ื”ืžืฉื•ืขืจืช ื”ื›ื•ืœืœืช ื”ื”ืคืจืฉ ืžื’ื™ืข ืœ-100% (4,3 ืžื™ืœื™ืืจื“ ื‘ืžืื™ ื•ื™ื•ืœื™ ื•-8,2 ืžื™ืœื™ืืจื“ ื‘ื™ื•ื ื™).

data_month_sum  = data_month.groupby(['permit_creation_date']).sum().reindex(months) 

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื”ืขืชื™ื“ ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•, ื—ื™ื–ื•ื™ ืคืขื™ืœื•ืช ืœืคื™ ื“ืคื•ืกื™ื.

ืœื‘ืกื•ืฃ, ื ืฉื•ื•ื” ืืช ื˜ื‘ืœืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ืขื ื˜ื‘ืœืช ืžื—ื™ืจื™ ื”ื‘ื™ื˜ืงื•ื™ืŸ (2015-2018) ื•ื˜ื‘ืœืช ืžื—ื™ืจื™ ื”ื–ื”ื‘ (1940 - 1980).

ืชื‘ื ื™ืช (ืžื”ืชื‘ื ื™ืช ื”ืื ื’ืœื™ืช - ืžื•ื“ืœ, ืžื“ื’ื) - ื‘ื ื™ืชื•ื— ื˜ื›ื ื™ ื ืงืจืื™ื ืฉื™ืœื•ื‘ื™ื ื—ื•ื–ืจื™ื ื™ืฆื™ื‘ื™ื ืฉืœ ืžื—ื™ืจ, ื ืคื— ืื• ื ืชื•ื ื™ ืื™ื ื“ื™ืงื˜ื•ืจ. ื ื™ืชื•ื— ื“ืคื•ืกื™ื ืžื‘ื•ืกืก ืขืœ ืื—ืช ื”ืืงืกื™ื•ืžื•ืช ืฉืœ ื ื™ืชื•ื— ื˜ื›ื ื™: "ื”ื”ื™ืกื˜ื•ืจื™ื” ื—ื•ื–ืจืช ืขืœ ืขืฆืžื”" - ืžืืžื™ื ื™ื ืฉืฉื™ืœื•ื‘ื™ื ื—ื•ื–ืจื™ื ืฉืœ ื ืชื•ื ื™ื ืžื•ื‘ื™ืœื™ื ืœืชื•ืฆืื” ื“ื•ืžื”.

ื”ื“ืคื•ืก ื”ืขื™ืงืจื™ ืฉื ื™ืชืŸ ืœืจืื•ืช ื‘ื˜ื‘ืœืช ื”ืคืขื™ืœื•ืช ื”ืฉื ืชื™ืช ื”ื•ื ื–ื”ื• ื“ืคื•ืก ื”ื™ืคื•ืš ืžื’ืžื” ืฉืœ "ืจืืฉ ื•ื›ืชืคื™ื™ื". ื ืงืจื ื›ืš ืžื›ื™ื•ื•ืŸ ืฉื”ืชืจืฉื™ื ื ืจืื” ื›ืžื• ืจืืฉ ืื ื•ืฉื™ (ืฉื™ื) ื•ื›ืชืคื™ื™ื ื‘ืฆื“ื“ื™ื (ืคืกื’ื•ืช ืคื—ื•ืชื•ืช). ื›ืืฉืจ ื”ืžื—ื™ืจ ืฉื•ื‘ืจ ืืช ื”ืงื• ื”ืžื—ื‘ืจ ืืช ื”ืฉื•ืงืชื•ืช, ื”ื“ืคื•ืก ื ื—ืฉื‘ ืฉืœื ื•ืกื‘ื™ืจ ืฉื”ืชื ื•ืขื” ืชื”ื™ื” ื›ืœืคื™ ืžื˜ื”.

ืชื ื•ืขื•ืช ื”ืคืขื™ืœื•ืช ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ื—ื•ืคืคื•ืช ื›ืžืขื˜ ืœื—ืœื•ื˜ื™ืŸ ืœืขืœื™ื™ื” ื‘ืžื—ื™ืจื™ ื”ื–ื”ื‘ ื•ื”ื‘ื™ื˜ืงื•ื™ืŸ. ื”ื‘ื™ืฆื•ืขื™ื ื”ื”ื™ืกื˜ื•ืจื™ื™ื ืฉืœ ืฉืœื•ืฉืช ืชืจืฉื™ืžื™ ื”ืžื—ื™ืจื™ื ื•ื”ืคืขื™ืœื•ืช ื”ืœืœื• ืžืจืื™ื ืงื•ื•ื™ ื“ืžื™ื•ืŸ ื‘ื•ืœื˜ื™ื.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื›ื“ื™ ืœื”ื™ื•ืช ืžืกื•ื’ืœ ืœื—ื–ื•ืช ืืช ื”ืชื ื”ื’ื•ืช ืฉื•ืง ื”ื‘ื ื™ื™ื” ื‘ืขืชื™ื“, ื™ืฉ ืฆื•ืจืš ืœื—ืฉื‘ ืืช ืžืงื“ื ื”ืžืชืื ืขื ื›ืœ ืื—ืช ืžืฉืชื™ ื”ืžื’ืžื•ืช ื”ืœืœื•.

ืฉื ื™ ืžืฉืชื ื™ื ืืงืจืื™ื™ื ื ืงืจืื™ื ืžืชื•ืืžื™ื ืื ืžื•ืžื ื˜ ื”ืžืชืื (ืื• ืžืงื“ื ื”ืžืชืื) ืฉืœื”ื ืฉื•ื ื” ืžืืคืก; ื•ื ืงืจืื™ื ื›ืžื•ื™ื•ืช ืœื ืžืชื•ืืžื•ืช ืื ืžื•ืžื ื˜ ื”ืžืชืื ืฉืœื”ืŸ ื”ื•ื ืืคืก.

ืื ื”ืขืจืš ื”ืžืชืงื‘ืœ ืงืจื•ื‘ ื™ื•ืชืจ ืœ-0 ืžืืฉืจ ืœ-1, ืื– ืื™ืŸ ื˜ืขื ืœื“ื‘ืจ ืขืœ ื“ืคื•ืก ื‘ืจื•ืจ. ื–ื•ื”ื™ ื‘ืขื™ื” ืžืชืžื˜ื™ืช ืžื•ืจื›ื‘ืช, ืฉืขืฉื•ื™ื” ืœื”ื™ืœืงื— ืขืœ ื™ื“ื™ ื—ื‘ืจื™ื ืžื‘ื•ื’ืจื™ื ืฉืขืฉื•ื™ื™ื ืœื”ืชืขื ื™ื™ืŸ ื‘ื ื•ืฉื ื–ื”.

ืื! ืœื ืžื“ืขื™! ืชืกืชื›ืœ ืขืœ ื ื•ืฉื ื”ืžืฉืš ื”ืคื™ืชื•ื— ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•: ืื ื”ื“ืคื•ืก ื™ืžืฉื™ืš ืœื—ืคื•ืฃ ืœืžื—ื™ืจ ื”ื‘ื™ื˜ืงื•ื™ืŸ, ืื– ืœืคื™ ื”ืื•ืคืฆื™ื” ื”ืคืกื™ืžื™ืช ื”ื–ื• - ืœืฆืืช ืžื”ืžืฉื‘ืจ ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ืœื ื™ื”ื™ื” ืงืœ ื‘ืชืงื•ืคื” ื”ืžื™ื™ื“ื™ืช ืฉืœืื—ืจ ื”ืžืฉื‘ืจ.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ืขื ืืคืฉืจื•ืช "ืื•ืคื˜ื™ืžื™ืช" ื™ื•ืชืจ ืคื™ืชื•ื—, ืฆืžื™ื—ื” ืืงืกืคื•ื ื ืฆื™ืืœื™ืช ื—ื•ื–ืจืช ื•ื ืฉื ื™ืช ื‘ืขื ืฃ ื”ื‘ื ื™ื™ื” ืืคืฉืจื™ืช ืื ื”ืคืขื™ืœื•ืช ื›ืืŸ ืขื•ืงื‘ืช ืื—ืจ ืชืจื—ื™ืฉ "ืžื—ื™ืจ ื”ื–ื”ื‘". ื‘ืžืงืจื” ื–ื”, ื‘ืขื•ื“ 20-30 ืฉื ื” (ื™ื™ืชื›ืŸ ื‘ืขื•ื“ 10), ืชื—ื•ื ื”ื‘ื ื™ื™ื” ื™ืขืžื•ื“ ื‘ืคื ื™ ื’ืœ ื—ื“ืฉ ื‘ืชืขืกื•ืงื” ื•ื‘ืคื™ืชื•ื—.

ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ืชืคืชื—ื•ืช ืคืขื™ืœื•ืช ื”ื‘ื ื™ื™ื”

ื‘ื—ืœืง ื”ื‘ื ืื ื™ ืืกืชื›ืœ ืžืงืจื•ื‘ ืขืœ ืžื’ื–ืจื™ ื‘ื ื™ื™ื” ื‘ื•ื“ื“ื™ื (ืชื™ืงื•ืŸ ื’ื’ื•ืช, ืžื˜ื‘ื—ื™ื, ื‘ื ื™ื™ืช ืžื“ืจื’ื•ืช, ื—ื“ืจื™ ืืžื‘ื˜ื™ื”, ืื ื™ืฉ ืœืš ื”ืฆืขื•ืช ืขืœ ืชืขืฉื™ื•ืช ืื• ื ืชื•ื ื™ื ืื—ืจื™ื - ื ื ืœื›ืชื•ื‘ ื‘ืชื’ื•ื‘ื•ืช) ื•ืœื”ืฉื•ื•ืช ืื™ื ืคืœืฆื™ื” ืขื‘ื•ืจ ืกื•ื’ื™ื ื‘ื•ื“ื“ื™ื ืฉืœ ืขื‘ื•ื“ื” ืขื ืจื™ื‘ื™ืช ืงื‘ื•ืขื” ืขืœ ื”ืœื•ื•ืื•ืช ืžืฉื›ื ืชื ื•ื”ืจื•ื•ื—ื™ื•ืช ืฉืœ ืื™ื’ืจื•ืช ื—ื•ื‘ ืžืžืฉืœืชื™ื•ืช ื‘ืืจื”"ื‘ (Fixed Mortgage Rates & US Treasury Yield).

ืงื™ืฉื•ืจ ืœื—ืœืง ื”ืฉื ื™:
ืžื’ื–ืจื™ ื‘ื ื™ื™ื” ื”ื™ื™ืค ื•ืขืœื•ืช ื”ืขื‘ื•ื“ื” ื‘ืขื™ืจ ื”ื’ื“ื•ืœื”. ืื™ื ืคืœืฆื™ื” ื•ืฆืžื™ื—ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•

ืงื™ืฉื•ืจ ืœืžื—ื‘ืจืช Jupyter: ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ื–ืจ ื”ื‘ื ื™ื™ืŸ 1980-2019.
ื‘ื‘ืงืฉื”, ืœืžื™ ืฉื ืžืฆื ืขื Kaggle, ืชืŸ ืคืœื•ืก ืœ-Notebook (ืชื•ื“ื”!).
(ื”ืขืจื•ืช ื•ื”ืกื‘ืจื™ื ืขืœ ื”ืงื•ื“ ื™ืชื•ื•ืกืคื• ื‘ื”ืžืฉืš ื‘-Notebook)

ืงื™ืฉื•ืจ ืœื’ืจืกื” ื‘ืื ื’ืœื™ืช: ื”ืขืœื™ื•ืช ื•ื”ืžื•ืจื“ื•ืช ืฉืœ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ื‘ืกืŸ ืคืจื ืกื™ืกืงื•. ืžื’ืžื•ืช ื•ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ื”ื‘ื ื™ื™ื”.

ืื ืืชื” ื ื”ื ื” ืžื”ืชื•ื›ืŸ ืฉืœื™, ื‘ื‘ืงืฉื” ืฉืงื•ืœ ืœืงื ื•ืช ืœื™ ืงืคื”.
ืชื•ื“ื” ืขืœ ื”ืชืžื™ื›ื” ืฉืœืš! ืงื ื” ืงืคื” ืœืžื—ื‘ืจ

ืจืง ืžืฉืชืžืฉื™ื ืจืฉื•ืžื™ื ื™ื›ื•ืœื™ื ืœื”ืฉืชืชืฃ ื‘ืกืงืจ. ืœื”ืชื—ื‘ืจื‘ื‘ืงืฉื”.

ืžื” ืฆื•ืคืŸ ื”ืขืชื™ื“ ืขื‘ื•ืจ ืชืขืฉื™ื™ืช ื”ื‘ื ื™ื™ื” ืฉืœ ืกืŸ ืคืจื ืกื™ืกืงื•?

  • 66,7%ืกื‘ื™ืจ ื™ื•ืชืจ ืฉืžื’ื–ืจ ื”ื‘ื ื™ื™ื” ื™ืœืš ื‘ื ืชื™ื‘ ืฉืœ Bitcoin2

  • 0,0%ืžื’ื–ืจ ื”ื‘ื ื™ื™ื” ืขืฉื•ื™ ืœืœื›ืช ื‘ื“ืจืš ืฉืœ ืžื—ื™ืจื™ ื”ื–ื”ื‘0

  • 0,0%ื”ืžื’ื–ืจ ืžืฆืคื” ืœื”ื™ื™ืค ื‘ืžื”ืœืš 10 ื”ืฉื ื™ื ื”ื‘ืื•ืช

  • 33,3%ื”ืชืคืชื—ื•ืช ื”ืžื’ื–ืจ ืœื ืžืชื ื”ืœืช ืœืคื™ ื“ืคื•ืกื™ื1

3 ืžืฉืชืžืฉื™ื ื”ืฆื‘ื™ืขื•. 6 ืžืฉืชืžืฉื™ื ื ืžื ืขื•.

ืžืงื•ืจ: www.habr.com

ื”ื•ืกืคืช ืชื’ื•ื‘ื”