Answers.Body: <p>PGN files aren't databases, they're just lists of games. It's an exchange format, not a database format.</p>
  
  <p>You can load them into a real database, like Scid or Chessbase. Those have their own internal representation of chess games that is separate from PGN. If the same move can be written in several ways, they'll all be interpreted the same way by the database software when it reads the PGN.</p>
  
  <p>Database software is probably better for doing analysis than working with raw PGN files too.</p>
  
  <p>Alternatively, if you really want PGN files, import them into a Scid database and then export them to PGN again, that should make them consistent.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-14T22:08:22.553Z
Answers.LastActivityDate: 2017-12-14T22:14:45.533Z
Answers.LastEditDate: 2017-12-14T22:14:45.533Z
Answers.UserDisplayName: RemcoGerlich
Body: <p>I noticed that in the freely available TWIC databases (and perhaps in other databases as well) there are sometimes different notations for the same move. Just now I am looking at the Ruy Lopez where in some games white plays 6. <strong>Re1</strong> while in others it is <strong>Rfe1</strong> (which are of course the same move). Incidentally white scores much better with "Rfe1" ;-) Anyway having different notations for the same move makes reading the statistics (white win / draw/ black win) much harder.</p>
  
  <p>That's why I was wondering how to get rid of such problems in the database. Also what other ways are there to clean up the database (e.g. removing duplicate games, ....)?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-21T09:42:18.680Z
Comments.Text: Only Re1 is "correct" by most standards. I would expect that loading such a database into programs like ChessBase would automatically merge all Rfe1 games into the Re1 tree, and merge the scores as well.
Comments.UserDisplayName: TMM
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-12-14T08:33:51.580Z
Comments.Text: I found even Kd3 Rxd3 sequence in one twic :-)
Comments.UserDisplayName: hoacin
Tags: <database>
Title: Cleaning a database
ThreadText: # Cleaning a database
  
  (Asked by: username_0 on 2017-09-21)
  
  I noticed that in the freely available TWIC databases (and perhaps in other databases as well) there are sometimes different notations for the same move. Just now I am looking at the Ruy Lopez where in some games white plays 6. **Re1** while in others it is **Rfe1** (which are of course the same move). Incidentally white scores much better with "Rfe1" ;-) Anyway having different notations for the same move makes reading the statistics (white win / draw/ black win) much harder.
  
  That's why I was wondering how to get rid of such problems in the database. Also what other ways are there to clean up the database (e.g. removing duplicate games, ....)?
  
  **Tags:** database
  
  > **Comments:**
  > **username_1**: Only Re1 is "correct" by most standards. I would expect that loading such a database into programs like ChessBase would automatically merge all Rfe1 games into the Re1 tree, and merge the scores as well.  
  > **username_2**: I found even Kd3 Rxd3 sequence in one twic :-)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2017-12-14. Score: 1
  
  PGN files aren't databases, they're just lists of games. It's an exchange format, not a database format.
  
  You can load them into a real database, like Scid or Chessbase. Those have their own internal representation of chess games that is separate from PGN. If the same move can be written in several ways, they'll all be interpreted the same way by the database software when it reads the PGN.
  
  Database software is probably better for doing analysis than working with raw PGN files too.
  
  Alternatively, if you really want PGN files, import them into a Scid database and then export them to PGN again, that should make them consistent.
  
  
  ---
  
  