Mr.Jo Jo found that "tweetid, created-at and username" columns are sensitive thus decided to mask the values from those columns. He created new columns "new- tweet-id","created-at4" to store the masked “tweet-ids" and masked "created-at" values. He decided to use "username" column to store masked usernames. Now, analyze the following output figure to do essential mask operations. new_tweet_id created_at4 username O 301767309855683251 Wednesday/February/16 yyy 1 041287076781383229 Tuesday/February/16 yyy 2 170242984208083188 Monday/February/16 yyy 3 346316860619394606 Tuesday/December/16 yyy 4 994889748559394597 Tuesday/December/16 yyy 5 267857845400294597 Tuesday/December/16 yyy 6 900486039855694560 Monday/December/16 yyy 7 876166652354594559 Monday/December/16 yyy 8 244167927104594559 Monday/December/16 yyy 9 478403164894494430 Thursday/December/16 yyy

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

What's the python code for this

Mr.Jo Jo found that "tweetid, created-at and username" columns are sensitive thus
decided to mask the values from those columns. He created new columns "new-
tweet-id","created-at4" to store the masked "tweet-ids" and masked "created-at"
values. He decided to use "username" column to store masked usernames.
Now, analyze the following output figure to do essential mask operations.
new_tweet_id
created_at4 username
0 301767309855683251 Wednesday/February/16
yyy
1 041287076781383229
Tuesday/February/16
yyy
2 170242984208083188
Monday/February/16
yyy
3 346316860619394606
Tuesday/December/16
yyy
4 994889748559394597
Tuesday/December/16
yyy
5 267857845400294597
Tuesday/December/16
yyy
6 900486039855694560
Monday/December/16
yyy
7 876166652354594559
Monday/December/16
yyy
8 244167927104594559
Monday/December/16
yyy
9 478403164894494430
Thursday/December/16
yyy
Transcribed Image Text:Mr.Jo Jo found that "tweetid, created-at and username" columns are sensitive thus decided to mask the values from those columns. He created new columns "new- tweet-id","created-at4" to store the masked "tweet-ids" and masked "created-at" values. He decided to use "username" column to store masked usernames. Now, analyze the following output figure to do essential mask operations. new_tweet_id created_at4 username 0 301767309855683251 Wednesday/February/16 yyy 1 041287076781383229 Tuesday/February/16 yyy 2 170242984208083188 Monday/February/16 yyy 3 346316860619394606 Tuesday/December/16 yyy 4 994889748559394597 Tuesday/December/16 yyy 5 267857845400294597 Tuesday/December/16 yyy 6 900486039855694560 Monday/December/16 yyy 7 876166652354594559 Monday/December/16 yyy 8 244167927104594559 Monday/December/16 yyy 9 478403164894494430 Thursday/December/16 yyy
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Intermediate SQL concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education