Exercise 3

Learning Pandas

import pandas as pd
import numpy as np

# Create empty dataframe 1
df = pd.DataFrame()

# Create a columns
names = ['Trevor', 'George'] * 18

counter1 = []
counter2 = []

for c, d in enumerate(names, 1):
    counter1.append(c)

for x, y in enumerate(names, 10):
    counter2.append(x)

# View dataframe
df["Name"] = names
df["Counter 1"] = counter1
df["Counter 2"] = counter2
df["Counter 3"] = df["Counter 1"] + df["Counter 2"]

# # Add External rows
# # e.g 1:
# # df.loc[len] = ["Total", sum(counter1), sum(counter2), sum(df["Counter 3"])]
# # df.loc[len] = ["Mean", np.int_(np.mean(counter1)), np.int_(np.mean(counter2)), np.int_(np.mean(df["Counter 3"]))]  # noqa
# # df.loc[len] = ["Median", np.int_(np.median(counter1)), np.int_(np.median(counter2)), np.int_(np.median(df["Counter 3"]))]  # noqa

# # e.g 2:
# Create empty dataframe 2
df2 = pd.DataFrame()

# View dataframe
df2["Name"] = ["Total", "Mean", "Median"]
df2["Counter 1"] = sum(counter1), np.int_(np.mean(counter1)), np.int_(np.median(counter1))  # noqa
df2["Counter 2"] = sum(counter2), np.int_(np.mean(counter2)), np.int_(np.median(counter2))  # noqa
df2["Counter 3"] = sum(df["Counter 3"]), np.int_(np.mean(df["Counter 3"])), np.int_(np.median(df["Counter 3"]))  # noqa

# Combine DataFrames
df = df.append(df2, ignore_index=True)

df = df.reindex()
df.index += 1  # start index at 1, not 0

# Save a DataFrame into a csv file
# df.to_csv('filename.csv')

print(df)