Практическое занятие №50

Практическое занятие №50 (1И)

Тема: Объекты Series и DataFrame

Цель работы: формирование теоретических и практических навыков работы на языке программирования Python

Оборудование: компьютер с установленной операционной системой Windows, подключение к сети Интернет

Время работы 2 часа

Ход работы

Задание 1

# Import pandas library

import pandas as pd

# initialize list of lists

data = [[1, 5, 10], [2, 6, 9], [3, 7, 8]]

# Create the pandas DataFrame

df = pd.DataFrame(data)

# specifying column names

df.columns = ['Col_1', 'Col_2', 'Col_3']

# print dataframe.

print(df, "\n")

# transpose of dataframe

df = df.transpose()

print("Transpose of above dataframe is-\n", df)

Задание 2

# import pandas to use pandas DataFrame

import pandas as pd

# data in the form of list of tuples

data = [('Peter', 18, 7),

        ('Riff', 15, 6),

    ('John', 17, 8),

    ('Michel', 18, 7),

    ('Sheli', 17, 5) ]

# create DataFrame using data

df = pd.DataFrame(data, columns =['Team', 'Age', 'Score'])

a = df.pivot('Team', 'Score','Age')

print(a)

Задание 3

# Python program to convert list of nested

# dictionary into Pandas dataframe

# importing pandas

import pandas as pd

# List of list of dictionary initialization

list = [

        {

        "Student": [{"Exam": 90, "Grade": "a"},

                    {"Exam": 99, "Grade": "b"},

                    {"Exam": 97, "Grade": "c"},

                ],

        "Name": "Paras Jain"

        },

        {

        "Student": [{"Exam": 89, "Grade": "a"},

                    {"Exam": 80, "Grade": "b"}

                ],

        "Name": "Chunky Pandey"

        }

    ]

# rows list initialization

rows = []

# appending rows

for data in list:

    data_row = data['Student']

    time = data['Name']

    for row in data_row:

        row['Name']= time

        rows.append(row)

# using data frame

df = pd.DataFrame(rows)

# using pivot_table

df = df.pivot_table(index ='Name', columns =['Grade'],

                        values =['Exam']).reset_index()

# Defining columns

df.columns =['Name', 'Maths', 'Physics', 'Chemistry']

# print dataframe

print(df)

Задание 4

# Importing Pandas library

import pandas as pd

# Creating two lists

author = ['Jitender', 'Purnima',

          'Arpit', 'Jyoti']

article = [210, 211, 114, 178]

# Creating two Series by passing lists

auth_series = pd.Series(author)

article_series = pd.Series(article)

# Creating a dictionary by passing Series objects as values

frame = {'Author': auth_series,

         'Article': article_series}

# Creating DataFrame by passing Dictionary

result = pd.DataFrame(frame)

# Printing elements of Dataframe

print(result)

Задание 5

# Importing pandas library

import pandas as pd

# Creating Series

auth_series = pd.Series(['Jitender',

          'Purnima', 'Arpit', 'Jyoti'])

article_series = pd.Series([210, 211, 114, 178])

# Creating Dictionary

frame = {'Author': auth_series,

         'Article': article_series}

# Creating Dataframe

result = pd.DataFrame(frame)

# Creating another list

age = [21, 21, 24, 23]

# Creating new column in the dataframe by

# providing s Series created using list

result['Age'] = pd.Series(age)

# Printing dataframe

print(result)