text_plain_output_1.png
from html.parser import HTMLParser

import pandas as pd

import pandas as pd

import unicodedata

import unicodedata
from html.parser import HTMLParser
class HTMLStripper(HTMLParser):
    def __init__(self):
        HTMLParser.__init__(self)
        self._lines = []
    def error(self, message):
        pass
    @staticmethod
    def remove_control_characters(s):
        return ''.join((ch for ch in s if unicodedata.category(ch)[0] != 'C'))
    def read(self, data):
        self.reset()
        self.feed(data)
        return ' '.join(self._lines)
    def handle_data(self, data):
        data = self.remove_control_characters(data)
        data = data.strip()
        self._lines.append(data)

import pandas as pd
class ImportData:
    @staticmethod
    def read_data(file_name):
        data = pd.read_csv(file_name)
        try:
            data = data.drop(['Unnamed: 0'], axis=0)
        except KeyError:
            pass
        return data
    @staticmethod
    def handle_null_values(data):
        data.drop(columns=['product_meta_keywords'], inplace=True)
        data.dropna(axis=0, inplace=True)
        return data
    def import_data(self, csv_file):
        data = self.read_data(csv_file)
        data = self.handle_null_values(data)
        return data

data_importer = ImportData()
data = data_importer.import_data('../input/qiagen-detail/Qiagen_details.csv')

len(data['product_html'])