pandas Example Cod

Exercise 1: Write a pandas program to create and display a one-dimensional array-like object containing an array of data.

Solution:

import pandas as pd

ds = pd.Series([2, 4, 6, 8, 10])

print(ds)

Exercise 2: Find the index of the first occurrence of the smallest and largest value of a given series

Solution:

import pandas as pd

nums = pd.Series([1, 3, 7, 12, 88, 23, 3, 1, 9, 0])

print("Original Series:")

print(nums)

print("Index of the first occurrence of the smallest and largest value of the said series:")

print(nums.idxmin())

print(nums.idxmax())

Exercise 3: Create a line plot of one column versus another column

Solution:

import pandas as pd

import matplotlib.pyplot as plt

df = pd.read_csv("alphabet_stock_data.csv")

start_date = pd.to_datetime('2020-4-1')

end_date = pd.to_datetime('2020-09-30')   

                      

df['Date'] = pd.to_datetime(df['Date']) 

new_df = (df['Date']>= start_date) & (df['Date']<= end_date)

df1 = df.loc[new_df]

df2 = df1.set_index('Date')

plt.figure(figsize=(5,5))

plt.suptitle('Stock prices of Alphabet Inc.,\n01-04-2020 to 30-09-2020', \

                 fontsize=18, color='black')

plt.xlabel("Date",fontsize=16, color='black')

plt.ylabel("$ price", fontsize=16, color='black')

 

df2['Close'].plot(color='green')

plt.show()