text_plain_output_1.png
import numpy as np # linear algebra

import os

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import numpy as np
import pandas as pd
import os

df = pd.read_csv(os.path.join(dirname, filename))

df.isnull().sum()

df.columns

def Price_Converter(string):
    lis = string.split()
    res = [eval(i) for i in lis]
    return np.prod(res)
df.Price = df.Price.str.strip()
df.Price = df.Price.str.replace(',', '')
df.Price = df.Price.str.replace('Lakh', '100000')
df.Price = df.Price.map(Price_Converter)

df.Year = pd.to_datetime(df.Year, format='%Y')

df.head()