{"id":30561,"date":"2023-04-18T22:22:46","date_gmt":"2023-04-18T17:52:46","guid":{"rendered":"https:\/\/wpadmin.maktabkhooneh.org\/mag\/?p=30561"},"modified":"2026-02-17T18:14:14","modified_gmt":"2026-02-17T14:44:14","slug":"dataframe-in-python","status":"publish","type":"post","link":"https:\/\/maktabkhooneh.org\/mag\/dataframe-in-python\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647"},"content":{"rendered":"\n<p>Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 (dataframe python) \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0645\u062d\u0628\u0648\u0628 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0637\u0648\u0631 \u06af\u0633\u062a\u0631\u062f\u0647 \u062f\u0631 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0648\u0638\u0627\u06cc\u0641 \u0639\u0644\u0645 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0622\u0646\u200c\u0647\u0627 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u0648\u0644\u06cc \u062f\u0648\u0628\u0639\u062f\u06cc \u0647\u0633\u062a\u0646\u062f\u060c \u0634\u0628\u06cc\u0647 \u0628\u0647 \u0635\u0641\u062d\u0627\u062a \u06af\u0633\u062a\u0631\u062f\u0647 \u06cc\u0627 \u062c\u062f\u0627\u0648\u0644 SQL\u060c \u0628\u0627 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0630\u062e\u06cc\u0631\u0647 \u0648 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u062c\u0627\u0645\u0639 \u0627\u0632 \u0645\u06a9\u062a\u0648\u0628\u060c \u0647\u0645\u0647\u200c\u0686\u06cc\u0632\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u062f\u0631 \u0645\u0648\u0631\u062f \u062f\u06cc\u062a\u0627 \u0641\u0631\u06cc\u0645 \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u062f\u0627\u0646\u06cc\u062f\u060c \u0627\u0632 \u062f\u0631\u06a9 \u0645\u0641\u0627\u0647\u06cc\u0645 \u0627\u0648\u0644\u06cc\u0647 \u0622\u0646\u200c\u0647\u0627 \u062a\u0627 \u0627\u0646\u062c\u0627\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0631\u0627 \u067e\u0648\u0634\u0634 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f. \u0628\u0631\u0627\u06cc \u06a9\u0633\u0628 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0628\u0637\u0647 \u062a\u0627 \u067e\u0627\u06cc\u0627\u0646 \u0627\u06cc\u0646 \u0646\u0648\u0634\u062a\u0647 \u0627\u0632 \u062f\u0633\u062a\u0647 <a href=\"https:\/\/maktabkhooneh.org\/learn\/python\/\">\u0622\u0645\u0648\u0632\u0634 \u067e\u0627\u06cc\u062a\u0648\u0646<\/a> \u0628\u0627 \u0645\u0627 \u0647\u0645\u0631\u0627\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0686\u06cc\u0633\u062a\u061f<\/h2>\n\n\n\n<p>\u062f\u06cc\u062a\u0627 \u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0646\u0648\u0639\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u062f\u0648\u0628\u0639\u062f\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u062c\u062f\u0648\u0644\u06cc\u060c \u0628\u0627 \u0633\u0637\u0631\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u062f\u0631 \u0648\u0627\u0642\u0639 \u0627\u0628\u0632\u0627\u0631\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0633\u062a \u06a9\u0647 \u0631\u0648\u0634\u06cc \u0645\u0646\u0639\u0637\u0641 \u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/Python-Jadi-2_1403-12-13-113008363\/3b93e9d629dc333cc648387a996d35db.webp?expire=4893471932&#038;token=94fb7de009a85c6b8a27e6bce14262e9&#038;md5=lPt94AmoXGuKJ-a84UJi6Q==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u067e\u0627\u06cc\u062a\u0648\u0646 \u062c\u0627\u0645\u0639\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u067e\u0627\u06cc\u062a\u0648\u0646 \u062c\u0627\u0645\u0639\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D9%86%D9%88%DB%8C%D8%B3%DB%8C-%D8%A8%D8%A7-%D9%BE%D8%A7%DB%8C%D8%AA%D9%88%D9%86-%D9%85%D9%82%D8%AF%D9%85%D8%A7%D8%AA%DB%8C-mk346\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u067e\u0627\u06cc\u062a\u0648\u0646 \u062c\u0627\u0645\u0639        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f2,\u06f5\u06f9\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f1,\u06f2\u06f9\u06f9,\u06f5\u06f0\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f5\u06f0%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D9%86%D9%88%DB%8C%D8%B3%DB%8C-%D8%A8%D8%A7-%D9%BE%D8%A7%DB%8C%D8%AA%D9%88%D9%86-%D9%85%D9%82%D8%AF%D9%85%D8%A7%D8%AA%DB%8C-mk346\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p>Dataframe \u0647\u0627 \u0628\u062e\u0634\u06cc \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u067e\u0627\u0646\u062f\u0627\u0633 (python pandas dataframe) \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628\u200c\u062a\u0631\u06cc\u0646 <a href=\"https:\/\/maktabkhooneh.org\/mag\/python-libraries\/\">\u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646<\/a> \u0645\u062d\u0633\u0648\u0628 \u0645\u06cc\u200c\u0634\u0648\u062f. Pandas \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u063a\u0646\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0648 \u0645\u062a\u062f\u0647\u0627 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0622\u0633\u0627\u0646 \u06a9\u0631\u062f\u0647 \u0648 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0647\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u062a\u0628\u062f\u06cc\u0644 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0627\u06cc\u062c\u0627\u062f Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646<\/h3>\n\n\n\n<p>\u0631\u0627\u0647\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062f\u06cc\u062a\u0627 \u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0627\u0632 \u0645\u0637\u0644\u0628 \u0628\u0647 \u0630\u06a9\u0631 \u0622\u0646\u200c\u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0639\u0645\u0644\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u067e\u0631\u062f\u0627\u062e\u062a.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0627\u06cc\u062c\u0627\u062f Dataframe \u0627\u0632 \u062f\u06cc\u06a9\u0634\u0646\u0631\u06cc<\/h3>\n\n\n\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 ()pd.DataFrame \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 pandas \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0627\u0632 \u062f\u06cc\u06a9\u0634\u0646\u0631\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645. \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062f\u06cc\u06a9\u0634\u0646\u0631\u06cc \u0646\u0634\u0627\u0646 \u062f\u0647\u0646\u062f\u0647 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0646\u0634\u0627\u0646 \u062f\u0647\u0646\u062f\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0647\u0633\u062a\u0646\u062f. \u0645\u062b\u0627\u0644 \u0632\u06cc\u0631 \u0628\u0631\u0627\u06cc \u0628\u06cc\u0627\u0646 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd\n\n<span class=\"token comment\"># Create a dictionary with data<\/span>\ndata <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token string\">'\u0646\u0627\u0645'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'\u0639\u0644\u06cc'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'\u0627\u0645\u06cc\u0631'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'\u06a9\u0648\u0631\u0648\u0634'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string\">'\u0633\u0646'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">&#91;<\/span><span class=\"token number\">\u06f2\u06f5<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">\u06f3\u06f0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">\u06f3\u06f5<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string\">'\u0634\u0647\u0631'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'\u062a\u0647\u0631\u0627\u0646'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'\u0627\u0635\u0641\u0647\u0627\u0646'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'\u0634\u06cc\u0631\u0627\u0632'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span>\n\n<span class=\"token comment\"># Create a dataframe from the dictionary<\/span>\ndf <span class=\"token operator\">=<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Display the dataframe<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">)<\/span><\/code><\/pre>\n\n\n\n<p>\u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u0642\u0637\u0639\u0647 \u06a9\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" width=\"700\" height=\"246\" src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame4.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646\" class=\"wp-image-30563\" title=\"\" srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame4.png 700w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/data-frame4-300x105.png.webp 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u0627\u06cc\u062c\u0627\u062f Dataframe \u0627\u0632 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV<\/h3>\n\n\n\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 ()pd.read_csv \u0627\u0632 \u067e\u0627\u0646\u062f\u0627\u0633 (pandas df)\u060c \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0627\u0632 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV (\u0645\u0642\u0627\u062f\u06cc\u0631 \u062c\u062f\u0627 \u0634\u062f\u0647 \u0628\u0627 \u06a9\u0627\u0645\u0627) \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645. \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc CSV \u06cc\u06a9 \u0641\u0631\u0645\u062a \u0631\u0627\u06cc\u062c \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0647\u0633\u062a\u0646\u062f \u0648 \u067e\u0627\u0646\u062f\u0627\u0647\u0627 \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0622\u0633\u0627\u0646 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u062b\u0627\u0644\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0647\u062f\u0641 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd\n\n<span class=\"token comment\"># Read data from a CSV file<\/span>\ndf <span class=\"token operator\">=<\/span> pd<span class=\"token punctuation\">.<\/span>read_csv<span class=\"token punctuation\">(<\/span><span class=\"token string\">'data.csv'<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Display the dataframe<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">)<\/span><\/code><\/pre>\n\n\n\n<p>\u062e\u0631\u0648\u062c\u06cc \u0645\u0627\u0646\u0646\u062f \u062e\u0631\u0648\u062c\u06cc \u0628\u0627\u0644\u0627 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u0648\u0644\u06cc \u0627\u06cc\u0646 \u0628\u0627\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u0641\u0627\u06cc\u0644 CSV \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0627\u06cc\u062c\u0627\u062f Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0632 \u0633\u0627\u06cc\u0631 \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647<\/h3>\n\n\n\n<p>Pandas \u0686\u0646\u062f\u06cc\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u062f\u06cc\u06af\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647 \u062f\u06cc\u06af\u0631 (pandas series)\u060c \u0645\u0627\u0646\u0646\u062f \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc Excel\u060c \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc JSON\u060c \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 SQL \u0648 \u0645\u0648\u0627\u0631\u062f \u062f\u06cc\u06af\u0631 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u067e\u0627\u0646\u062f\u0627\u0647\u0627 \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f \u0648\u0644\u06cc \u062f\u0631 \u06a9\u0644 \u0631\u0648\u0627\u0644 \u06a9\u0627\u0631 \u0645\u0634\u0627\u0628\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0639\u0645\u0644\u06cc\u0627\u062a Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646<\/h2>\n\n\n\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a \u0645\u062e\u062a\u0644\u0641\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0648\u06cc \u0622\u0646 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0627\u06cc\u0647 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0622\u0646\u200c\u0647\u0627 \u0622\u0634\u0646\u0627 \u0628\u0627\u0634\u06cc\u062f:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0645\u0634\u0627\u0647\u062f\u0647 \u062f\u0627\u062f\u0647\u200c \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646<\/h3>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>head()\u200e: \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u0627\u0648\u0644 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n\n\n\n<li>tail()\u200e: \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u0622\u062e\u0631 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n\n\n\n<li>info()\u200e: \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645\u060c \u0645\u0627\u0646\u0646\u062f \u062a\u0639\u062f\u0627\u062f \u0633\u0637\u0631\u0647\u0627\u060c \u062a\u0639\u062f\u0627\u062f \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u060c \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0645\u06cc\u0632\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062d\u0627\u0641\u0638\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/li>\n\n\n\n<li>describe()\u200e: \u0622\u0645\u0627\u0631 \u062a\u0648\u0635\u06cc\u0641\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 dataframe \u0645\u0627\u0646\u0646\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u060c \u0627\u0646\u062d\u0631\u0627\u0641 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f\u060c \u062d\u062f\u0627\u0642\u0644\u060c \u062d\u062f\u0627\u06a9\u062b\u0631 \u0648 \u063a\u06cc\u0631\u0647 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/li>\n\n\n\n<li>()shape: \u062a\u0639\u062f\u0627\u062f \u0633\u0637\u0631\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u062f\u0627\u062f\u0647\u200c \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646<\/h3>\n\n\n\n<p>\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0646\u0645\u0627\u06cc\u0647\u200c\u0633\u0627\u0632\u06cc (\u0627\u06cc\u0646\u062f\u06a9\u0633\u06cc\u0646\u06af \u06cc\u0627 \u0627\u0646\u062f\u06cc\u0633 \u06af\u0630\u0627\u0631\u06cc) \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0627\u0646\u062f\u06cc\u0633 \u06af\u0630\u0627\u0631\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646: \u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0647 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u062e\u0627\u0635 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0646\u0627\u0645 \u0622\u0646 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645: df[&#8216;column_name&#8217;].<\/li>\n\n\n\n<li>\u0627\u0646\u062f\u06cc\u0633 \u06af\u0630\u0627\u0631\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u0637\u0631 \u0648 \u0628\u0631\u0686\u0633\u0628 \u0633\u062a\u0648\u0646: \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0628\u0631\u0686\u0633\u0628\u200c\u0647\u0627\u06cc \u0633\u0637\u0631 \u0648 \u0633\u062a\u0648\u0646 \u0628\u0647 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u062e\u0627\u0635 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645: loc[row_label, column_label].<\/li>\n\n\n\n<li>\u0627\u0646\u062f\u06cc\u0633 \u06af\u0630\u0627\u0631\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u0631\u062f\u06cc\u0641 \u0648 \u0627\u0646\u062f\u06cc\u0633 \u0633\u062a\u0648\u0646: \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0646\u062f\u06cc\u0633\u200c\u0647\u0627\u06cc \u0633\u0637\u0631 \u0648 \u0633\u062a\u0648\u0646 \u0628\u0647 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u062e\u0627\u0635 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645: iloc[row_index, column_index].<\/li>\n<\/ul>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><style><\/style><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"195\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/06\/Conditional-Statements-in-Python_Watermarked-300x195.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0634\u0631\u0637\u06cc \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/06\/Conditional-Statements-in-Python_Watermarked-300x195.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/06\/Conditional-Statements-in-Python_Watermarked-768x499.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/06\/Conditional-Statements-in-Python_Watermarked.webp 1000w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/195;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/conditional-statements-in-python\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0622\u0645\u0648\u0632\u0634 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0634\u0631\u0637\u06cc \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646<\/h3>\n\n\n\n<p>Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u0645\u0627\u0646\u0646\u062f \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646\u060c \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u0648 \u062a\u0628\u062f\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0686\u0646\u062f \u0631\u0648\u0634 \u0645\u062a\u062f\u0627\u0648\u0644 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>filter()\u200e: \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u06cc\u0627 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0634\u0631\u0627\u06cc\u0637 \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0646\u06cc\u0645.<\/li>\n\n\n\n<li>sort_values()\u200e: \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0686\u0627\u0631\u0686\u0648\u0628 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u0645.<\/li>\n\n\n\n<li>groupby()\u200e: \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u062a\u0648\u0627\u0628\u0639 \u062c\u0645\u0639\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0645\u0627\u0646\u0646\u062f \u0645\u062c\u0645\u0648\u0639\u060c \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u060c \u0634\u0645\u0627\u0631\u0634 \u0648 \u063a\u06cc\u0631\u0647 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645.<\/li>\n\n\n\n<li>merge()\u200e: \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u062f\u0648 \u06cc\u0627 \u0686\u0646\u062f \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0631\u0627\u06cc\u062c \u0627\u062f\u063a\u0627\u0645 \u06a9\u0646\u06cc\u0645.<\/li>\n\n\n\n<li>fillna()\u200e: \u0628\u0647 \u0645\u0627 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0647 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0631\u0627 \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u06cc\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0633\u062a\u0631\u0627\u062a\u0698\u06cc\u200c\u0647\u0627\u06cc \u067e\u0631 \u06a9\u0631\u062f\u0646 \u0645\u062e\u062a\u0644\u0641 \u067e\u0631 \u06a9\u0646\u06cc\u0645.<\/li>\n<\/ul>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"200\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2019\/10\/book-shelves-bookcase-books-926680-300x200.jpg.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u0645\u0639\u0631\u0641\u06cc \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u0648 \u06a9\u0627\u0631\u0628\u0631\u062f \u0622\u0646 \u0647\u0627\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2019\/10\/book-shelves-bookcase-books-926680-300x200.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2019\/10\/book-shelves-bookcase-books-926680-768x512.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2019\/10\/book-shelves-bookcase-books-926680.jpg 1000w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/200;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/python-libraries\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 + \u0645\u0632\u0627\u06cc\u0627\u060c \u0645\u0639\u0627\u06cc\u0628 \u0648 \u06a9\u0627\u0631\u0628\u0631\u062f \u0647\u0631\u06a9\u062f\u0627\u0645<\/a>\n<\/section><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u0647\u0627\u06cc \u0639\u0645\u0644\u06cc \u0628\u0631\u0627\u06cc Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646<\/h2>\n\n\n\n<p>\u0647\u0645\u0627\u0646\u200c\u0637\u0648\u0631 \u06a9\u0647 \u06af\u0641\u062a\u0647 \u0634\u062f Dataframe \u06a9\u0627\u0631\u0628\u0631\u062f\u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634  \u0686\u0646\u062f \u0645\u062b\u0627\u0644 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0645\u0639\u0631\u0641\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/python-advanced-66_XKh2lTO_1403-08-16-164738244\/1f480ce393376c388fd104bc95544548.webp?expire=4893471932&#038;token=c5ac8135cd77e32d3ab1c8e3c72b6ee3&#038;md5=xayBNc134y06scjjxytu4w==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u067e\u0627\u06cc\u062a\u0648\u0646 (\u067e\u06cc\u0634\u0631\u0641\u062a\u0647)\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u067e\u0627\u06cc\u062a\u0648\u0646 (\u067e\u06cc\u0634\u0631\u0641\u062a\u0647)\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D9%86%D9%88%DB%8C%D8%B3%DB%8C-%D8%A8%D8%A7-%D9%BE%D8%A7%DB%8C%D8%AA%D9%88%D9%86-%D9%BE%DB%8C%D8%B4%D8%B1%D9%81%D8%AA%D9%87-mk387\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u067e\u0627\u06cc\u062a\u0648\u0646 (\u067e\u06cc\u0634\u0631\u0641\u062a\u0647)        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f1,\u06f9\u06f9\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f1,\u06f3\u06f9\u06f0,\u06f0\u06f0\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f3\u06f0%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D9%86%D9%88%DB%8C%D8%B3%DB%8C-%D8%A8%D8%A7-%D9%BE%D8%A7%DB%8C%D8%AA%D9%88%D9%86-%D9%BE%DB%8C%D8%B4%D8%B1%D9%81%D8%AA%D9%87-mk387\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0631\u0627 \u0628\u0627 \u0686\u0646\u062f \u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u06cc \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u0645:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u067e\u0627\u06a9\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627 Dataframe<\/h3>\n\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u062d\u0627\u0648\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u062f\u0627\u0631\u06cc\u0645\u060c \u0627\u0645\u0627 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0647 \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0642\u0628\u0644 \u0627\u0632 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u067e\u0627\u06a9 \u0634\u0648\u0646\u062f. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 Dataframe \u0647\u0627 \u0628\u0631\u0627\u06cc \u067e\u0627\u06a9 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u0645\u0627 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u0645:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"534\" height=\"342\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame45.png\" alt=\"\u062f\u06cc\u062a\u0627 \u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0686\u06cc\u0633\u062a\" class=\"wp-image-30565 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame45.png 534w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/data-frame45-300x192.png.webp 300w\" data-sizes=\"(max-width: 534px) 100vw, 534px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 534px; --smush-placeholder-aspect-ratio: 534\/342;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062d\u0627\u0644 \u0628\u0631\u0627\u06cc \u067e\u0627\u06a9\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0627 Dataframe \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u0646\u0648\u0634\u062a.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd\n\n<span class=\"token comment\"># Read data from a CSV file<\/span>\ndf <span class=\"token operator\">=<\/span> pd<span class=\"token punctuation\">.<\/span>read_csv<span class=\"token punctuation\">(<\/span><span class=\"token string\">'customer_data.csv'<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># View first few rows of the dataframe<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Check for missing values<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">.<\/span>isnull<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Fill missing values with mean of the column<\/span>\ndf<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'age'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>fillna<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'age'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>mean<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> inplace<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Drop rows with missing values in other columns<\/span>\ndf<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">=<\/span><span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'gender'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> inplace<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Reset index<\/span>\ndf<span class=\"token punctuation\">.<\/span>reset_index<span class=\"token punctuation\">(<\/span>drop<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">,<\/span> inplace<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># View cleaned dataframe<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/code><\/pre>\n\n\n\n<p>\u062d\u0627\u0644 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u06a9\u062f \u062e\u0631\u0648\u062c\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"664\" height=\"405\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame49.png\" alt=\"\u067e\u0627\u06a9\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627 Dataframe\" class=\"wp-image-30566 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame49.png 664w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/data-frame49-300x183.png.webp 300w\" data-sizes=\"(max-width: 664px) 100vw, 664px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 664px; --smush-placeholder-aspect-ratio: 664\/405;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0641\u0648\u0642\u060c \u0641\u0627\u06cc\u0644 CSV \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 ()pd.read_csv \u062f\u0631 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062e\u0648\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0645\u062a\u062f df.head()\u200e \u06cc\u0627 (pandas head function) \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u0627\u0648\u0644 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f. \u0645\u062a\u062f df.isnull().sum()\u200e \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0647 \u062f\u0631 dataframe \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0645\u062a\u062f fillna()\u200e \u0628\u0631\u0627\u06cc \u067e\u0631 \u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0647 \u062f\u0631 \u0633\u062a\u0648\u0646 &#8220;Age&#8221; \u0628\u0627 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u062a\u0648\u0646 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n\n\n\n<p>\u0645\u062a\u062f dropna()\u200e \u0628\u0631\u0627\u06cc \u0631\u0647\u0627 \u06a9\u0631\u062f\u0646 \u0633\u0637\u0631\u0647\u0627\u06cc\u06cc \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u06af\u0645\u0634\u062f\u0647 \u062f\u0631 \u0633\u062a\u0648\u0646 &#8220;City&#8221; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0627\u0632 \u0645\u062a\u062f reset_index()\u200e \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0645\u062c\u062f\u062f \u0627\u06cc\u0646\u062f\u06a9\u0633 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u067e\u0633 \u0627\u0632 \u0627\u0646\u062f\u0627\u062e\u062a\u0646 \u0633\u0637\u0631\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f \u0648 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u067e\u0627\u06a9 \u0634\u062f\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 df.head()\u200e \u06cc\u0627 \u0647\u0645\u0627\u0646 dataframe head \u0686\u0627\u067e \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627 Dataframe<\/h3>\n\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u062d\u0627\u0648\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0642\u06cc\u0645\u062a \u0633\u0647\u0627\u0645 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06cc\u0627\u0641\u062a\u0646 \u0631\u0648\u0646\u062f\u0647\u0627 \u0648 \u0627\u0644\u06af\u0648\u0647\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u0645. \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 Dataframe \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0647\u0633\u062a\u0646\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"668\" height=\"467\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame497.png\" alt=\"\u0622\u0645\u0648\u0632\u0634 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646\" class=\"wp-image-30568 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame497.png 668w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/data-frame497-300x210.png.webp 300w\" data-sizes=\"(max-width: 668px) 100vw, 668px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 668px; --smush-placeholder-aspect-ratio: 668\/467;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0642\u0637\u0639\u0647 \u06a9\u062f \u0622\u0646\u0627\u0644\u06cc\u0632 \u062f\u0627\u062f\u0647 \u0628\u0627 Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd\n<span class=\"token keyword\">import<\/span> matplotlib<span class=\"token punctuation\">.<\/span>pyplot <span class=\"token keyword\">as<\/span> plt\n\n<span class=\"token comment\"># Read data from a CSV file<\/span>\ndf <span class=\"token operator\">=<\/span> pd<span class=\"token punctuation\">.<\/span>read_csv<span class=\"token punctuation\">(<\/span><span class=\"token string\">'stock_data.csv'<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Verify column names in the dataframe<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># Make sure 'close' column is present<\/span>\n<span class=\"token keyword\">if<\/span> <span class=\"token string\">'close'<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span>\n    <span class=\"token comment\"># Calculate daily returns<\/span>\n    df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'Return'<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'close'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>pct_change<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n\n    <span class=\"token comment\"># Calculate rolling average of returns<\/span>\n    df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'Rolling_Average'<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'Return'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>rolling<span class=\"token punctuation\">(<\/span>window<span class=\"token operator\">=<\/span><span class=\"token number\">\u06f1\u06f0<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>mean<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n\n    <span class=\"token comment\"># Filter data for positive returns<\/span>\n    df_positive <span class=\"token operator\">=<\/span> df<span class=\"token punctuation\">&#91;<\/span>df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'Return'<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&amp;<\/span>gt<span class=\"token punctuation\">;<\/span> <span class=\"token number\">\u06f0<\/span><span class=\"token punctuation\">]<\/span>\n\n    <span class=\"token comment\"># Group data by year and calculate average returns<\/span>\n    df_yearly <span class=\"token operator\">=<\/span> df_positive<span class=\"token punctuation\">.<\/span>groupby<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'date'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">'\/'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">&#91;<\/span><span class=\"token number\">\u06f2<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">&#91;<\/span><span class=\"token string\">'Return'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>mean<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n\n    <span class=\"token comment\"># Sort and plot yearly returns<\/span>\n    df_yearly<span class=\"token punctuation\">.<\/span>sort_values<span class=\"token punctuation\">(<\/span>ascending<span class=\"token operator\">=<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>plot<span class=\"token punctuation\">(<\/span>kind<span class=\"token operator\">=<\/span><span class=\"token string\">'bar'<\/span><span class=\"token punctuation\">,<\/span> title<span class=\"token operator\">=<\/span><span class=\"token string\">'Average Yearly Returns'<\/span><span class=\"token punctuation\">)<\/span>\n\n    <span class=\"token comment\"># Show the plot<\/span>\n    plt<span class=\"token punctuation\">.<\/span>show<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"Error: 'close' column not found in the dataframe.\"<\/span><span class=\"token punctuation\">)<\/span><\/code><\/pre>\n\n\n\n<p>\u062e\u0631\u0648\u062c\u06cc \u0642\u0637\u0639\u0647 \u06a9\u062f \u0628\u0627\u0644\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"693\" height=\"709\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame8.png\" alt=\"\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0628\u0627 \u062f\u06cc\u062a\u0627 \u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646\" class=\"wp-image-30569 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/data-frame8.png 693w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/data-frame8-293x300.png.webp 293w\" data-sizes=\"(max-width: 693px) 100vw, 693px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 693px; --smush-placeholder-aspect-ratio: 693\/709;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u06a9\u062f \u062f\u0648 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u06cc\u0627 \u0627\u06cc\u0645\u067e\u0648\u0631\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f. \u067e\u0627\u0646\u062f\u0627\u0647\u0627 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 matplotlib \u0628\u0631\u0627\u06cc \u0631\u0633\u0645. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u06cc\u0646 \u06a9\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 ()pd.read_csv \u0627\u0632 \u067e\u0627\u0646\u062f\u0627\u0647\u0627 \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u0628\u0647 \u0646\u0627\u0645 &#8216;stock_data.csv&#8217; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0634\u06cc DataFrame pandas \u0628\u0647 \u0646\u0627\u0645 df \u0630\u062e\u06cc\u0631\u0647 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n<p>\u06a9\u062f \u0641\u0648\u0642 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc DataFrame df \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc df.columns \u0686\u0627\u067e \u0645\u06cc\u200c\u06a9\u0646\u062f \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u06a9\u062f \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0633\u062a\u0648\u0646\u06cc \u0628\u0647 \u0646\u0627\u0645 &#8220;close&#8221; \u062f\u0631 DataFrame df \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0645\u0644\u06af\u0631 in \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06cc\u0627 \u062e\u06cc\u0631. \u062f\u0631 \u0635\u0648\u0631\u062a \u0648\u062c\u0648\u062f\u060c \u06a9\u062f \u0628\u0627 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u062f\u0627\u0645\u0647 \u0645\u06cc\u200c\u06cc\u0627\u0628\u062f. \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u06cc\u06a9 \u067e\u06cc\u063a\u0627\u0645 \u062e\u0637\u0627 \u0686\u0627\u067e \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n<p>\u06a9\u062f \u0628\u0627\u0632\u062f\u0647 \u0631\u0648\u0632\u0627\u0646\u0647 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062a\u062f ()pct_change \u062f\u0631 \u0633\u062a\u0648\u0646 &#8216;close&#8217; DataFrame df \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u0633\u062a\u0648\u0646 \u062c\u062f\u06cc\u062f\u06cc \u0628\u0647 \u0646\u0627\u0645 &#8216;Return&#8217; \u0630\u062e\u06cc\u0631\u0647 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f. \u0633\u067e\u0633 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0628\u0631\u06af\u0634\u062a\u06cc \u0628\u0627\u0632\u062f\u0647 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062a\u062f ()rolling \u0628\u0627 \u0627\u0646\u062f\u0627\u0632\u0647 \u067e\u0646\u062c\u0631\u0647 \u06f1\u06f0 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u062c\u062f\u06cc\u062f \u0628\u0647 \u0646\u0627\u0645 Rolling_Average \u0630\u062e\u06cc\u0631\u0647 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n<p>\u0627\u06cc\u0646 \u06a9\u062f \u0647\u0645\u0686\u0646\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u062f\u0647 \u0645\u062b\u0628\u062a \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0647 \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 DataFrame \u062c\u062f\u06cc\u062f \u0628\u0647 \u0646\u0627\u0645 df_positive \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0633\u067e\u0633 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u0627\u0644 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062a\u062f groupby()\u200e \u062f\u0631 \u0633\u062a\u0648\u0646 &#8216;date&#8217; \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0631\u062f\u0647\u060c \u067e\u0633 \u0627\u0632 \u062a\u0642\u0633\u06cc\u0645 \u0622\u0646 \u0628\u0631 &#8216;\/&#8217; \u0648 \u06af\u0631\u0641\u062a\u0646 \u0639\u0646\u0635\u0631 \u0633\u0648\u0645 (year) \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc str.split()\u200e \u0648 str[2]. \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u062a\u0648\u0646 &#8216;Return&#8217; \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0633\u0627\u0644 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062a\u062f mean()\u200e \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 DataFrame \u062c\u062f\u06cc\u062f \u0628\u0647 \u0646\u0627\u0645 df_yearly \u0630\u062e\u06cc\u0631\u0647 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f. \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0628\u0627\u0632\u062f\u0647 \u0633\u0627\u0644\u0627\u0646\u0647 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062a\u062f sort_values()\u200e \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u0646\u0632\u0648\u0644\u06cc \u0645\u0631\u062a\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062a\u062f plot()\u200e \u0628\u0647 \u0635\u0648\u0631\u062a \u0646\u0645\u0648\u062f\u0627\u0631 \u0645\u06cc\u0644\u0647\u200c\u0627\u06cc \u0628\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 kind \u06a9\u0647 \u0631\u0648\u06cc &#8216;bar&#8217; \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0646\u0645\u0648\u062f\u0627\u0631 \u0631\u0627 \u0631\u0633\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062a\u0627\u0628\u0639 ()plt.show \u0646\u0645\u0648\u062f\u0627\u0631 \u0631\u0627 \u0631\u0648\u06cc \u0635\u0641\u062d\u0647\u200c\u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0633\u062e\u0646 \u067e\u0627\u06cc\u0627\u0646\u06cc<\/h2>\n\n\n\n<p>Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0628\u0632\u0627\u0631\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0648 \u0627\u0646\u0639\u0637\u0627\u0641\u200c\u067e\u0630\u06cc\u0631 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0633\u062a. \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u06cc\u06a9 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u062c\u062f\u0648\u0644\u06cc \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u06a9\u0647 \u06a9\u0627\u0631 \u0628\u0627 \u0622\u0646 \u0622\u0633\u0627\u0646 \u0628\u0648\u062f\u0647 \u0648 \u0637\u06cc\u0641 \u06af\u0633\u062a\u0631\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0648 \u0645\u062a\u062f\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0648\u0638\u0627\u06cc\u0641 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0647 \u0627\u0635\u0648\u0644 \u0627\u0648\u0644\u06cc\u0647 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0632 \u062c\u0645\u0644\u0647 \u0627\u06cc\u062c\u0627\u062f\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u067e\u0631\u062f\u0627\u062e\u062a\u0647\u200c\u0627\u06cc\u0645. \u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0646\u0645\u0648\u0646\u0647\u200c\u0647\u0627\u06cc \u0639\u0645\u0644\u06cc \u0627\u0632 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0686\u0627\u0631\u0686\u0648\u0628\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u067e\u0627\u06a9\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0648\u0638\u0627\u06cc\u0641 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645.<\/p>\n\n\n\n<p>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0628\u0632\u0631\u06af \u0631\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u062f\u060c \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f \u0648 \u0628\u06cc\u0646\u0634\u200c\u0647\u0627\u06cc\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0686\u0647 \u062f\u0631 \u062d\u0627\u0644 \u06a9\u0627\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u062c\u0627\u0631\u062a\u060c \u0627\u0645\u0648\u0631 \u0645\u0627\u0644\u06cc\u060c \u0639\u0644\u0645\u06cc \u06cc\u0627 \u0647\u0631 \u062d\u0648\u0632\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0628\u0627\u0634\u06cc\u062f\u060c \u062f\u06cc\u062a\u0627\u0641\u0631\u06cc\u0645 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0628\u0632\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u062f\u0631 \u062c\u0639\u0628\u0647\u200c\u0627\u0628\u0632\u0627\u0631 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0628\u0627\u0634\u0646\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dataframe \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 (dataframe python) \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0645\u062d\u0628\u0648\u0628 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0637\u0648\u0631 \u06af\u0633\u062a\u0631\u062f\u0647 \u062f\u0631 \u062a\u062c\u0632\u06cc\u0647\u200c\u0648\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0648\u0638\u0627\u06cc\u0641 \u0639\u0644\u0645 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0622\u0646\u200c\u0647\u0627 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u0648\u0644\u06cc \u062f\u0648\u0628\u0639\u062f\u06cc \u0647\u0633\u062a\u0646\u062f\u060c \u0634\u0628\u06cc\u0647 \u0628\u0647 \u0635\u0641\u062d\u0627\u062a \u06af\u0633\u062a\u0631\u062f\u0647 \u06cc\u0627 \u062c\u062f\u0627\u0648\u0644 SQL\u060c \u0628\u0627 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0630\u062e\u06cc\u0631\u0647 \u0648 \u062f\u0633\u062a\u200c\u06a9\u0627\u0631\u06cc \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":30571,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,9],"tags":[],"class_list":["post-30561","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming-and-it-training","category-python-articles"],"_links":{"self":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/30561","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/comments?post=30561"}],"version-history":[{"count":5,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/30561\/revisions"}],"predecessor-version":[{"id":63817,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/30561\/revisions\/63817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media\/30571"}],"wp:attachment":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media?parent=30561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/categories?post=30561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/tags?post=30561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}