我現在的代碼如下所示:
def read_in_movie_preference():
"""Read the move data, and return a
preference dictionary."""
preference = {}
movies = []
# write code here:
file_location="./data/"
f = open(file_location "preference.csv","r")
df = f.readlines()
#names as keys and prefrences
for line in df:
name = line[1].strip("\n").split(",")
prefs = line[2:].strip("\n").split(",")
preference[line[1]] = line[2:]
#print(test)
#movie names`
movietitles = df[0].strip("\n").split(",")
for movie in movietitles:
movie=movie.rstrip()
#can't seem to get rid of the spaces at the end
movies =movietitles[2:]
print(movies)
return [movies, preference]
我似乎無法將電影片名放入串列中,其中一些片尾沒有空格,我也無法將名稱和首選項添加到字典中......我應該用基本的 python 來完成這個任務,沒有大熊貓..非常困將不勝感激任何幫助!
字典將名稱作為鍵和數字格式的偏好數字而不是字串,因此理論上它看起來像這樣:key: pref: dennis, 0 1 0 1 0 ect
這就是資料集的樣子
這是粘貼的資料:
Timestamp,Please fill in your name. (You can also use an alias name). ,The Shawshank Redemption,The Godfather,The Dark Knight ,Star Wars: The Force Awakens,The Lord of the Rings: The Return of the King,Inception,The Matrix ,Avengers: Infinity War ,Interstellar ,Spirited Away,Coco,The Dark Knight Rises,Braveheart,The Wolf of Wall Street,Gone Girl ,La La Land,Shutter Island,Ex Machina,The Martian,Kingsman: The Secret Service
9/30/20 17:04,Test Student Long Name,0,0,1,1,0,1,0,1,1,1,0,0,0,1,0,0,0,0,1,0
9/30/20 9:53,Test Student,0,0,1,1,-1,0,0,1,1,1,0,0,0,1,0,0,0,0,0,0
9/30/20 9:53,Jiaxu Rong,1,1,1,0,0,0,1,1,1,1,1,1,0,1,0,1,0,0,1,1
9/30/20 9:53,Trevor,1,1,1,0,0,1,1,0,1,-1,0,1,0,0,0,0,0,0,1,0
9/30/20 9:53,Guokai,0,0,1,0,1,0,0,1,0,0,1,-1,0,1,0,1,0,0,0,1
9/30/20 9:54,Yanzhang Cao,0,-1,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0
9/30/20 9:54,Kongliang Chen,0,0,1,0,1,0,0,1,0,0,1,1,0,1,0,1,0,0,0,1
9/30/20 9:54,Jason,1,0,1,0,-1,1,0,1,1,0,0,1,1,1,-1,0,0,0,-1,1
9/30/20 9:54,Q,0,1,-1,0,1,1,1,0,0,1,0,0,0,1,1,0,1,1,0,1
9/30/20 9:55,Eric,1,1,1,1,1,1,1,1,0,1,0,1,1,1,0,0,1,1,1,1
9/30/20 9:55,Elaine Jiang,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0
9/30/20 9:55,Songqi Fan,1,0,1,1,1,0,0,1,1,0,1,1,0,1,0,1,0,0,0,0
9/30/20 9:55,Jacob Scheinman,1,1,1,1,1,1,1,1,-1,0,1,1,0,1,0,0,0,0,1,1
9/30/20 9:56,Ziyi Qian,0,0,0,1,1,1,0,1,1,0,1,0,0,0,0,0,1,0,1,1
9/30/20 9:56,Huanyue Liao,1,-1,-1,1,1,1,1,-1,0,1,1,0,1,0,0,0,1,0,0,-1
9/30/20 9:56,Yitong,0,0,0,-1,0,1,0,0,1,1,1,0,0,0,0,-1,0,0,1,1
9/30/20 9:56,qimeng luo,1,1,1,0,0,0,0,1,1,1,1,1,0,1,0,-1,-1,-1,1,-1
9/30/20 9:59,Haijian Huang,1,1,0,0,0,1,0,-1,1,1,1,0,0,1,0,1,0,0,-1,1
9/30/20 9:59,Yunong Tian,0,1,0,0,1,1,1,1,1,1,0,0,1,1,1,0,1,0,1,1
9/30/20 10:00,Dennis Zhang,1,0,1,1,0,1,1,1,1,1,0,1,0,0,0,0,0,1,1,0
9/30/20 10:00,Ricky Gui,1,1,1,0,1,1,1,1,1,1,1,1,0,1,0,1,1,0,1,1
9/30/20 10:01,Harry You,0,0,0,0,0,1,1,1,0,0,1,0,0,0,0,0,0,0,0,1
9/30/20 10:02,Mingda Huang,0,0,1,0,0,1,1,1,1,1,1,1,1,1,0,0,1,0,1,1
9/30/20 10:02,Robert Chen,0,0,-1,-1,-1,1,1,1,1,1,0,-1,0,1,1,1,1,1,1,1
9/30/20 10:04,Elsa Wang,1,1,1,1,0,1,1,1,0,-1,0,1,0,1,0,-1,1,0,-1,1
9/30/20 10:06,Hao,1,1,0,0,1,1,1,0,1,1,1,0,1,1,-1,1,-1,0,1,1
9/30/20 10:31,Nobody,0,0,0,0,1,-1,0,0,0,1,0,0,0,1,0,1,0,0,0,0
9/30/20 14:02,Devlin Sullivan,1,1,1,0,0,1,0,-1,0,1,0,1,0,1,1,0,1,0,1,0
9/30/20 14:03,Michael Blau,1,0,1,0,-1,1,0,1,1,0,0,1,0,1,0,1,0,1,1,1
9/30/20 14:04,Grace,0,0,0,1,-1,0,0,1,0,1,1,0,0,1,1,1,0,0,0,0
9/30/20 14:04,Sam Andelman,1,1,1,-1,1,1,1,1,1,0,0,1,0,1,0,0,0,0,1,1
9/30/20 14:06,Liza Fried ,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,0,0,0,0
9/30/20 14:07,Kelsey ,1,0,-1,0,0,1,0,0,1,1,0,0,0,1,-1,1,0,0,0,0
9/30/20 14:07,Lucas,0,0,0,1,1,1,1,1,1,0,1,0,0,1,0,0,0,0,1,1
9/30/20 14:09,Vi Krstic,0,0,0,0,0,1,1,0,1,1,1,0,-1,1,1,0,0,-1,0,1
9/30/20 14:10,Andrew,1,0,1,-1,-1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,1
9/30/20 14:20,Kiri ,1,-1,1,1,1,0,0,1,1,1,0,1,0,1,0,1,0,0,0,1
9/30/20 14:29,ag,0,0,1,0,-1,1,1,1,1,0,0,1,0,1,0,0,0,1,1,1
9/30/20 14:32,Joe Stover,1,1,1,0,0,1,0,-1,0,0,1,1,0,1,0,1,0,1,1,0
9/30/20 16:10,Joe Stover,1,1,1,0,0,1,0,-1,0,0,1,1,0,1,0,1,0,1,1,0
9/30/20 16:39,Gary,1,0,1,0,1,1,0,1,1,0,0,1,0,1,0,0,-1,0,1,0
9/30/20 16:42,Michael Yin,1,0,1,0,0,0,1,1,0,0,0,1,-1,1,0,0,0,0,0,0
9/30/20 16:51,Julia Chandonnet,0,1,-1,-1,-1,1,1,1,1,0,0,0,0,0,1,1,0,0,1,0
9/30/20 17:04,Michael Treiber,0,0,1,1,0,1,0,1,1,1,0,0,0,1,0,0,0,0,1,0
9/30/20 17:50,Joanna Lycroft,0,1,1,1,1,1,1,1,1,1,0,-1,0,-1,0,1,0,1,1,0
9/30/20 18:18,Jared Fong,1,1,1,1,0,1,1,1,1,0,-1,1,0,1,0,0,1,-1,1,0
9/30/20 18:23,Nolan Stafford,1,1,1,1,1,1,1,1,1,0,1,1,0,1,0,0,1,0,1,1
9/30/20 20:02,kailin shi,1,0,1,-1,0,0,1,0,0,1,1,1,1,1,1,1,0,0,0,0
9/30/20 20:02,Grant,1,-1,1,-1,1,0,0,1,0,1,1,1,1,1,0,1,0,0,0,1
9/30/20 20:02,Cathy Xie,0,1,0,0,0,1,1,-1,1,0,1,1,1,1,0,1,0,0,0,1
9/30/20 20:03,Honghua Su,1,0,1,1,1,0,1,1,1,1,1,1,1,0,0,1,0,0,-1,1
9/30/20 20:03,Bryan Peltier,1,1,1,-1,0,1,0,1,1,0,0,1,1,0,0,0,0,0,1,1
9/30/20 20:04,Yueqi Qian,0,1,0,1,0,1,0,1,1,0,-1,0,0,1,0,0,0,0,0,0
9/30/20 20:05,Feier Li,1,1,0,1,1,1,0,-1,0,1,1,0,1,0,-1,1,0,0,0,-1
9/30/20 20:05,Zhixin Liu,-1,-1,-1,1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,1,1,-1,-1,-1,-1
9/30/20 20:06,jasmine,0,0,0,0,0,0,0,1,1,1,0,0,0,0,1,0,1,0,1,1
9/30/20 20:06,Chang Mu,1,1,1,0,1,1,0,1,1,0,1,0,0,0,0,1,0,0,0,1
9/30/20 20:08,Chen Wen,0,0,1,1,0,1,1,1,0,1,0,0,0,0,-1,0,0,0,0,1
9/30/20 20:11,zirui zhu,1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1
9/30/20 20:12,Yutao Jiang,1,0,1,1,1,1,1,1,1,1,1,1,0,1,0,0,1,1,1,1
9/30/20 20:13,Bo,1,0,1,0,0,1,0,1,0,-1,1,1,0,1,1,0,1,0,0,1
9/30/20 20:30,Antonia Weng,1,-1,0,0,1,1,1,1,-1,1,1,0,0,0,1,-1,-1,0,0,1
9/30/20 20:33,Sean Peng,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,1,0,0,1,0
9/30/20 20:36,Geeeee,1,1,1,1,1,0,0,1,0,0,0,1,1,1,0,1,0,0,0,1
9/30/20 20:37,Peyton Wilson,1,0,1,-1,1,1,1,1,1,-1,0,1,0,1,0,0,1,1,1,1
9/30/20 20:41,Qihong Li ,1,0,1,0,1,1,0,0,0,1,1,1,0,0,0,0,0,0,1,0
9/30/20 20:44,Cathy Xie,0,1,0,0,0,1,1,-1,1,0,1,1,1,1,0,1,0,0,0,1
9/30/20 21:02,Haochen Zhou,1,1,1,1,0,0,1,1,0,0,0,1,0,1,0,1,0,0,1,1
9/30/20 21:15,Emma,0,0,1,0,1,0,0,1,-1,0,1,1,0,1,-1,0,0,0,1,0
9/30/20 21:15,Thomas,1,-1,1,-1,1,1,1,1,-1,-1,-1,1,1,1,-1,-1,-1,-1,-1,-1
9/30/20 21:18,Aurora Chen,1,0,0,0,0,1,0,1,1,1,1,0,0,-1,1,-1,0,0,0,1
9/30/20 21:21,Nexus7,1,1,1,-1,1,0,1,1,0,1,1,1,0,1,1,0,0,-1,0,1
9/30/20 21:22,Joy Hou,0,0,-1,0,1,1,0,1,1,1,1,1,0,0,1,0,1,0,0,1
9/30/20 21:23,Yuheng Zhuo,1,0,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1
9/30/20 21:24,Yitsukii,1,1,0,0,1,1,1,-1,1,1,1,-1,1,0,0,1,0,0,1,0
9/30/20 21:26,Baiyu Chen,0,1,0,0,0,0,1,-1,1,0,1,0,1,1,0,1,0,0,0,1
9/30/20 21:27,Tiffany,1,0,0,1,0,0,0,1,1,1,1,0,0,0,0,1,0,0,0,1
9/30/20 21:29,Xul,1,0,1,-1,1,1,1,0,1,1,0,0,-1,1,1,1,1,0,1,0
9/30/20 21:32,xianxian,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0
9/30/20 21:33,Vicky,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0
9/30/20 21:34,Marilyn,0,1,0,0,1,0,1,0,0,-1,1,0,0,0,0,1,0,0,0,0
9/30/20 21:49,Albert Kao,0,0,0,1,0,0,0,1,1,0,1,0,0,1,0,1,0,0,0,0
9/30/20 21:50,Sahil Rastogi,0,1,1,1,1,-1,0,1,1,-1,1,1,1,0,0,-1,0,0,1,1
9/30/20 21:52,Tianyu Wu,1,0,0,0,1,0,0,0,0,0,0,-1,1,1,1,1,0,1,-1,1
9/30/20 21:59,Sarah Chang,1,0,0,-1,0,1,0,1,-1,1,1,1,0,0,-1,1,0,0,1,1
9/30/20 22:11,Andy Mu,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1
9/30/20 22:38,Avatar,0,1,1,0,0,-1,-1,1,-1,0,1,1,0,1,0,0,0,0,0,0
9/30/20 22:48,Nolan Stafford,1,1,1,1,1,1,1,1,1,0,1,1,0,1,0,0,1,0,1,1
9/30/20 23:17,Daiying Wu,1,0,0,0,1,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0
9/30/20 23:18,Fengnian Zhou,1,-1,1,-1,-1,1,1,-1,1,1,1,1,-1,1,1,1,-1,1,1,1
9/30/20 23:50,Alex,1,0,1,0,0,1,1,1,1,1,1,1,0,1,1,0,1,-1,1,1
10/1/20 0:05,DJZ2,0,1,0,-1,1,1,0,1,0,0,1,0,0,-1,0,1,0,0,0,0
10/1/20 1:01,Honghua Su,1,0,1,1,1,0,1,1,1,1,1,1,1,0,0,1,0,0,-1,1
10/1/20 1:03,Kelsey ,1,0,-1,0,0,1,0,0,1,1,0,0,0,1,-1,1,0,0,0,0
10/1/20 1:51,xingxu,0,1,0,0,0,0,1,1,0,1,0,0,0,-1,0,0,1,-1,-1,1
10/1/20 3:51,Yujia Zhang,1,1,1,1,1,0,-1,1,1,-1,-1,1,1,-1,-1,-1,0,-1,1,1
10/1/20 5:14,Connor Lotz ,0,0,1,1,0,0,0,1,0,0,0,1,0,1,0,0,0,0,1,1
10/1/20 5:39,Tianyi Liu,1,1,1,0,0,1,0,1,0,1,0,1,0,1,0,1,1,0,1,0
10/1/20 8:32,Haoyuan Tan,0,0,1,0,1,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0
10/1/20 9:47,Digmel ,0,0,1,1,0,0,-1,1,1,0,1,1,0,1,0,0,1,1,-1,1
10/1/20 10:25,Rhea Pillai,1,0,1,0,0,1,0,1,1,0,0,1,0,0,0,0,0,0,0,1
10/1/20 10:49,Monica,0,0,0,0,0,1,1,-1,1,1,1,0,0,1,0,-1,0,0,0,0
10/1/20 11:36,Kun Yu,1,0,1,0,0,0,1,0,1,1,1,1,0,0,0,0,0,0,1,1
10/1/20 12:37,Rahul Parthasarathy,1,0,1,1,1,1,0,1,1,0,0,1,0,1,0,0,0,0,1,1
10/1/20 13:31,vivi,1,0,1,1,1,1,1,1,1,1,0,1,1,0,0,0,1,0,1,1
10/1/20 13:51,Imani,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0
10/1/20 16:00,Henry Singer,1,1,1,1,0,1,1,1,1,0,0,1,0,1,0,0,1,0,1,1
10/1/20 16:32,Juliana Beal,0,1,0,0,-1,0,0,0,-1,0,1,0,0,0,0,1,0,0,0,0
10/1/20 16:38,Juncen Yu,-1,0,1,1,1,0,0,-1,1,1,1,1,0,-1,0,0,0,0,1,1
10/1/20 21:43,Yizhou,1,1,1,1,1,1,1,1,1,0,0,1,0,1,1,-1,1,0,1,1
10/1/20 22:52,Nora,1,0,0,0,-1,0,0,1,0,1,1,0,0,0,0,1,0,0,1,0
10/2/20 3:33,Yufei,0,0,0,0,1,1,0,1,1,1,1,0,0,0,0,1,0,0,0,1
10/2/20 9:57,Shaowen Ni,1,1,1,-1,0,1,1,1,-1,0,-1,1,1,1,1,1,1,0,0,1
10/2/20 10:45,Xuan Li,0,0,-1,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1
10/2/20 11:54,Jarrett Dykema,1,1,1,1,1,1,0,1,1,-1,0,1,1,1,1,0,1,1,1,1
10/2/20 18:42,Emma,0,0,1,0,1,0,0,1,-1,0,1,1,0,1,-1,0,0,0,1,0
10/2/20 20:03,Agam,0,0,1,0,0,1,0,1,1,0,1,1,0,1,0,0,1,1,0,0
10/2/20 23:15,Matt LaVersa,0,0,1,-1,1,1,1,1,1,0,0,1,0,0,0,1,0,1,1,0
10/2/20 23:40,Lingyi Ye,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,-1,0,0,0,0
10/3/20 7:37,Crystal,1,0,1,0,0,1,1,1,1,0,1,1,0,0,1,1,0,0,0,0
10/3/20 9:25,Anthony Conti,1,1,1,1,1,1,1,1,1,0,0,1,1,1,0,0,1,1,1,1
10/3/20 10:09,Sen Zhu,0,0,0,1,-1,0,0,-1,0,1,0,-1,0,-1,0,0,0,0,0,0
10/3/20 13:11,Lujiang Chen,0,0,1,1,1,1,1,1,1,1,1,1,0,1,1,0,1,1,1,1
10/3/20 15:57,Katie,0,1,-1,-1,0,0,1,0,1,0,-1,0,0,1,1,1,0,0,0,0
10/3/20 18:17,Jack S. ,1,1,1,-1,1,1,1,0,0,1,0,1,-1,1,1,1,1,1,1,1
10/3/20 19:50,Elizabeth A.,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,-1,0,0,0,0
10/3/20 20:42,Crystal,1,0,1,0,0,1,1,1,1,0,1,1,0,0,1,1,0,0,0,0
10/4/20 1:07,Jason,1,0,1,1,1,1,1,1,1,1,1,1,0,1,0,0,0,0,1,0
10/4/20 2:17,Lizz Cao,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0
10/4/20 6:14,Minglun Yin,1,0,0,1,1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0
10/4/20 7:11,Tracy,0,0,-1,1,0,0,0,1,0,0,1,-1,0,1,-1,1,-1,0,0,1
10/4/20 9:51,Zhongkun Guo,1,1,1,0,1,1,0,1,1,1,0,1,0,-1,1,1,0,0,0,-1
10/4/20 13:19,Matthew Yang,0,-1,-1,1,0,1,0,1,0,1,1,1,0,-1,0,0,0,0,1,1
10/4/20 15:45,Beth,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0
10/4/20 18:42,Maya ,0,0,0,1,0,0,0,1,0,-1,1,0,0,0,0,1,0,0,0,0
10/4/20 19:09,Yifan He,1,1,1,-1,1,1,1,1,1,1,1,1,0,1,0,0,0,0,1,1
10/4/20 21:40,Ziqing Ouyang,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,1,0,0,0,1
10/5/20 0:10,Johnnie Teng,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0
10/5/20 0:34,shaohua,1,1,1,0,1,1,1,1,1,1,1,1,0,0,1,0,1,0,1,1
10/5/20 5:16,Yuchen,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1
10/5/20 8:24,Jingze Huang,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
10/5/20 18:42,Sara,1,1,0,0,0,1,0,0,1,1,0,0,1,0,0,-1,1,0,1,0
10/5/20 19:49,Duoyuan Wang,0,0,1,-1,0,1,-1,1,1,1,1,-1,0,0,0,0,0,0,-1,0
10/5/20 21:39,Spencer,0,1,1,1,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0
10/5/20 22:28,Spencer,0,1,1,1,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0
10/6/20 2:02,Spencer,0,1,1,1,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0
10/6/20 12:34,Chance Bayles ,1,0,1,-1,-1,1,1,-1,1,1,0,1,1,1,1,1,-1,-1,1,-1
10/6/20 13:03,Jackson Brodwolf,1,0,1,0,-1,1,0,1,1,-1,-1,1,0,1,1,0,1,-1,1,1
10/6/20 13:42,Lauren,0,0,0,0,0,0,0,1,-1,0,1,0,0,0,0,1,0,0,1,1
10/6/20 20:37,Steve,0,1,0,1,1,1,1,1,0,0,0,0,1,1,0,0,0,1,0,0
10/6/20 21:38,Claire Huang,1,-1,-1,-1,-1,1,-1,-1,-1,1,1,-1,-1,1,-1,1,-1,-1,-1,-1
10/6/20 21:39,Alexander Hazel,1,0,1,1,0,1,1,1,1,0,1,1,0,1,1,1,0,0,1,1
10/6/20 23:12,Joanne Lin,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,1,0,0,0,0
10/6/20 23:45,Jared Katzelnick,1,0,1,-1,0,1,0,1,1,0,1,1,0,1,0,0,0,0,1,1
10/7/20 11:16,Kati,0,0,-1,-1,-1,1,1,0,-1,1,1,-1,1,1,1,1,1,0,0,0
10/7/20 11:59,Ty,1,1,1,1,0,1,0,1,1,0,0,1,1,1,0,1,1,0,1,1
10/7/20 13:58,Chang Mu,1,1,1,0,1,1,0,1,1,0,1,0,0,0,0,1,0,0,0,1
10/9/20 21:40,Ziqing Ouyang,0,0,1,0,0,1,1,1,0,0,0,0,0,0,0,1,0,0,0,1
10/7/20 13:42,Lauren,1,0,0,0,0,0,0,1,-1,0,1,0,0,0,0,1,0,0,1,1
10/9/20 21:39,Spencer,1,1,1,1,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0
uj5u.com熱心網友回復:
所以這里的問題是您正在使用rstrip資料的副本,但從未將其應用于原始資料。
問題
for movie in movietitles:
movie=movie.rstrip() # Changes the (copy) of the data rather than the original
# We still need to apply this back to movietitles
有幾種方法可以解決這個問題!
# Using indexing
for _ in range(len(movietitles)):
movietitles[_] = movietitles[_].rstrip()
或者我們可以行內串列理解來執行此操作
# Using list comprehension
movietitles = [movie.rstrip() for movie in movietitles]
正如另一個答案中所述,在處理 csv 資料時,建議使用 csv 決議器,但對于這種規模完全沒有必要!希望這可以幫助
uj5u.com熱心網友回復:
您需要為此使用適當的 csv 決議器。
from csv import DictReader
with open('preferences.json') as file: # replace your file path here
for row in DictReader(file):
print(row)
輸出(為簡潔起見裁剪了一些值)
{'Timestamp': '10/9/20 21:39',
'Please fill in your name. (You can also use an alias name). ': 'Spencer',
'The Shawshank Redemption': '1',
'The Godfather': '1',
'The Dark Knight ': '1',
'Star Wars: The Force Awakens': '1',
'The Lord of the Rings: The Return of the King': '0',
'Inception': '0',
'The Matrix ': '0',
'Avengers: Infinity War ': '1',
'Interstellar ': '0',
'Spirited Away': '0',
'Coco': '0',
'The Dark Knight Rises': '1',
'Braveheart': '0',
'The Wolf of Wall Street': '1',
'Gone Girl ': '0',
'La La Land': '0',
'Shutter Island': '0',
'Ex Machina': '0',
'The Martian': '0',
'Kingsman: The Secret Service': '0'}
對于你想要的格式
from csv import DictReader
res = []
with open('preferences.json') as file:
for row in DictReader(file):
name = row.pop('Please fill in your name. (You can also use an alias name). ')
row.pop('Timestamp')
res.append({name: list(map(int, row.values()))})
print(res)
輸出(為簡潔起見裁剪了一些值)
[{'Lauren': [1, 0, 0, 0, 0, 0, 0, 1, -1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 1, 1]},
{'Spencer': [1, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0]}]
轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/334167.html
