Help with invalid literal for int() with base 10

[jiajun.j.yuan]

I have encountered the following problem in Cleaning and Preparing Data in Python 8/10.

def process_date(date_list):
    `split_date = []`
    res_list = []
    for entry in date_list:
        if '-' in entry:
            split_date = entry.split('-')
            date_1 = int(split_date[0])
            date_2 = int(split_date[1])
            res = round((date_1 + date_2) / 2)
            res_list.append(res)
        else:
            res = int(entry)
            res_list.append(res)
    return res_list

The int returns “invalid literal for int() with base 10”.

The code should work as it works for a smaller dataset.

[alvinctk]

I have encountered the following problem in Cleaning and Preparing Data in Python 8/10.

Please provide the url to the mission.

def process_date(date_list):
split_date =
res_list =
for entry in date_list:
if ‘-’ in entry:
split_date = entry.split(’-’)
date_1 = int(split_date[0])
date_2 = int(split_date[1])
res = round((date_1 + date_2) / 2)
res_list.append(res)
else:
res = int(entry)
res_list.append(res)
return res_list`

Use back ticks to format the code. See the post below on how to use back ticks.

Discourse post - markdown formatting a block of code to improve readability

By formatting a block to show indentation helps in better code readability, and easier to read and faster response from the community if you ever post a question here.

Using triple back ticks to format a block of code

Transform the text from x = 67 for i in range(100): if i < x: print(i) else: print(x+i) by using ``` triple back ticks to format a block of code to show indent x = 67 for i in range(100): if i < x: print(i) else: print(x+i) , and transform the code into the following…

[alvinctk]

The int returns “invalid literal for int() with base 10”.

The conversion is invalid because the string to be converted does not contains numeric digits.

[jiajun.j.yuan]

@alvinctk
Formatted.
But how can this be? This is what I see when print the dates.
The process_date() function should convert this data.

[alvinctk]

I have to check on the code itself. Please provide the url to the mission. Thanks.

[jiajun.j.yuan]

Of source, please use this link:
https://app.dataquest.io/m/351/cleaning-and-preparing-data-in-python/8/parsing-numbers-from-complex-strings-part-two

[alvinctk]

Here is my working code:

def process_date(s):
    if "-" in s:
        x, y = map(int, s.split("-"))
        return round((x+y)/2)
    else:
        return int(s)

processed_test_data = [process_date(s) for s in stripped_test_data]
for row in moma:
    row[6] = process_date(strip_characters(row[6]))
    

[alvinctk]

For mission 351 - parsing-numbers from complex strings part two:

Your code with error:

def process_date(date_list):
    `split_date = []`
    res_list = []
    for entry in date_list:
        if '-' in entry:
            split_date = entry.split('-')
            date_1 = int(split_date[0])
            date_2 = int(split_date[1])
            res = round((date_1 + date_2) / 2)
            res_list.append(res)
        else:
            res = int(entry)
            res_list.append(res)
    return res_list

It needs to return an integer and not a list.

About your bug/error:

    for entry in date_list:
       

The code above loop through each character of a given string.

When character entry = "-",

And perform split_date = entry.split('-').

It becomes split_date = [""].

When you try to convert

date_1 = int(split_date[0])
date_1 = int("") 

That’s when the error happens because you cannot convert an empty string into an integer.

To fix your bug/error:

def process_date(entry):

    if '-' in entry:
        split_date = entry.split('-')
        date_1 = int(split_date[0])
        date_2 = int(split_date[1])
        return round((date_1 + date_2) / 2)
            
    else:
       return int(entry)

Or my alternative solution:

def process_date(s): 
     if "-" in s: 
       x, y = map(int, s.split("-")) 
       return round((x+y)/2) 
    else: 
       return int(s)

Entire solution:

Here is my working code:

def process_date(s):
    if "-" in s:
        x, y = map(int, s.split("-"))
        return round((x+y)/2)
    else:
        return int(s)

processed_test_data = [process_date(s) for s in stripped_test_data]
for row in moma:
    row[6] = process_date(strip_characters(row[6]))
    

[alvinctk]

Hey @jiajun.j.yuan,

I have updated my above post with commentary on why your bug happens and a fix for your bug.

Let me know if you have any more queries.

We have a solved feature that allows you the ability to mark something as the “correct” answer, which helps future students with the same question quickly find the solution they’re looking for.

Here’s an article on how to mark posts as solved - I don’t want to do this for you until I know that solution/explanation works.

Best,
Alvin

[jiajun.j.yuan]

@alvinctk
Thanks.
Looking at the raw data, I see there were entries like '-1914', which explains why int("") doesn’t work.

But when I tried both the solution method and your method, they also failed with '-1914'. If it cannot solve this instance, how can it solve a list?

Solution method:

Your method:

[alvinctk]

The data input into the function process_date is one of the following:

• a single year - i.e. “1999”
• a year range - i.e. “1900-1999”

In your example, the data input is not supported by the function process_date. Of course it will break.

>>> "-1914".split("-")
['', '1914']

Since the first index is an empty string.

[alvinctk]

Here is my entire code that pass the checker.

test_data = ["1912", "1929", "1913-1923",
             "(1951)", "1994", "1934",
             "c. 1915", "1995", "c. 1912",
             "(1988)", "2002", "1957-1959",
             "c. 1955.", "c. 1970's", 
             "C. 1990-1999"]

bad_chars = {"(",")","c","C",".","s","'", " "}

def strip_characters(string):
     return "".join(c for c in string if c not in bad_chars)

stripped_test_data = ['1912', '1929', '1913-1923',
                      '1951', '1994', '1934',
                      '1915', '1995', '1912',
                      '1988', '2002', '1957-1959',
                      '1955', '1970', '1990-1999']

def process_date(s):
    if "-" in s:
        x, y = map(int, s.split("-"))
        return round((x+y)/2)
    else:
        return int(s)

processed_test_data = [process_date(s) for s in stripped_test_data]
for row in moma:
    row[6] = process_date(strip_characters(row[6]))

[alvinctk]

Looking at the raw data, I see there were entries like '-1914' ,

If you download the raw data artworks.csv, you can see there are no entries of “-year”. On the DQ platform, column six of artworks.csv shows a cropped value “1889-” since it is longer than the column width.
On the artworks.csv, its value is “1889-1911”.

[jiajun.j.yuan]

@alvinctk
If you download the raw data artworks.csv, you can see there are no entries of “-year”.

Python may read those values as (1940), or negative.
But please take a look at this:

[alvinctk]

These are values from moma's Date column:

[‘1986’,
‘1978’,
‘1889-1911’,
‘1927-1940’,
‘1903’,
‘1957’,
‘1924’,
‘1978-1983’,
‘2001’,
‘(1941)’,
‘1949-1950’,
‘1963’,
‘1908-1911’,
‘(1934)’,
‘1997’,
‘(1931-1933)’,
‘1972’,
‘1967’,
‘1923-1924’,
‘1979’,
‘1925-1927’,
‘1929’,
‘1972’,
‘1974’,
‘1957’,
‘1920-1930’,
‘1974’,
‘1915’,
‘1912’,
‘1988-1990’,
‘1925’,
‘c. 1925’,
‘1980’,
‘1964’,
‘1968’,
‘1969’,
‘1934’,
‘1953’,
‘1971’,
‘1988’,
‘1818’,
‘2002’,
‘1926’,
‘1969’,
‘1914’,
‘1979’,
‘1968’,
‘1979’,
‘1966’,
‘1904’,
‘1949’,
‘1981’,
‘1970’,
‘1969’,
‘1972’,
‘1923-1925’,
‘1967’,
‘1932’,
‘1928’,
‘1965’,
‘2003’,
‘1971-1974’,
‘1983’,
‘1930’,
‘1946’,
‘1984’,
‘2006’,
‘c. 1885’,
‘1942’,
‘1913’,
‘2015’,
‘1987’,
‘1947-1949’,
‘1965’,
‘1818’,
‘1961’,
‘1925’,
‘1916-1932’,
‘1962’,
‘1944’,
‘1930’,
‘1991’,
‘1991-1994’,
‘2008’,
‘1975’,
‘1893’,
‘1966’,
‘1968-1969’,
‘1964-1968’,
‘1928-1939’,
‘1969’,
‘1942’,
‘1980’,
‘1955’,
‘1930’,
‘c. 1955-1960’,
‘1922’,
‘c.1934’,
‘1903’,
‘2008’,
‘1962’,
‘1944’,
‘1914-1918’,
‘(2003)’,
‘2012’,
‘1965’,
‘1865’,
‘1976’,
‘1902’,
‘2003’,
‘2010’,
‘1944’,
‘1963’,
‘1875’,
‘1948’,
‘1990’,
‘1913’,
‘1958’,
‘1921’,
‘1970’,
‘1950’,
‘2004’,
‘1926’,
‘1973’,
‘1915’,
‘2003’,
‘1973’,
‘1986’,
‘1982’,
‘1908-1911’,
‘1934’,
‘1971’,
‘(1926)’,
‘1960’,
‘1939’,
‘1893’,
‘c.1952’,
‘2007’,
‘1933-1947’,
‘1995’,
‘1973’,
‘1939’,
‘1913’,
‘1908’,
‘1971’,
‘1936’,
‘1960’,
‘1975’,
‘1976’,
‘2005’,
‘1933’,
‘1957’,
‘1960’,
‘1982’,
‘1956’,
‘1910’,
‘1983’,
‘1968-1977’,
‘1969’,
‘1965’,
‘1919-1920’,
‘1923-1948’,
‘c.1973’,
‘1912-1926’,
‘1905’,
‘1918’,
‘1997’,
‘1875’,
‘1907’,
‘1926-1946’,
‘1999’,
‘1929’,
‘1991-1994’,
‘1971’,
‘1942’,
‘1933’,
‘1965’,
‘1936-1937’,
‘2011’,
‘1978-1979’,
‘1951’,
‘1926’,
‘2004’,
‘1919-1920’,
‘1965-1966’,
‘1923-1951’,
‘1991’,
‘1916-1932’,
‘1964’,
‘1969’,
‘2001’,
‘1953’,
‘1965’,
‘1913’,
‘1930’,
‘(c. 1900-1910)’,
‘2010’,
‘1992’,
‘1913’,
‘1931-1956’,
‘1875’,
‘1989’,
‘1962’,
‘2010’,
‘1964’,
‘1927’,
‘1997’,
‘1962’,
‘c. 1940’,
‘1952’,
‘c.1946’,
‘1960’,
‘1900’,
‘2013’,
‘1928’,
‘1978’,
‘1986’,
‘1899-1900’,
‘1920-1930’,
‘1932’,
‘1985-1986’,
‘1966’,
‘1968’,
‘1974’,
‘1998’,
‘2000’,
‘2006’,
‘1967’,
‘1965’,
‘1927’,
‘2004’,
‘1979’,
‘(1916)’,
‘2009’,
‘1978’,
‘1964’,
‘1958’,
‘1872-1927’,
‘1967’,
‘1988’,
‘1928’,
‘2003’,
‘c. 1923-1924’,
‘1964’,
‘c. 1900’,
‘1975’,
‘1978’,
‘1913-1921’,
‘1826-1896’,
‘1929’,
‘1991’,
‘2012’,
‘1926-1938’,
‘1982’,
‘1963’,
‘1962-1963’,
‘(1919)’,
‘1970-1971’,
‘1959-1965’,
‘2000’,
‘2004’,
‘1877’,
‘1914’,
‘1949-1950’,
‘1956’,
‘2004’,
‘1948’,
‘1921-1922’,
‘1965’,
‘1933’,
‘1910’,
‘1970’,
‘1947-1955’,
‘1881’,
‘1932’,
‘2006’,
‘1953-1954’,
‘1943-1981’,
‘1994’,
‘2006’,
‘(1965)’,
‘1942’,
‘1931-1956’,
‘1977’,
‘2005’,
‘1967’,
‘1971-1973’,
‘1981’,
‘1972’,
‘1955-1956’,
‘2008’,
‘1963’,
‘1926’,
‘1922’,
‘c. 1964’,
‘1899-1900’,
‘1911-1950’,
‘1920’,
‘1946-1949’,
‘1956’,
‘1982’,
‘1908-1911’,
‘1947’,
‘1946-1947’,
‘1938’,
‘1996’,
‘1998’,
‘1988’,
‘1973’,
‘1972’,
‘1970-1972’,
‘1925-1927’,
‘1971-1974’,
‘1921’,
‘1964’,
‘1943’,
‘1961’,
‘1935’,
‘1939’,
‘1977’,
‘2003’,
‘1961’,
‘2001’,
‘(1966)’,
‘1975’,
‘1900-1953’,
‘(2008-2010)’,
‘1988’,
‘1917’,
‘1930’,
‘1978’,
‘2007’,
‘1920’,
‘1902’,
‘1818’,
‘1925’,
‘1984’,
‘1929’,
‘1857’,
‘1943-1981’,
‘1973’,
‘1934’,
‘1980’,
‘1921’,
‘1995’,
‘1969’,
‘1971’,
‘1958’,
‘1931’,
‘1925-1927’,
‘1976’,
‘1989-1990’,
‘1967’,
‘1953’,
‘1961’,
‘1999-2001’,
‘1935’,
‘1962-1965’,
‘1940’,
‘2001’,
‘c. 1912’,
‘1933’,
‘1941’,
‘c. 1965’,
‘1971’,
‘1958’,
‘1994’,
‘1976’,
‘c. 1940’,
‘1959’,
‘1935’,
‘1993’,
‘1965’,
‘1982’,
‘1972’,
‘1985’,
‘1985’,
‘1975’,
‘1998’,
‘1933’,
‘1923’,
‘1934’,
‘2005’,
‘c. 1930-1931’,
‘1930’,
‘1979-1984’,
‘1928’,
‘c. 1938-1960’,
‘1973’,
‘c. 1930’,
‘1919’,
‘1995’,
‘1932’,
‘1939’,
‘c.1931’,
‘1923-1948’,
‘1971’,
‘1981’,
‘1861’,
‘c.1970’,
‘1931’,
‘2001’,
‘1998-2003’,
‘1961’,
‘1978’,
‘1977-1978’,
‘1997-2000’,
‘1948’,
‘1958’,
‘1999’,
‘1921’,
‘1981’,
‘1982’,
‘1966’,
‘(1928-1939)’,
‘1908-1950’,
‘1964’,
‘c. 1945’,
‘1990’,
‘2011’,
‘1930’,
‘1968’,
‘c. 1962’,
‘1953’,
‘2000’,
‘1975’,
‘1933’,
‘1926-1938’,
‘(1926)’,
‘1906-1912’,
‘1988’,
‘1972’,
‘(1970)’,
‘c. 1977’,
‘1980’,
‘1975-1976’,
‘1997’,
‘1959’,
‘1918’,
‘1900-1943’,
‘1958’,
‘c. 1951-1952’,
‘1960’,
‘1977’,
‘1991-1994’,
‘c.1937-1938’,
‘1818’,
‘c. 1976’,
‘1898’,
‘(c. 1930)’,
‘1969’,
‘2000’,
‘1985’,
‘1983’,
‘(c. 1918)’,
‘1927’,
‘1949-1950’,
‘1946’,
‘1970’,
‘1907’,
‘1960’,
‘1917’,
‘c. 1950’,
‘1912’,
‘1970’,
‘2001’,
‘1972’,
‘1912’,
‘1982’,
‘1922’,
‘1964’,
‘1985-1990’,
‘1949’,
‘c. 1938-1960’,
‘1962’,
‘1911’,
‘1938’,
‘c. 1921’,
‘1928’,
‘(c. 1914-1920)’,
‘1946’,
‘2001’,
‘1944’,
‘1963’,
‘1899-1900’,
‘1972’,
‘1922’,
‘1951’,
‘1928’,
‘c.1952’,
‘2013’,
‘1927’,
‘1921’,
‘1968’,
‘1899’,
‘1914’,
‘1947-1955’,
‘1976’,
‘1966’,
‘1964-1968’,
‘1970’,
‘1916-1923’,
‘(1911)’,
‘1913’,
‘1959’,
‘1985’,
‘1921’,
‘1975’,
‘1988’,
‘1937’,
‘1972’,
‘2003’,
‘1949’,
‘1975’,
‘(1952)’,
‘1965’,
‘1905’,
‘2010’,
‘1950-1953’,
‘1967’,
‘1980’,
‘1954’,
‘2002’,
‘1893-1896’,
‘1999’,
‘1960-1963’,
‘(c .1981)’,
‘1953’,
‘1994’,
‘2001’,
‘1967’,
‘1923-1924’,
‘1911’,
‘(c. 1918)’,
‘1963’,
‘1976’,
‘1967’,
‘1965’,
‘c. 1919’,
‘1974’,
‘1924’,
‘c. 1950-1952’,
‘1931’,
‘1965-1966’,
‘1990’,
‘1913-1921’,
‘1887’,
‘1957’,
‘1873’,
‘1928’,
‘1936’,
‘1964’,
‘1950’,
‘1923-1948’,
‘1930’,
‘1939-1945’,
‘1967’,
‘1978’,
‘1973’,
‘1995’,
‘1985-1990’,
‘1925’,
‘1975-1986’,
‘c. 1860’,
‘1926’,
‘1901’,
‘2013-2014’,
‘1900-1943’,
‘1977’,
‘1971’,
‘1986’,
‘2004’,
‘1948’,
‘1954-1958’,
‘1926’,
‘1933’,
‘1966’,
‘1975’,
‘1933-1947’,
‘1998’,
‘1925’,
‘1919-1921’,
‘1923-1924’,
‘(1960)’,
‘1970-1971’,
‘1946-1972’,
‘2005’,
‘1968’,
‘1949’,
‘(c. 1914-1920)’,
‘1979’,
‘1931’,
‘1928-1939’,
‘1971’,
‘1992’,
‘1945’,
‘1961’,
‘1911’,
‘1966’,
‘2007’,
‘1963’,
‘1941’,
‘1898’,
‘2003’,
‘1984-1985’,
‘1990’,
‘1951’,
‘1999-2001’,
‘1938’,
‘1930’,
‘1826-1896’,
‘1968’,
‘1971’,
‘1946’,
‘c. 1972’,
‘1911’,
‘1978’,
‘1910’,
‘1858-1860’,
‘1963’,
‘1970’,
‘2010’,
‘1939-1943’,
‘1951’,
‘1966’,
‘1927’,
‘1942’,
‘1938’,
‘2009’,
‘1968’,
‘1912’,
‘1901’,
‘2000’,
‘1937’,
‘1936’,
‘1921-1922’,
‘1926’,
‘1921’,
‘1983’,
‘1981’,
‘1962’,
‘1978’,
‘1946-1972’,
‘(c. 1905)’,
‘1968’,
‘1967-1968’,
‘1980’,
‘1982’,
‘2013’,
‘1991’,
‘1912’,
‘1964-1968’,
‘c. 1943’,
‘c. 1950’,
‘(1966)’,
‘1960’,
‘1924’,
‘1957’,
‘1981’,
‘1996’,
‘1998’,
‘1925’,
‘1958’,
‘1968’,
‘c. 1925’,
‘1946-1972’,
‘c. 1946’,
‘2007’,
‘1962-1965’,
‘1893-1894’,
‘1941’,
‘1958’,
‘1946’,
‘1978’,
‘1928-1939’,
‘1875’,
‘c. 1938’,
‘1994’,
‘c. 1899’,
‘1975-1976’,
‘1857’,
‘1983’,
‘1980’,
‘1908’,
‘(1989)’,
‘1966’,
‘1952’,
‘c. 1964’,
‘2006’,
‘1948’,
‘1904’,
‘1979’,
‘1990’,
‘1938’,
‘1900-1910’,
‘1983’,
‘1953’,
‘1997’,
‘2002’,
‘1959’,
‘1972’,
‘1950’,
‘1991’,
‘1974’,
‘1932’,
‘1981’,
‘1908’,
‘1997’,
‘1937’,
‘1968’,
‘1990’,
‘1843-1847’,
‘1985’,
‘1930’,
‘1985’,
‘1955’,
‘1948’,
‘1977’,
‘2003’,
‘1933’,
‘1968’,
‘1944-1945’,
‘1970-1972’,
‘1963’,
‘1934’,
‘1956’,
‘1949’,
‘1910’,
‘1959’,
‘1925-1927’,
‘1974’,
‘c. 1929’,
‘1968’,
‘1916-1932’,
‘2007’,
‘1921’,
‘1970’,
‘1919’,
‘1932’,
‘1978’,
‘1951’,
‘1909’,
‘2003’,
‘c. 1950’,
‘1913’,
‘c. 1945’,
‘1999’,
‘c. 1990’,
‘1997’,
‘1924’,
‘2015’,
‘1972’,
‘1907’,
‘1936’,
‘1968-1977’,
‘1992-2000’,
‘1938’,
‘1961’,
‘1951’,
‘1956’,
‘1964’,
‘1964’,
‘1931-1937’,
‘1964’,
‘c. 1900’,
‘2009’,
‘1942’,
‘1928’,
‘1943’,
‘2006’,
‘2011’,
‘2004’,
‘1939-1945’,
‘(1923)’,
‘2004’,
‘1962-1963’,
‘1899-1900’,
‘1998-2009’,
‘1959’,
‘1943’,
‘2001’,
‘1963’,
‘1977’,
‘1961’,
‘1959’,
‘(2004)’,
‘1945’,
‘1980’,
‘1932’,
‘1926’,
‘2004’,
‘1934’,
‘2013’,
‘1996’,
‘(2003)’,
‘1926’,
‘2001’,
‘1966’,
‘(2003)’,
‘1947’,
‘1934’,
‘1976-1977’,
‘1939’,
‘1994’,
‘(1993)’,
‘1930’,
‘2006’,
‘1916’,
‘2002’,
‘1984’,
‘1970’,
‘1965’,
‘1960’,
‘1978’,
‘1993’,
‘1938’,
‘1959’,
‘1922’,
‘2009’,
‘1981’,
‘1997’,
‘1992’,
‘(1987)’,
‘1989’,
‘2007’,
‘1962’,
‘1951’,
‘1907’,
‘1970’,
‘c. 1920’,
‘1943’,
‘1923’,
‘(1951)’,
‘1914’,
‘1975’,
‘1945’,
‘1954’,
‘1946-1948’,
‘1998’,
‘2008’,
‘1965’,
‘1913’,
‘c. 1962’,
‘1942’,
‘1993’,
‘1991’,
‘1984’,
‘1934’,
‘1967’,
‘1990’,
‘1932’,
‘1958’,
‘1950’,
‘1957’,
‘1915’,
‘1927-1943’,
‘(2008-2010)’,
‘1925’,
‘1989’,
‘1929’,
‘c.1980’,
‘1969’,
‘1864-1865’,
‘c. 1938-1960’,
‘1953’,
‘1924’,
‘1925’,
‘1927’,
‘2006’,
‘(2002)’,
‘1969-1971’,
‘2007’,
‘1963’,
‘1983-1984’,
‘c. 1967’,
‘1972’,
‘1983’,
‘2002-2003’,
‘1961’,
‘1955’,
‘1967-1969’,
‘1951’,
‘2004-2005’,
‘1927-1952’,
‘1946’,
‘1993’,
‘2013’,
‘1977’,
‘1995’,
‘1946’,
‘1972-1973’,
‘1972’,
‘1962-1963’,
‘1930’,
‘1984’,
‘2005’,
‘1937-1939’,
‘1954-1957’,
‘2002’,
‘1940’,
‘(1992)’,
‘1921’,
‘1984’,
‘1926’,
‘1933’,
‘1963’,
‘c. 1930’,
‘1968’,
‘1958’,
‘1928-1930’,
‘1973’,
‘1927-1952’,
‘1951’,
‘2002’,
‘1976’,
‘1900’,
‘2004-2006’,
‘1991-1994’,
‘1909’,
‘1967’,
‘1964’,
‘c. 1920’,
‘1986’,
‘1908’,
‘2001-2003’,
‘1979-1984’,
‘(2000)’,
‘1906-1912’,
‘1900-1943’,
‘1979’,
‘1996’,
‘1946’,
‘1984’,
‘1956’,
‘1963’,
‘1924-1926’,
‘1970’,
‘1965’,
‘1961’,
‘1950’,
‘1938’,
‘(1961)’,
‘1970-1996’,
‘1898’,
‘1929’,
‘2001-2008’,
‘1970s’,
‘1995’,
‘1960’,
‘1973’,
‘1973’,
‘c. 1919’,
‘1962’,
‘1905’,
‘c. 1914’,
‘1979’,
‘1970’,
‘(1972)’,
‘1997’,
‘1912’,
‘1998’,
‘2003’,
‘1973’,
‘1874’,
‘c. 1950-1952’,
‘1970’,
‘1973’,
‘1981’,
‘1959’,
‘1988’,
‘1961’,
‘1906-1912’,
‘1961’,
‘1893’,
‘1996’,
‘1962’,
‘1967’,
‘1968’,
‘1931-1937’,
‘1972’,
‘1972’,
‘1984’,
‘1992’,
‘1920-1930’,
‘1990’,
‘1998’]

There are no mentioned of “-year”.

[alvinctk]

moma has been cleaned from artworks.csv.
The mission uses moma.

[jiajun.j.yuan]

I understand. I will try again.

[alvinctk]

Print the 11th line from artworks.csv

sed -n "11p" artworks.csv 

STILL WATER AND FISH,David Brown Milne,(Canadian),(1882),(1953),(Male),(1941),Prints & Illustrated Books

Print the 11th line, 7th column (or 6th column when counting with 0)

sed -n "11p" artworks.csv | awk -F "," '{print $7}'

(1941)

In Microsoft Excel, (1941) becomes negative because of the parenthesis ( and ).

[jiajun.j.yuan]

@alvinctk
Thanks for your help. I tried to create a function that takes list as input, and list as output, without having to loop through each one. But that means I cannot change row[6] while looping through individual elements.

Pandas can probably update a whole list with another list, but that’s for another day.