import pandas as pd
import numpy as np

# Creating Series:
s1 = pd.Series([1.0, 2.0, 3.0], name='A')
s2 = pd.Series([4.0, 5.0, 6.0], name='B')

# Creating a DataFrame: 
df = pd.concat([s1, s2], axis=1)

# Calculate the mean column wise:
mc = df.mean()
print('mean column-wise =', mc, '\n')

# Calculate the mean row-wise:
mr = df.mean(axis = 1)
print('mean row-wise =', mr, '\n')

# Calulate the sum column-wise:
sc = df.sum()
print('sum column-wise =', sc, '\n')

# Calulate the sum row-wise:
sr = df.sum(axis = 1)
print('sum row-wise =', sr, '\n')

# Cumulative sum column-wise:
cc = df.cumsum()
print('cumulative sum column-wise =', cc, '\n')

# Sort values in column A from largest to smallest:
sorted = df.sort_values(by = 'A')
print('sorted large-small:', sorted, '\n')

# Basic statsistics column-wise:
stat = df.describe()
print('basic stats column-wise:', stat, '\n')