Conversion of csv Lens files

A widely used tool for visual exploration of scientific literature.

Brought to you by: citespace

Conversion of csv Lens files

Forum: General Discussion

Creator: Glib Voloskyi

Created: 2021-04-26

Updated: 2021-04-30

Glib Voloskyi - 2021-04-26

I find out that removing of "s from a file, as suggested by the manual, tend to decrease the successful rate of the conversion of csv Lens datasets. Citespace converts files much more successfully without the removal of quotation marks from a dataset.
The image 1 is the results of the conversion with removed "s - the successful rate is 31%.
The image 2 is the same dataset with " marks. The successful rate is 97%.
The results persist across multiple datasets that I tested.

Last edit: Glib Voloskyi 2021-04-26

image 1.png

image 2.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Chaomei Chen - 2021-04-30
  
  Thanks for the comparison. I will double check and update the instructions accordingly.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Stephan De Spiegeleire - 2021-04-30

Let me also add that Glib tried this both in Excel and in a regular text-editor. And in both cases, NOT removing the "s was (by far) the superior solution. So I'm not sure why this step was added in the instructions in the first place (and whether there might still be use cases where this yields better results) , but our team tried this on various datasets and in all of them not replacing them was the way to go.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.