Creating pandas DataFrame through class returns empty DataFrame

Question

The purpose of this script is to produce a data frame that is generated through code written in object oriented style.

The problem is the outcome of this script is an empty data frame.

There is no error.

Here is the code:

import pandas as pd


class Dataframe:
    def __init__(self):
        self.df = pd.DataFrame()

    def name(self):
        self.df['name'] = ["Hamza", "Carmen"]
        return print(self.df['name'])

    def age(self):
        self.df['age'] = [20, 15]
        return self.df['age']

    def sex(self):
        self.df['sex'] = ["Male", "Female"]
        return self.df['sex']

    def address(self):
        self.df['adress'] = ["Miami", "Seattle"]
        return self.df['adress']

    def print(self):
        return print(self.df)


x = Dataframe()
x.print()

at no point are you calling the methods that are populating the df. so it correctly is returning an empty df — Bendik Knapstad
– Bendik Knapstad, Commented May 28, 2020 at 11:42

Erfan · Accepted Answer · 2020-05-28 11:52:50Z

3

You need to call the methods you have created to populate the DataFrame.

import pandas as pd


class Dataframe:
    def __init__(self):
        self.df = pd.DataFrame()
        self.name()
        self.age()
        self.sex()
        self.address()

    def name(self):
        self.df['name'] = ["Hamza", "Carmen"]
        return print(self.df['name'])

    def age(self):
        self.df['age'] = [20, 15]
        return self.df['age']

    def sex(self):
        self.df['sex'] = ["Male", "Female"]
        return self.df['sex']

    def address(self):
        self.df['adress'] = ["Miami", "Seattle"]
        return self.df['adress']

    def print(self):
        print(self.df)


x = Dataframe()
x.print()

edited May 28, 2020 at 11:52

Erfan

43.3k10 gold badges75 silver badges86 bronze badges

answered May 28, 2020 at 11:44

James

37k4 gold badges54 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

James Over a year ago

Sorry @SayedGouda, there was an error in the original code, that I copied. Erfan fixed it.

Guilherme Barasuol Scherner · Accepted Answer · 2020-05-28 11:44:59Z

2

You must call the methods of the class

x = Dataframe()
x.name()
x.age()
...

answered May 28, 2020 at 11:44

Guilherme Barasuol Scherner

439 bronze badges

1 Comment

Guilherme Barasuol Scherner Over a year ago

On the line switch self.df['name'] = ["Male", "Female"] 'name' -> 'sex'

Matthew Ang · Accepted Answer · 2020-05-28 11:43:33Z

1

You didn't call DataFrame().name/age or any other functions you defined within the class. That's why it's returning the default self.df value which is empty

answered May 28, 2020 at 11:43

Matthew Ang

513 bronze badges

Comments

Bugface · Accepted Answer · 2020-05-28 11:55:04Z

0

One small thing added to the answers above:

print() function return None. So return print(xx) will yield value as None, not the one you expected.

answered May 28, 2020 at 11:55

Bugface

3132 silver badges7 bronze badges

Collectives™ on Stack Overflow

Creating pandas DataFrame through class returns empty DataFrame

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related