def member_english(a_string): for character in a_string: if ord(character) > 127: return False else: return True

test_app_names = ['Instagram', '爱奇艺PPS -《欢乐颂2》电视剧热播', 'Docs To Go™ Free Office Suite', 'Instachat 😜'] for app_name in test_app_names: eng_or_non_eng = member_english(app_name) print(app_name + " is in English : ", eng_or_non_eng) It is checking just the First Character. what's the difference between putting "Return True" inside the loop with else statement and outside the loop, If I put it outside, It works fine . I'm getting a little confused here.

Hi,

I could not find the guided project for https://app.dataquest.io/m/469/guided-project%3A-popular-data-science-questions/2/stack-exchange

https://github.com/dataquestio/solutions/blob/master/Mission469Solutions.ipynb is not found

Thanks,

Links for data sets are giving 404 error

• Google play store: https://www.kaggle.com/lava18/google-play-store-apps/home
• App store : https://www.kaggle.com/ramamet4/app-store-apple-data-set-10k-apps/home

they should be

• Google play store: https://www.kaggle.com/lava18/google-play-store-apps
• App store : https://www.kaggle.com/ramamet4/app-store-apple-data-set-10k-apps

While defining under_100_m = [], the aim is to keep only communication applications with less than 100m installs. However, the code in the solution keeps all applications with less than 100m installs. Below is a suggestion on how the code might look like:

under_100_m = []

for app in android_final:
    n_installs = app[5]
    n_installs = n_installs.replace(',', '')
    n_installs = n_installs.replace('+', '')
    if float(n_installs) < 100000000 and (app[1] == 'COMMUNICATION'):
        under_100_m.append(float(n_installs))
        
sum(under_100_m) / len(under_100_m)

Couple of questions

In [8]: import sqlite3 import pandas as pd

conn = sqlite3.connect("factbook.db") cursor = conn.cursor() cursor.execute(q1).fetchall()

The q1 is missing?

Also, you have two q7 queries, and the second q7 is identical to q6.

I'm using jupiter provided by dataquest and I get an error "ERROR: Line magic function %mathplotlib not found". I searched online and the solutions are variants of installation of more recent versions of python. But since the jupiter resides on your server, I can't do that. Can you please suggest a solution? Thanks.

The solution for calculating low stock (in screen 4) is wrongly sorted in ascending order. The code:

SELECT productCode, 
       ROUND(SUM(quantityOrdered) * 1.0 / (SELECT quantityInStock
                                             FROM products p
                                            WHERE od.productCode = p.productCode), 2) AS low_stock
  FROM orderdetails od
 GROUP BY productCode
 ORDER BY low_stock
 LIMIT 10;

wrongly assumes that a higher priority for restocking is given to products with a lower "low_stock" value. The code clearly shows that a lower value will correspond with a lower quantityordered and/or higher quantityInStock. This is clearly against the purpose stated in the project's instructions.

A simple correction can be made to the code by simply sorting by descending

Hello, I'm at mission 610 and I have a problem when I try replace the full date with just the year:

This is the code I'm using.

for row in data:
    date = fetch_year(row[0])
    row[0] = date

This is the error I get...

TypeError                                 Traceback (most recent call last)
<ipython-input-10-8a078f6cee5c> in <module>
      1 for row in data:
----> 2     date = fetch_year(row[0])
      3     row[0] = date

~/notebook/helper.py in fetch_year(date_string)
     10 
     11 def fetch_year(date_string):
---> 12     return int(re.findall("\d{4}", date_string)[0])
     13 
     14 def barplot(list_of_2_element_list):

/dataquest/system/env/python3/lib/python3.8/re.py in findall(pattern, string, flags)
    237 
    238     Empty matches are included in the result."""
--> 239     return _compile(pattern, flags).findall(string)
    240 
    241 def finditer(pattern, string, flags=0):

TypeError: expected string or bytes-like object

About the Mission191Solutions.ipynb It seems that all album_id is not null and is a real album. We have sales/listen/plays in 2 tracks of the same artist, which is not a proper album. Could you please explain the last query?

Following the guide on Mission350Solutions.ipynb (I really appreciate this rookie-friendly notebook),I have found something about duplicated apps.🤒

Firstly,it's not proper to judge duplicated apps just by thier names.For example,there are two apps from different types(game and family) both named Solitaire,but you will loss this information if you only judge duplication by apps' name. Secondly,for certain app named Cardiac diagnosis (heart rate, arrhythmia),it has both free version and paid version,if you do the same thing like you did on Solitaire,you will miss the free data or the paid data which will influence your analysis on all free apps.

Not sure if I make myself clear,once again,I reallyyyyy appreciate your brilliant work!!!