import
pandas as pd
import
re
movie_data
=
[
"Name: The_Godfather Year: 1972 Rating: 9.2"
,
"Name: Bird_Box Year: 2018 Rating: 6.8"
,
"Name: Fight_Club Year: 1999 Rating: 8.8"
]
movies
=
{
"Name"
:[],
"Year"
:[],
"Rating"
:[]}
for
item
in
movie_data:
name_field
=
re.search(
"Name: .*"
,item)
if
name_field
is
not
None
:
name
=
re.search(
'\w*\s\w*'
,name_field.group())
else
:
name
=
None
movies[
"Name"
].append(name.group())
year_field
=
re.search(
"Year: .*"
,item)
if
year_field
is
not
None
:
year
=
re.search(
'\s\d\d\d\d'
,year_field.group())
else
:
year
=
None
movies[
"Year"
].append(year.group().strip())
rating_field
=
re.search(
"Rating: .*"
,item)
if
rating_field
is
not
None
:
rating
=
re.search(
'\s\d.\d'
,rating_field.group())
else
:
rating
-
None
movies[
"Rating"
].append(rating.group().strip())
df
=
pd.DataFrame(movies)
print
(df)