Chinese culture impact on Seattle Public Library readers
MAT 259, 2022
Ziyu Zhang
Concept
I have always been interested in Culture Exposure from various counties, especially my country, China. Therefore,
through the analysis of the data in Seattle Public Library, I want to find out the Chinese cultural impact on the
people in the United States from 2006 till today. With the continuous development of culture and technology in
China, the main content and symbols of Chinese culture exposure have also kept pace with times and made corresponding
changes. Setting books as the object of analysis, I first collected statistics on the types of books people borrowed
the most. Taking 2006-2010\2011-2015\2016-2020 as the time boundary, I planned to analyze the trend of Chinese
cultural exposure through changes in the number of times people borrowed related books in three time periods.
Query
SELECT
title, bibNumber, COUNT(bibNumber) AS counts, itemtype
FROM
spl_2016.outraw
WHERE
(itemtype like '%bk')
AND (title LIKE '%Chinese%'
OR title LIKE '%China%')
AND(Year(cout) >= 2006 and Year(cout) <= 2010)
GROUP BY bibNumber , itemtype , title
ORDER BY counts DESC
SELECT
title,
bibNumber,
COUNT(bibNumber) AS counts,
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 1) THEN 1
ELSE 0
END) AS '2006-1',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 2) THEN 1
ELSE 0
END) AS '2006-2',
...
FROM
spl_2016.outraw
WHERE
(bibNumber = '2381540')
OR (bibNumber = '2404748')
OR (bibNumber = '2471718')
OR (bibNumber = '2347391')
OR (bibNumber = '2280147')
OR (bibNumber = '2174575')
OR (bibNumber = '1100731')
OR (bibNumber = '2067046')
OR (bibNumber = '2484700')
OR (bibNumber = '2530375')
GROUP BY bibNumber , itemtype , title
ORDER BY counts DESC
title, bibNumber, COUNT(bibNumber) AS counts, itemtype
FROM
spl_2016.outraw
WHERE
(itemtype like '%bk')
AND (title LIKE '%Chinese%'
OR title LIKE '%China%')
AND(Year(cout) >= 2006 and Year(cout) <= 2010)
GROUP BY bibNumber , itemtype , title
ORDER BY counts DESC
SELECT
title,
bibNumber,
COUNT(bibNumber) AS counts,
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 1) THEN 1
ELSE 0
END) AS '2006-1',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 2) THEN 1
ELSE 0
END) AS '2006-2',
...
FROM
spl_2016.outraw
WHERE
(bibNumber = '2381540')
OR (bibNumber = '2404748')
OR (bibNumber = '2471718')
OR (bibNumber = '2347391')
OR (bibNumber = '2280147')
OR (bibNumber = '2174575')
OR (bibNumber = '1100731')
OR (bibNumber = '2067046')
OR (bibNumber = '2484700')
OR (bibNumber = '2530375')
GROUP BY bibNumber , itemtype , title
ORDER BY counts DESC
Process
Final result
As we can see from the above, man who loved China the fantastic story of the eccentric scientist who unlocked the mysteries of the Middle Kingdom, is the most popular Chinese cultural book of all time. And the top 3 topics of Chinese culture in books are travelog, novel and cookbook.
As we can see from the above, China study the most comprehensive study of nutrition ever conducted and the startling implications for diet weight loss and long term health and American born Chinese, are the most popular Chinese cultural books of all time. And the top 3 topics of Chinese culture in books are documentary, health and novel.
As we can see from the above, China rich girlfriend a novel, has two peaks in a series of sluggish curves, which is irregular and anomaly. And the top 3 topics of Chinese culture in books are novel, documentary and cookbook.
Above all, we can see that the time when the local people were most enthusiastic about borrowing Chinese cultural books was from 2006 to 2010, and the topics they were most interested in were food, novel and documentary. Therefore, based on the above data, it can be inferred that China's current cultural exposure is mainly focused on history, literature and food. However, it has not achieved the publicity of the technology, Chinese tradition and other precious culture and wealth that belong to China's historical precipitation and modern development. This is likely to cause local residents to stereotype or not have a comprehensive understanding of Chinese culture.
Code