# Data from origo.hu

Reading a list of articles with pandas can be done with:

```py
FILENAME = 'articles_sample.json'

with open(FILENAME, encoding='utf-8') as f:
    df = pd.read_json(f, orient='records', convert_dates=['publishDate'])
```

`df.info()` for *articles_sample.json* gives:

```text
RangeIndex: 5000 entries, 0 to 4999
Data columns (total 50 columns):
 #   Column                        Non-Null Count  Dtype         
---  ------                        --------------  -----         
 0   id                            5000 non-null   object        
 1   contentType                   5000 non-null   object        
 2   preTitle                      38 non-null     object        
 3   isVideo                       5000 non-null   object        
 4   hasGallery                    5000 non-null   object        
 5   preTitleColor                 204 non-null    object        
 6   title                         5000 non-null   object        
 7   lead                          4797 non-null   object        
 8   chLead                        4831 non-null   object        
 9   chExcerpt                     4944 non-null   object        
 10  length                        4981 non-null   float64       
 11  publishDate                   5000 non-null   datetime64[ns]
 12  slug                          5000 non-null   object        
 13  columnSlug                    4963 non-null   object        
 14  columnTitle                   4963 non-null   object        
 15  columnOrder                   5000 non-null   object        
 16  columnEmphasizeOnArticleCard  4796 non-null   float64       
 17  recommendedTitle              4977 non-null   object        
 18  thumbnail                     4974 non-null   object        
 19  secondaryThumbnail            4953 non-null   object        
 20  columnTitleColor              0 non-null      float64       
 21  brand                         5000 non-null   object        
 22  articleSource                 929 non-null    object        
 23  firstTagId                    4793 non-null   object        
 24  firstRegionId                 0 non-null      float64       
 25  isPaywalled                   5000 non-null   int64         
 26  isAdultsOnly                  5000 non-null   bool          
 27  hasDossiers                   5000 non-null   bool          
 28  articleMedium                 204 non-null    object        
 29  priorityId                    4784 non-null   object        
 30  hideThumbnailFromBody         5000 non-null   int64         
 31  minuteToMinute                4796 non-null   object        
 32  difficulty                    0 non-null      float64       
 33  isMmeWarranty                 5000 non-null   int64         
 34  isMaestroAuthor               5000 non-null   int64         
 35  sentByUserId                  0 non-null      float64       
 36  facebookTitle                 0 non-null      float64       
 37  seoImage                      0 non-null      float64       
 38  magazineCover                 0 non-null      float64       
 39  podcastGuestName              0 non-null      float64       
 40  podcastGuestNameTitle         0 non-null      float64       
 41  isOpinionType                 4796 non-null   float64       
 42  isShortNewsType               4796 non-null   float64       
 43  isFastNewsType                4796 non-null   float64       
 44  isNotebook                    4796 non-null   float64       
 45  isPodcastType                 4796 non-null   float64       
 46  isGalleryType                 4796 non-null   float64       
 47  regions                       4796 non-null   object        
 48  tags                          4796 non-null   object        
 49  publicAuthorM2M               5000 non-null   object        
dtypes: bool(2), datetime64[ns](1), float64(17), int64(4), object(26)
memory usage: 1.8+ MB
```