Pandas Open CSV在Linux下运行良好,但在m中不行

2024-06-25 23:01:04 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在读取一个.csv文件,该文件如下所示:

Rank,Full Journal Title,JCR Abbreviated Title,ISSN,Total Cites,Journal Impact Factor,Impact Factor without Journal Self Cites,5-Year Impact Factor,Immediacy Index,Citable Items,Cited Half-Life,Citing Half-life,Eigenfactor Score,Article Influence Score,% Articles in Citable Items,,Average Journal Impact Factor Percentile,Normalized Eigenfactor
8,Agronomy for Sustainable Development,AGRON SUSTAIN DEV,1774-0746,"2,842",4.101,3.747,4.746,0.455,66,4.9,7.7,0.005670,1.123,53.030,,84.182,0.65038
9,International Journal of Precision Engineering and Manufacturing-Green Technology,INT J PR ENG MAN-GT,2288-6206,329,3.494,2.719,3.494,0.375,48,2.1,6.1,0.001140,0.888,87.500,,83.060,0.13037

我的代码如下:

^{pr2}$

我在Ubuntu桌面上使用Python2.7,一切正常。然而,当我在MacBookPro中运行完全相同的代码时,它就不起作用了。我的macbook的输出是:

[IN]: raw_data.iloc[8]
[OUT]:
Rank                                                                                        
9
Full Journal Title                          International Journal of 
Precision Engineering...
JCR Abbreviated Title                                                     
INT J PR ENG MAN-GT
ISSN                                                                                
2288-6206
Total Cites                                                                               
329
Journal Impact Factor                                                                   
3.494
Impact Factor without Journal Self Cites                                                
2.719
5-Year Impact Factor                                                                    
3.494
Immediacy Index                                                                         
0.375
Citable Items                                                                              
48
Cited Half-Life                                                                           
2.1
Citing Half-life                                                                          
6.1
Eigenfactor Score                                                                     
0.00114
Article Influence Score                                                                 
0.888
% Articles in Citable Items                                                              
87.5
Unnamed: 15                                                                               
NaN
Average Journal Impact Factor Percentile                                                
83.06
Normalized Eigenfactor                                                                
0.13037

这很好,是预期的输出。但是,有些线路不起作用

[IN]: raw_data.iloc[9]
[OUT]:
Rank                                        10,JOURNAL OF INDUSTRIAL 
ECOLOGY,J IND ECOL,10...
Full Journal Title                                                                        
NaN
JCR Abbreviated Title                                                                     
NaN
ISSN                                                                                      
NaN
Total Cites                                                                               
NaN
Journal Impact Factor                                                                     
NaN
Impact Factor without Journal Self Cites                                                  
NaN
5-Year Impact Factor                                                                      
NaN
Immediacy Index                                                                           
NaN
Citable Items                                                                             
NaN
Cited Half-Life                                                                           
NaN
Citing Half-life                                                                          
NaN
Eigenfactor Score                                                                         
NaN
Article Influence Score                                                                   
NaN
% Articles in Citable Items                                                               
NaN
Unnamed: 15                                                                               
NaN
Average Journal Impact Factor Percentile                                                  
NaN
Normalized Eigenfactor                                                                    
NaN

为什么我的代码只能处理某些行而不能处理其他行??我在Ubuntu中没有这个问题。。。我怎么解决这个问题?????在

谢谢你!在


Tags: titleitemsnanfulljournalscorefactorrank