CVS files reading.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a6e34b14",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Personal Evaluation  Test Fall 21</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Timestamp</td>\n",
       "      <td>name</td>\n",
       "      <td>relation</td>\n",
       "      <td>good</td>\n",
       "      <td>bad</td>\n",
       "      <td>suggestions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>Others</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/10/2021 17:26</td>\n",
       "      <td>Ramsha Shakeel</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Active and passionate</td>\n",
       "      <td>nothing</td>\n",
       "      <td>You are perfectly okay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3/10/2021 9:41</td>\n",
       "      <td>Yahya</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Courage to do productive things without hesita...</td>\n",
       "      <td>Just don't interact with many people.</td>\n",
       "      <td>Try to increase your friend circle that way yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3/10/2021 10:40</td>\n",
       "      <td>Rohail Ahmed</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Confidence in asking questions\\nYou give respe...</td>\n",
       "      <td>I think you need to improve\\n\\nAvoid sensitivi...</td>\n",
       "      <td>I think you are focusing on your personal assi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3/10/2021 13:26</td>\n",
       "      <td>DH</td>\n",
       "      <td>University friend</td>\n",
       "      <td>A responsible guy having clear aims for his li...</td>\n",
       "      <td>Wsy tu kafi han... Bas Voice notes choty bhja ...</td>\n",
       "      <td>Same as above.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3/10/2021 13:32</td>\n",
       "      <td>Mohsin Satti</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Your humbleness</td>\n",
       "      <td>You always say that you are ravian. And you fe...</td>\n",
       "      <td>Just remove your above mentioned baad habits..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>3/10/2021 14:59</td>\n",
       "      <td>Mahad</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Everything</td>\n",
       "      <td>I don’t want to waste my time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Personal Evaluation  Test Fall 21       Unnamed: 1         Unnamed: 2  \\\n",
       "0                          Timestamp             name           relation   \n",
       "1                    2/10/2021 17:12             Shah             Others   \n",
       "2                    2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "3                    2/10/2021 17:25    Adam ke ullad             Others   \n",
       "4                    2/10/2021 17:26   Ramsha Shakeel           Relative   \n",
       "..                               ...              ...                ...   \n",
       "66                    3/10/2021 9:41            Yahya           Relative   \n",
       "67                   3/10/2021 10:40     Rohail Ahmed  University friend   \n",
       "68                   3/10/2021 13:26               DH  University friend   \n",
       "69                   3/10/2021 13:32     Mohsin Satti  University friend   \n",
       "70                   3/10/2021 14:59            Mahad  University friend   \n",
       "\n",
       "                                           Unnamed: 3  \\\n",
       "0                                                good   \n",
       "1                                  You're hardworking   \n",
       "2   Helpful, Cooperative, well-mannered (& many more)   \n",
       "3                                         Tu muze hai   \n",
       "4                               Active and passionate   \n",
       "..                                                ...   \n",
       "66  Courage to do productive things without hesita...   \n",
       "67  Confidence in asking questions\\nYou give respe...   \n",
       "68  A responsible guy having clear aims for his li...   \n",
       "69                                   Your humbleness    \n",
       "70                                           Nothing    \n",
       "\n",
       "                                           Unnamed: 4  \\\n",
       "0                                                 bad   \n",
       "1                               You're an overthinker   \n",
       "2                          Less social, less friendly   \n",
       "3                                        Charse jahaz   \n",
       "4                                             nothing   \n",
       "..                                                ...   \n",
       "66              Just don't interact with many people.   \n",
       "67  I think you need to improve\\n\\nAvoid sensitivi...   \n",
       "68  Wsy tu kafi han... Bas Voice notes choty bhja ...   \n",
       "69  You always say that you are ravian. And you fe...   \n",
       "70                                        Everything    \n",
       "\n",
       "                                           Unnamed: 5  \n",
       "0                                         suggestions  \n",
       "1                                          Keep calm   \n",
       "2   Be friendly and don't take everything serious ...  \n",
       "3                             Chal puttur tu chuti kr  \n",
       "4                              You are perfectly okay  \n",
       "..                                                ...  \n",
       "66  Try to increase your friend circle that way yo...  \n",
       "67  I think you are focusing on your personal assi...  \n",
       "68                                     Same as above.  \n",
       "69     Just remove your above mentioned baad habits..  \n",
       "70                      I don’t want to waste my time  \n",
       "\n",
       "[71 rows x 6 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "# csv file is comma separated values  file format for an excel file.\n",
    "\n",
    "df = pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\")\n",
    "# r laganay se yeh raw string bn jayegi! aur error nhi ayega unicode se related.\n",
    "df\n",
    "\n",
    "# we can also skip header / rows \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6dd9c683",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp</th>\n",
       "      <th>name</th>\n",
       "      <th>relation</th>\n",
       "      <th>good</th>\n",
       "      <th>bad</th>\n",
       "      <th>suggestions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>Others</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:26</td>\n",
       "      <td>Ramsha Shakeel</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Active and passionate</td>\n",
       "      <td>nothing</td>\n",
       "      <td>You are perfectly okay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/10/2021 17:27</td>\n",
       "      <td>Usama Ejaz</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Friendly and Helpful</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Nothing just keep on doing the good work and m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>3/10/2021 9:41</td>\n",
       "      <td>Yahya</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Courage to do productive things without hesita...</td>\n",
       "      <td>Just don't interact with many people.</td>\n",
       "      <td>Try to increase your friend circle that way yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3/10/2021 10:40</td>\n",
       "      <td>Rohail Ahmed</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Confidence in asking questions\\nYou give respe...</td>\n",
       "      <td>I think you need to improve\\n\\nAvoid sensitivi...</td>\n",
       "      <td>I think you are focusing on your personal assi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3/10/2021 13:26</td>\n",
       "      <td>DH</td>\n",
       "      <td>University friend</td>\n",
       "      <td>A responsible guy having clear aims for his li...</td>\n",
       "      <td>Wsy tu kafi han... Bas Voice notes choty bhja ...</td>\n",
       "      <td>Same as above.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3/10/2021 13:32</td>\n",
       "      <td>Mohsin Satti</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Your humbleness</td>\n",
       "      <td>You always say that you are ravian. And you fe...</td>\n",
       "      <td>Just remove your above mentioned baad habits..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3/10/2021 14:59</td>\n",
       "      <td>Mahad</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Everything</td>\n",
       "      <td>I don’t want to waste my time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Timestamp             name           relation  \\\n",
       "0   2/10/2021 17:12             Shah             Others   \n",
       "1   2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "2   2/10/2021 17:25    Adam ke ullad             Others   \n",
       "3   2/10/2021 17:26   Ramsha Shakeel           Relative   \n",
       "4   2/10/2021 17:27       Usama Ejaz  University friend   \n",
       "..              ...              ...                ...   \n",
       "65   3/10/2021 9:41            Yahya           Relative   \n",
       "66  3/10/2021 10:40     Rohail Ahmed  University friend   \n",
       "67  3/10/2021 13:26               DH  University friend   \n",
       "68  3/10/2021 13:32     Mohsin Satti  University friend   \n",
       "69  3/10/2021 14:59            Mahad  University friend   \n",
       "\n",
       "                                                 good  \\\n",
       "0                                  You're hardworking   \n",
       "1   Helpful, Cooperative, well-mannered (& many more)   \n",
       "2                                         Tu muze hai   \n",
       "3                               Active and passionate   \n",
       "4                                Friendly and Helpful   \n",
       "..                                                ...   \n",
       "65  Courage to do productive things without hesita...   \n",
       "66  Confidence in asking questions\\nYou give respe...   \n",
       "67  A responsible guy having clear aims for his li...   \n",
       "68                                   Your humbleness    \n",
       "69                                           Nothing    \n",
       "\n",
       "                                                  bad  \\\n",
       "0                               You're an overthinker   \n",
       "1                          Less social, less friendly   \n",
       "2                                        Charse jahaz   \n",
       "3                                             nothing   \n",
       "4                                             Nothing   \n",
       "..                                                ...   \n",
       "65              Just don't interact with many people.   \n",
       "66  I think you need to improve\\n\\nAvoid sensitivi...   \n",
       "67  Wsy tu kafi han... Bas Voice notes choty bhja ...   \n",
       "68  You always say that you are ravian. And you fe...   \n",
       "69                                        Everything    \n",
       "\n",
       "                                          suggestions  \n",
       "0                                          Keep calm   \n",
       "1   Be friendly and don't take everything serious ...  \n",
       "2                             Chal puttur tu chuti kr  \n",
       "3                              You are perfectly okay  \n",
       "4   Nothing just keep on doing the good work and m...  \n",
       "..                                                ...  \n",
       "65  Try to increase your friend circle that way yo...  \n",
       "66  I think you are focusing on your personal assi...  \n",
       "67                                     Same as above.  \n",
       "68     Just remove your above mentioned baad habits..  \n",
       "69                      I don’t want to waste my time  \n",
       "\n",
       "[70 rows x 6 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 =pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\", skiprows=3)\n",
    "df1\n",
    "\n",
    "df2=pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\", header=1) //1st row ko delete krne ka tareeka..\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "50cc8371",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>T</th>\n",
       "      <th>N</th>\n",
       "      <th>R</th>\n",
       "      <th>G</th>\n",
       "      <th>B</th>\n",
       "      <th>S</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>Others</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:26</td>\n",
       "      <td>Ramsha Shakeel</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Active and passionate</td>\n",
       "      <td>nothing</td>\n",
       "      <td>You are perfectly okay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/10/2021 17:27</td>\n",
       "      <td>Usama Ejaz</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Friendly and Helpful</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Nothing just keep on doing the good work and m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>3/10/2021 9:41</td>\n",
       "      <td>Yahya</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Courage to do productive things without hesita...</td>\n",
       "      <td>Just don't interact with many people.</td>\n",
       "      <td>Try to increase your friend circle that way yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3/10/2021 10:40</td>\n",
       "      <td>Rohail Ahmed</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Confidence in asking questions\\nYou give respe...</td>\n",
       "      <td>I think you need to improve\\n\\nAvoid sensitivi...</td>\n",
       "      <td>I think you are focusing on your personal assi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3/10/2021 13:26</td>\n",
       "      <td>DH</td>\n",
       "      <td>University friend</td>\n",
       "      <td>A responsible guy having clear aims for his li...</td>\n",
       "      <td>Wsy tu kafi han... Bas Voice notes choty bhja ...</td>\n",
       "      <td>Same as above.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3/10/2021 13:32</td>\n",
       "      <td>Mohsin Satti</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Your humbleness</td>\n",
       "      <td>You always say that you are ravian. And you fe...</td>\n",
       "      <td>Just remove your above mentioned baad habits..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3/10/2021 14:59</td>\n",
       "      <td>Mahad</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Everything</td>\n",
       "      <td>I don’t want to waste my time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  T                N                  R  \\\n",
       "0   2/10/2021 17:12             Shah             Others   \n",
       "1   2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "2   2/10/2021 17:25    Adam ke ullad             Others   \n",
       "3   2/10/2021 17:26   Ramsha Shakeel           Relative   \n",
       "4   2/10/2021 17:27       Usama Ejaz  University friend   \n",
       "..              ...              ...                ...   \n",
       "65   3/10/2021 9:41            Yahya           Relative   \n",
       "66  3/10/2021 10:40     Rohail Ahmed  University friend   \n",
       "67  3/10/2021 13:26               DH  University friend   \n",
       "68  3/10/2021 13:32     Mohsin Satti  University friend   \n",
       "69  3/10/2021 14:59            Mahad  University friend   \n",
       "\n",
       "                                                    G  \\\n",
       "0                                  You're hardworking   \n",
       "1   Helpful, Cooperative, well-mannered (& many more)   \n",
       "2                                         Tu muze hai   \n",
       "3                               Active and passionate   \n",
       "4                                Friendly and Helpful   \n",
       "..                                                ...   \n",
       "65  Courage to do productive things without hesita...   \n",
       "66  Confidence in asking questions\\nYou give respe...   \n",
       "67  A responsible guy having clear aims for his li...   \n",
       "68                                   Your humbleness    \n",
       "69                                           Nothing    \n",
       "\n",
       "                                                    B  \\\n",
       "0                               You're an overthinker   \n",
       "1                          Less social, less friendly   \n",
       "2                                        Charse jahaz   \n",
       "3                                             nothing   \n",
       "4                                             Nothing   \n",
       "..                                                ...   \n",
       "65              Just don't interact with many people.   \n",
       "66  I think you need to improve\\n\\nAvoid sensitivi...   \n",
       "67  Wsy tu kafi han... Bas Voice notes choty bhja ...   \n",
       "68  You always say that you are ravian. And you fe...   \n",
       "69                                        Everything    \n",
       "\n",
       "                                                    S  \n",
       "0                                          Keep calm   \n",
       "1   Be friendly and don't take everything serious ...  \n",
       "2                             Chal puttur tu chuti kr  \n",
       "3                              You are perfectly okay  \n",
       "4   Nothing just keep on doing the good work and m...  \n",
       "..                                                ...  \n",
       "65  Try to increase your friend circle that way yo...  \n",
       "66  I think you are focusing on your personal assi...  \n",
       "67                                     Same as above.  \n",
       "68     Just remove your above mentioned baad habits..  \n",
       "69                      I don’t want to waste my time  \n",
       "\n",
       "[70 rows x 6 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df4 =pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\", header = 1, names = [\"T\",\"N\",\"R\",\"G\",\"B\",\"S\"])\n",
    "# hum inko name dekar bhi read krskte hain!\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "497ede69",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Personal Evaluation  Test Fall 21</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Timestamp</td>\n",
       "      <td>name</td>\n",
       "      <td>relation</td>\n",
       "      <td>good</td>\n",
       "      <td>bad</td>\n",
       "      <td>suggestions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>Others</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Personal Evaluation  Test Fall 21       Unnamed: 1         Unnamed: 2  \\\n",
       "0                         Timestamp             name           relation   \n",
       "1                   2/10/2021 17:12             Shah             Others   \n",
       "2                   2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "3                   2/10/2021 17:25    Adam ke ullad             Others   \n",
       "\n",
       "                                          Unnamed: 3  \\\n",
       "0                                               good   \n",
       "1                                 You're hardworking   \n",
       "2  Helpful, Cooperative, well-mannered (& many more)   \n",
       "3                                        Tu muze hai   \n",
       "\n",
       "                   Unnamed: 4  \\\n",
       "0                         bad   \n",
       "1       You're an overthinker   \n",
       "2  Less social, less friendly   \n",
       "3                Charse jahaz   \n",
       "\n",
       "                                          Unnamed: 5  \n",
       "0                                        suggestions  \n",
       "1                                         Keep calm   \n",
       "2  Be friendly and don't take everything serious ...  \n",
       "3                            Chal puttur tu chuti kr  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df5 =pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\", nrows=4)\n",
    "df5\n",
    "\n",
    "# reading limited data from cvs file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "5f11b916",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Personal Evaluation  Test Fall 21</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Timestamp</td>\n",
       "      <td>name</td>\n",
       "      <td>relation</td>\n",
       "      <td>good</td>\n",
       "      <td>bad</td>\n",
       "      <td>suggestions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>NaN</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/10/2021 17:26</td>\n",
       "      <td>Ramsha Shakeel</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Active and passionate</td>\n",
       "      <td>nothing</td>\n",
       "      <td>You are perfectly okay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3/10/2021 9:41</td>\n",
       "      <td>Yahya</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Courage to do productive things without hesita...</td>\n",
       "      <td>Just don't interact with many people.</td>\n",
       "      <td>Try to increase your friend circle that way yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3/10/2021 10:40</td>\n",
       "      <td>Rohail Ahmed</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Confidence in asking questions\\nYou give respe...</td>\n",
       "      <td>I think you need to improve\\n\\nAvoid sensitivi...</td>\n",
       "      <td>I think you are focusing on your personal assi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3/10/2021 13:26</td>\n",
       "      <td>DH</td>\n",
       "      <td>University friend</td>\n",
       "      <td>A responsible guy having clear aims for his li...</td>\n",
       "      <td>Wsy tu kafi han... Bas Voice notes choty bhja ...</td>\n",
       "      <td>Same as above.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3/10/2021 13:32</td>\n",
       "      <td>Mohsin Satti</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Your humbleness</td>\n",
       "      <td>You always say that you are ravian. And you fe...</td>\n",
       "      <td>Just remove your above mentioned baad habits..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>3/10/2021 14:59</td>\n",
       "      <td>Mahad</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Everything</td>\n",
       "      <td>I don’t want to waste my time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Personal Evaluation  Test Fall 21       Unnamed: 1         Unnamed: 2  \\\n",
       "0                          Timestamp             name           relation   \n",
       "1                    2/10/2021 17:12             Shah                NaN   \n",
       "2                    2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "3                    2/10/2021 17:25    Adam ke ullad                NaN   \n",
       "4                    2/10/2021 17:26   Ramsha Shakeel           Relative   \n",
       "..                               ...              ...                ...   \n",
       "66                    3/10/2021 9:41            Yahya           Relative   \n",
       "67                   3/10/2021 10:40     Rohail Ahmed  University friend   \n",
       "68                   3/10/2021 13:26               DH  University friend   \n",
       "69                   3/10/2021 13:32     Mohsin Satti  University friend   \n",
       "70                   3/10/2021 14:59            Mahad  University friend   \n",
       "\n",
       "                                           Unnamed: 3  \\\n",
       "0                                                good   \n",
       "1                                  You're hardworking   \n",
       "2   Helpful, Cooperative, well-mannered (& many more)   \n",
       "3                                         Tu muze hai   \n",
       "4                               Active and passionate   \n",
       "..                                                ...   \n",
       "66  Courage to do productive things without hesita...   \n",
       "67  Confidence in asking questions\\nYou give respe...   \n",
       "68  A responsible guy having clear aims for his li...   \n",
       "69                                   Your humbleness    \n",
       "70                                           Nothing    \n",
       "\n",
       "                                           Unnamed: 4  \\\n",
       "0                                                 bad   \n",
       "1                               You're an overthinker   \n",
       "2                          Less social, less friendly   \n",
       "3                                        Charse jahaz   \n",
       "4                                             nothing   \n",
       "..                                                ...   \n",
       "66              Just don't interact with many people.   \n",
       "67  I think you need to improve\\n\\nAvoid sensitivi...   \n",
       "68  Wsy tu kafi han... Bas Voice notes choty bhja ...   \n",
       "69  You always say that you are ravian. And you fe...   \n",
       "70                                        Everything    \n",
       "\n",
       "                                           Unnamed: 5  \n",
       "0                                         suggestions  \n",
       "1                                          Keep calm   \n",
       "2   Be friendly and don't take everything serious ...  \n",
       "3                             Chal puttur tu chuti kr  \n",
       "4                              You are perfectly okay  \n",
       "..                                                ...  \n",
       "66  Try to increase your friend circle that way yo...  \n",
       "67  I think you are focusing on your personal assi...  \n",
       "68                                     Same as above.  \n",
       "69     Just remove your above mentioned baad habits..  \n",
       "70                      I don’t want to waste my time  \n",
       "\n",
       "[71 rows x 6 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 =pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\", na_values = [\"Others\"])\n",
    "# useful trick to clean data.\n",
    "# na main jo dengay wo na hojaye ga\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "952acc82",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Personal Evaluation  Test Fall 21</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Timestamp</td>\n",
       "      <td>name</td>\n",
       "      <td>relation</td>\n",
       "      <td>good</td>\n",
       "      <td>bad</td>\n",
       "      <td>suggestions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>Others</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/10/2021 17:26</td>\n",
       "      <td>Ramsha Shakeel</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Active and passionate</td>\n",
       "      <td>nothing</td>\n",
       "      <td>You are perfectly okay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3/10/2021 9:41</td>\n",
       "      <td>Yahya</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Courage to do productive things without hesita...</td>\n",
       "      <td>Just don't interact with many people.</td>\n",
       "      <td>Try to increase your friend circle that way yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3/10/2021 10:40</td>\n",
       "      <td>Rohail Ahmed</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Confidence in asking questions\\nYou give respe...</td>\n",
       "      <td>I think you need to improve\\n\\nAvoid sensitivi...</td>\n",
       "      <td>I think you are focusing on your personal assi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3/10/2021 13:26</td>\n",
       "      <td>DH</td>\n",
       "      <td>University friend</td>\n",
       "      <td>A responsible guy having clear aims for his li...</td>\n",
       "      <td>Wsy tu kafi han... Bas Voice notes choty bhja ...</td>\n",
       "      <td>Same as above.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3/10/2021 13:32</td>\n",
       "      <td>Mohsin Satti</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Your humbleness</td>\n",
       "      <td>You always say that you are ravian. And you fe...</td>\n",
       "      <td>Just remove your above mentioned baad habits..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>3/10/2021 14:59</td>\n",
       "      <td>Mahad</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Everything</td>\n",
       "      <td>I don’t want to waste my time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Personal Evaluation  Test Fall 21       Unnamed: 1         Unnamed: 2  \\\n",
       "0                          Timestamp             name           relation   \n",
       "1                    2/10/2021 17:12             Shah             Others   \n",
       "2                    2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "3                    2/10/2021 17:25    Adam ke ullad             Others   \n",
       "4                    2/10/2021 17:26   Ramsha Shakeel           Relative   \n",
       "..                               ...              ...                ...   \n",
       "66                    3/10/2021 9:41            Yahya           Relative   \n",
       "67                   3/10/2021 10:40     Rohail Ahmed  University friend   \n",
       "68                   3/10/2021 13:26               DH  University friend   \n",
       "69                   3/10/2021 13:32     Mohsin Satti  University friend   \n",
       "70                   3/10/2021 14:59            Mahad  University friend   \n",
       "\n",
       "                                           Unnamed: 3  \\\n",
       "0                                                good   \n",
       "1                                  You're hardworking   \n",
       "2   Helpful, Cooperative, well-mannered (& many more)   \n",
       "3                                         Tu muze hai   \n",
       "4                               Active and passionate   \n",
       "..                                                ...   \n",
       "66  Courage to do productive things without hesita...   \n",
       "67  Confidence in asking questions\\nYou give respe...   \n",
       "68  A responsible guy having clear aims for his li...   \n",
       "69                                   Your humbleness    \n",
       "70                                           Nothing    \n",
       "\n",
       "                                           Unnamed: 4  \\\n",
       "0                                                 bad   \n",
       "1                               You're an overthinker   \n",
       "2                          Less social, less friendly   \n",
       "3                                        Charse jahaz   \n",
       "4                                             nothing   \n",
       "..                                                ...   \n",
       "66              Just don't interact with many people.   \n",
       "67  I think you need to improve\\n\\nAvoid sensitivi...   \n",
       "68  Wsy tu kafi han... Bas Voice notes choty bhja ...   \n",
       "69  You always say that you are ravian. And you fe...   \n",
       "70                                        Everything    \n",
       "\n",
       "                                           Unnamed: 5  \n",
       "0                                         suggestions  \n",
       "1                                          Keep calm   \n",
       "2   Be friendly and don't take everything serious ...  \n",
       "3                             Chal puttur tu chuti kr  \n",
       "4                              You are perfectly okay  \n",
       "..                                                ...  \n",
       "66  Try to increase your friend circle that way yo...  \n",
       "67  I think you are focusing on your personal assi...  \n",
       "68                                     Same as above.  \n",
       "69     Just remove your above mentioned baad habits..  \n",
       "70                      I don’t want to waste my time  \n",
       "\n",
       "[71 rows x 6 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 =pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\", na_values = [\"Try\"] )\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "77d5167b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp</th>\n",
       "      <th>name</th>\n",
       "      <th>relation</th>\n",
       "      <th>good</th>\n",
       "      <th>bad</th>\n",
       "      <th>suggestions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2/10/2021 17:12</td>\n",
       "      <td>Shah</td>\n",
       "      <td>Others</td>\n",
       "      <td>You're hardworking</td>\n",
       "      <td>You're an overthinker</td>\n",
       "      <td>Keep calm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Sameer Doultana</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Helpful, Cooperative, well-mannered (&amp; many more)</td>\n",
       "      <td>Less social, less friendly</td>\n",
       "      <td>Be friendly and don't take everything serious ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/10/2021 17:25</td>\n",
       "      <td>Adam ke ullad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Tu muze hai</td>\n",
       "      <td>Charse jahaz</td>\n",
       "      <td>Chal puttur tu chuti kr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/10/2021 17:26</td>\n",
       "      <td>Ramsha Shakeel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Active and passionate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>You are perfectly okay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/10/2021 17:27</td>\n",
       "      <td>Usama Ejaz</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Friendly and Helpful</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nothing just keep on doing the good work and m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>3/10/2021 9:41</td>\n",
       "      <td>Yahya</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Courage to do productive things without hesita...</td>\n",
       "      <td>Just don't interact with many people.</td>\n",
       "      <td>Try to increase your friend circle that way yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3/10/2021 10:40</td>\n",
       "      <td>Rohail Ahmed</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Confidence in asking questions\\nYou give respe...</td>\n",
       "      <td>I think you need to improve\\n\\nAvoid sensitivi...</td>\n",
       "      <td>I think you are focusing on your personal assi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3/10/2021 13:26</td>\n",
       "      <td>DH</td>\n",
       "      <td>University friend</td>\n",
       "      <td>A responsible guy having clear aims for his li...</td>\n",
       "      <td>Wsy tu kafi han... Bas Voice notes choty bhja ...</td>\n",
       "      <td>Same as above.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3/10/2021 13:32</td>\n",
       "      <td>Mohsin Satti</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Your humbleness</td>\n",
       "      <td>You always say that you are ravian. And you fe...</td>\n",
       "      <td>Just remove your above mentioned baad habits..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3/10/2021 14:59</td>\n",
       "      <td>Mahad</td>\n",
       "      <td>University friend</td>\n",
       "      <td>Nothing</td>\n",
       "      <td>Everything</td>\n",
       "      <td>I don’t want to waste my time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Timestamp             name           relation  \\\n",
       "0   2/10/2021 17:12             Shah             Others   \n",
       "1   2/10/2021 17:25  Sameer Doultana  University friend   \n",
       "2   2/10/2021 17:25    Adam ke ullad             Others   \n",
       "3   2/10/2021 17:26   Ramsha Shakeel                NaN   \n",
       "4   2/10/2021 17:27       Usama Ejaz  University friend   \n",
       "..              ...              ...                ...   \n",
       "65   3/10/2021 9:41            Yahya                NaN   \n",
       "66  3/10/2021 10:40     Rohail Ahmed  University friend   \n",
       "67  3/10/2021 13:26               DH  University friend   \n",
       "68  3/10/2021 13:32     Mohsin Satti  University friend   \n",
       "69  3/10/2021 14:59            Mahad  University friend   \n",
       "\n",
       "                                                 good  \\\n",
       "0                                  You're hardworking   \n",
       "1   Helpful, Cooperative, well-mannered (& many more)   \n",
       "2                                         Tu muze hai   \n",
       "3                               Active and passionate   \n",
       "4                                Friendly and Helpful   \n",
       "..                                                ...   \n",
       "65  Courage to do productive things without hesita...   \n",
       "66  Confidence in asking questions\\nYou give respe...   \n",
       "67  A responsible guy having clear aims for his li...   \n",
       "68                                   Your humbleness    \n",
       "69                                           Nothing    \n",
       "\n",
       "                                                  bad  \\\n",
       "0                               You're an overthinker   \n",
       "1                          Less social, less friendly   \n",
       "2                                        Charse jahaz   \n",
       "3                                                 NaN   \n",
       "4                                                 NaN   \n",
       "..                                                ...   \n",
       "65              Just don't interact with many people.   \n",
       "66  I think you need to improve\\n\\nAvoid sensitivi...   \n",
       "67  Wsy tu kafi han... Bas Voice notes choty bhja ...   \n",
       "68  You always say that you are ravian. And you fe...   \n",
       "69                                        Everything    \n",
       "\n",
       "                                          suggestions  \n",
       "0                                          Keep calm   \n",
       "1   Be friendly and don't take everything serious ...  \n",
       "2                             Chal puttur tu chuti kr  \n",
       "3                              You are perfectly okay  \n",
       "4   Nothing just keep on doing the good work and m...  \n",
       "..                                                ...  \n",
       "65  Try to increase your friend circle that way yo...  \n",
       "66  I think you are focusing on your personal assi...  \n",
       "67                                     Same as above.  \n",
       "68     Just remove your above mentioned baad habits..  \n",
       "69                      I don’t want to waste my time  \n",
       "\n",
       "[70 rows x 6 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfx =pd.read_csv(r\"C:\\Users\\H\\3D Objects\\pandas\\data.csv\",header = 1, na_values = {\n",
    "  \"relation\":[\"Relative\"],\n",
    "    \"bad\":[\"nothing\",\"Nothing\"]\n",
    "    \n",
    "#     yun dictionary ki form main bhi krskte hain data ko manipulate\n",
    "})\n",
    "dfx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "b9d7bb2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfw = df5.to_csv(\"LimitedNewdata.csv\")\n",
    "dfw\n",
    "\n",
    "# it will write the df5 file in a new file LImitedNewData,cvs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "02864e60",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfw = df5.to_csv(\"LimitedNewdata.txt\" , index = False)\n",
    "# by default index leta hai lekin yahan nhi lega as hmne isse false krdia hai \n",
    "dfw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "e0b098cd",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfw = df5.to_csv(\"LimitedNewdata.py\")\n",
    "dfw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "fe881120",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfw = df5.to_csv(\"LimitedNewdata.java\")\n",
    "dfw\n",
    "# is trh kisi bhi file main csv file ka data write krskte hain"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "9ae8495b",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfx.to_csv(\"nameWithGoodData.txt\" ,index = False , columns = ['name','good'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "d1346680",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfx.to_csv(\"nameWithBadData.txt\" ,index = False , columns = ['name','bad'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "cf0c43c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfx.to_csv(\"nameWithSuggestionData.txt\" ,index = False , columns = ['name','suggestions'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "11109906",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}