Video by Keith Galli on YouTube · 60 min. We did not make this video and we do not host it — watching it here still counts as a view for the creator.
Load the CSV with pd.read_csv and clean duplicate URLs, trim whitespace, and extract domain names. A frequent beginner error is chaining operations without assigning back, which leaves the DataFrame unchanged. Use df.drop_duplicates(subset='url') and df['domain'] = df['url'].apply(lambda x: urlparse(x).netloc). Clean data ensures that KPI calculations like citation count are reliable, a step that agencies perform before presenting any audit to clients.
Sign in with your email, Google or GitHub. No password to remember. The same account carries your progress, your certificates and anything else you do with Nexgino later.
Sign in to continueIt takes about fifteen seconds.