原文連結 http://chenhao.space/post/b7b37f12.html
.csv to .tsv
這是一個CSV格式的檔案:
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIn5GcsQXYtJ3bm9CXldWYtlWPzNXZj9mcw1ycz9WL49zdaVnQuxEeBRFTsR2VZRHbyw0RoRlSEpUVKFTVVpERKVlS3VUVKJTVVp0VOZkVEZUVKVkSVpENVVlSHhGVKRkSVpUMVVlSEpUVKdXRVpkMVVlSX5UMRZHNyI2bShVZRlTeZBnQWx0bOJDT0ljMZVXUXRmd4JTW4xGWiV3YtJGcwdVYsp0VMdnRtxke5ITW1dGRNhXSU50dBRUT6VEVMZnRHFWdWdUYqlTeMZTTINGMShUYvwlbj5yZtlmbkN3YuQnclZnbvN2Ztl2Lc9CX6MHc0RHaiojIsJye.jpg)
我想要提取出表頭為rating和comment的資料,并且轉為tsv(每一列以\t分隔)格式。
import pandas
path = './MovieRatings.csv'
pd_all = pd.read_csv(path)
pd_all.to_csv('./MOVIE.tsv', sep='\t, header=None, index=False, columns=["rating", "comment"], mode="w")